IBM Support

IC74043: DB2LOOK MAY GENERATE INCORRECT TABLESPACE CONTAINER INFORMATION FOR PARTITIONED DATABASES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2LOOK may generate incorrect tablespace information when
    multiple DB2LOOK commands that retrieve tablespace layout
    information are run at the same time.
    
    The same container name may be duplicated (as in the example
    below where there is actually only one container) or there could
    be missing containers:
    CREATE REGULAR TABLESPACE "REG1" IN DATABASE PARTITION GROUP
    IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING
    
    ('/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1',
    '/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1') ON
    DBPARTITIONNUMS (0)
    

Local fix

  • Run db2look serially.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2LOOK may generate incorrect tablespace information when   *
    *                                                              *
    * multiple DB2LOOK commands that retrieve tablespace layout    *
    *                                                              *
    * information are run at the same time.                        *
    *                                                              *
    *                                                              *
    *                                                              *
    * The same container name may be duplicated (as in the example *
    *                                                              *
    * below where there is actually only one container) or there   *
    * could                                                        *
    * be missing containers:                                       *
    *                                                              *
    * CREATE REGULAR TABLESPACE "REG1" IN DATABASE PARTITION GROUP *
    *                                                              *
    * IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING            *
    *                                                              *
    *                                                              *
    *                                                              *
    * ('/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1',       *
    *                                                              *
    * '/home/db2inst1/db/db2inst1/NODE0000/SQL00002/CONT1') ON     *
    *                                                              *
    * DBPARTITIONNUMS (0)                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v97 fixpack 5.                                    *
    ****************************************************************
    

Problem conclusion

  • First fixed in v97 fixpack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74043

  • 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-01-21

  • Closed date

    2011-12-19

  • Last modified date

    2011-12-19

  • 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 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74043

Modified date: 19 December 2011