JR28335: RESTORE USING A DB2 64BIT BACKUP IMAGE TO A DB2 32BIT ENVIRONMENT FAILS WITH SQL2038 - SQL5130 (HADR_DB_ROLE).

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Similar issue as APAR # JR23551. However, database_memory is not
  the only parameter that would fail with SQL2038 - SQL5139
  <HADR_DB_ROLE> when restoring a 64 bit backup image into a db2
  32 bit environment
  
  
  Cause:
  
  Cause...
  The db cfg param PCKCACHESZ exists as U64BIT. This parameter has
  different max values on 64 bit machines and a lesser max value
  on 32 bit machines.
  
  This APAR fix will set the PCKCACHESZ value to the default
  value, if the restore finds that it's beyond the 32bit range.
  This change will be logged in the db2diag.log as well.
  

Local fix

• Set the PCKCACHESZ to a lower value of about 128000 for 32bit
  machines. Set the value to this in the 64 bit machines and then
  take a backup and restore it on the 32 bit machine.
  

Problem summary

• Users affected: ALL
  
  Problem Description:
  RESTORE USING A DB2 64BIT BACKUP IMAGE TO A DB2 32BIT
  ENVIRONMENT FAILS WITH SQL2038 - SQL5130 (HADR_DB_ROLE).
  
  Problem Summary:
  Similar issue as APAR # JR23551. However, database_memory is not
  the only parameter that would fail with SQL2038 - SQL5139
  <HADR_DB_ROLE> when restoring a 64 bit backup image into a db2
  32 bit environment
  
  
  Cause:
  
  Cause...
  The db cfg param PCKCACHESZ exists as U64BIT. This parameter has
  different max values on 64 bit machines and a lesser max value
  on 32 bit machines.
  
  LOCAL FIX:
  Set the PCKCACHESZ to a lower value of about 128000 for 32bit
  machines. Set the value to this in the 64 bit machines and then
  take a backup and restore it on the 32 bit machine.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.1 Fixpack 6
  

Temporary fix

Comments

APAR Information

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

  JR28334

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

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP