IBM Support

IC99888: ADDING A PARTITION TO AN EXISTING BUFFERPOOL MAY NOT COPY ALL THE BUFFERPOOL INFORMATION TO THE NEW PARTITION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When adding a partition to an existing bufferpool (created with
    nonzero NUMBLOCKPAGES/BLOCKSIZE), NUMBLOCKPAGES/BLOCKSIZE can be
    both set to 0 on the newly added partition
    
    You can see the following after adding the partition:
    
    Current environment setup
    # db2 "create database partition group part0 on dbpartitionnum
    (0)"
    # db2 "create database partition group part1 on dbpartitionnum
    (1)"
    
    db2 "connect to test"
    
    db2 "create bufferpool buff1 immediate DATABASE PARTITION GROUP
    part0 NUMBLOCKPAGES 64 BLOCKSIZE 16"
    
    db2 "alter bufferpool buff1 ADD DATABASE PARTITION GROUP part1"
    
    db2 "select * FROM syscat.bufferpools
    
    "BUFF1",2,"PART0",-2,4096,"N",64,16,"PART0"
    "BUFF1",2,"PART1",-2,4096,"N",0,0,"PART1" <<< THE "0"'s here are
    NOT fine
    

Local fix

  • Alter the NUMBLOCKPAGES and BLOCKSIZE manually with ALTER
    bufferpool statement on the corresponding partition.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Version V9.7 Fix Pack 9 or below                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version V9.7 Fix Pack 10                      *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 Version V9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99888

  • 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

    2014-03-06

  • Closed date

    2014-12-01

  • Last modified date

    2014-12-01

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

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

    IT02441 IT02446

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 December 2014