IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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.
    

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

  • 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.
    
    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.5 Fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28336

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-01-17

  • Closed date

    2009-04-12

  • Last modified date

    2009-04-12

  • 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

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 April 2009