IBM Support

IC74930: UPGRADING DATABASES TO V9.7 VIA RESTORE FROM 64-BIT TO 32-BIT PL ATFORMS MAY FAIL DUE TO DATABASE CONFIGURATION PARAMETERS OUT OF

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Restore database from lower version of database from 64bit to
    32bit, the parameter are not automatically tuned.
    Following error is being hit while migrating database.
    
    
     SQL5131N  The value specified for the configuration parameter
    
     "pckcachesz" is
    
    
     not in the valid range.  The valid range is "-1", or from "32"
    
     to "128000".
    

Local fix

  • The workaround is simple of course - either:
    a) Change db config parameters to valid ranges for 32-bit
    platforms prior to taking the backup for the upgrade.
    b) Upgrade to a 64-bit instance in v9.7 first, then backup and
    restore the database into a 32-bit instance.
    
    (b) will work because we have the fix in place for restoring
    databases on the same release which will reset the config parms
    that are out of range.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Prior v9.7 FP4                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * 64 bit database migration to 32 bit architect machine        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade v9.7 fp5                                             *
    ****************************************************************
    

Problem conclusion

  • v9.7 FP5
    

Temporary fix

Comments

  • This is one time occurrence kind of situation
    

APAR Information

  • APAR number

    IC74930

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-09

  • Closed date

    2011-12-20

  • Last modified date

    2011-12-20

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74930

Modified date: 20 December 2011