IBM Support

JR28335: 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.
    
    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 number

    JR28335

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-01-17

  • Closed date

    2008-11-10

  • Last modified date

    2009-09-21

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021