IBM Support

IT37543: INDEX SPECIFICATION IS NOT CREATED WHEN THE NICKNAME IS CREATED IF THE INDEX KEY GREATER THAN 1024 BYTES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • When create a nickname on a remote table with an index and the
    index key is greater than 1024 bytes, the index specification is
    not created on the local database.
    
    There is no warning for this when the nickname is created,
    nothing in db2diag.log  and the documentation does not specify
    that the index will not be created in these conditions.
    
    Db2 code needs to be modified to create the index according to
    local page size, rather than limit it to 4K and display
    appropriate warnings when index specification cannot be created.
    

Local fix

  • Workaround - Manually create the nickname index specification.
    

Problem summary

Problem conclusion

Temporary fix

Comments

  • We will fix it in db2_main branch in feature, customer did not
    require code fix for this issue
    

APAR Information

  • APAR number

    IT37543

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-07-08

  • Closed date

    2021-11-03

  • Last modified date

    2021-11-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT37546

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022