LI72811: INCORRECT CONTAINER NAME REPLACEMENT BY DB2RELOCATEDB WHEN REGULAR CONTAINERS ARE PART OF AUTOMATIC STORAGE PATHS

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 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

• When regular container paths are located within the directory
  structure of an automatic storage path. Then it is is possible
  that db2relocatedb will rename the regular containers paths
  incorrectly if wildcard replacement is used.
  
  e.g. if the db2relocatedb config file contains :
  
  CONT_PATH=/xxx/yyy/data/subdir/*, /xxx/zzz/data/subdir/*
  STORAGE_PATH=/xxx/yyy/data, /xxx/zzz/data
  
  Then this may result in the the STORAGE_PATH setting being used
  to replace containers that are located in the subdir directory.
  

Local fix

• Workaround : Perform db2relocatedb twice, once only for regular
  containers ( commenting out the storage_path settings ) and then
  the second time, only for the storage_paths ( commenting out the
  cont_path settings ).
  

Problem summary

• Users Affected : db2relocatedb users with automatic storage
  table spaces.
  Problem summary : incorrect container name replacement
  Problem conclusion : container names are correctly replaced
  

Problem conclusion

• This problem was first fixed in v9.5 fixpak 2
  

Temporary fix

Comments

APAR Information

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

  LI72807

• 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