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

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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 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