LI73829: ADDING A NEW PARTITION TO A MULTI-PARTITIONED DATABASE FAILS WITH -1031 IF THE DATABASE DIRECTORY CONTAINS SYMBOLIC LINKS

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Suppose a database that uses automatic storage exists in a
  multi-paritition instance with multiple physical partitions.
  Furthermore, the local database directory contains symbolic
  links to different physical paths on each machine.
  When a new partition needs to be added, the ADD DBPARTITIONNUM
  command fails with SQLCODE -1031 because
  the storage path from a non-catalog partition cannot be resolved
  on the catalog partition.
  

Local fix

Problem summary

• Users Affected: All
  
  Problem Description:
  ADDING A NEW PARTITION TO A MULTI-PARTITIONED DATABASE FAILS
  WITH -1031 IF THE DATABASE DIRECTORY CONTAINS SYMBOLIC LINKS
  
  Suppose a database that uses automatic storage exists in a
  multi-paritition instance with multiple physical partitions.
  Furthermore, the local database directory contains symbolic
  links to different physical paths on each machine.
  When a new partition needs to be added, the ADD DBPARTITIONNUM
  command fails with SQLCODE -1031 because
  the storage path from a non-catalog partition cannot be resolved
  on the catalog partition.
  
  Problem Summary:
  Suppose a database that uses automatic storage exists in a
  multi-paritition instance with multiple physical partitions.
  Furthermore, the local database directory contains symbolic
  links to different physical paths on each machine.
  When a new partition needs to be added, the ADD DBPARTITIONNUM
  command fails with SQLCODE -1031 because
  the storage path from a non-catalog partition cannot be resolved
  on the catalog partition.
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fixpak 4
  

Temporary fix

Comments

APAR Information

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

  LI73828

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

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSY

     UP