IBM Support

IC96196: RENAME TABLESPACE NOT HANDLING ERROR DURING SYSTEM CATALOG UPDATE AND LEAVING ORPHAN ROW(S)

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A RENAME TABLESPACE operation may leave orphan row(s) in
    SYSIBM.SYSTBSPACEAUTH after successful execution.
    
    The db2diag.log file will show following message written during
    the RENAME TABLESPACE operation:
    
    2013-09-23-17.52.01.110415+120 I505925A579        LEVEL: Error
    PID     : 19005606             TID  : 9235        PROC : db2sysc
    0
    INSTANCE: db2inst               NODE : 000         DB   : SAMPLE
    APPHDL  : 0-34197              APPID:
    *LOCAL.db2inst.130923154754
    AUTHID  : DB2INST
    EDUID   : 9235                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update,
    probe:60
    RETCODE : ZRC=0x80090005=-2146893819=SQLI_DUPKEY "Duplicate key
    violation"
              DIA8005C Duplicate key encountered, file token ""
    index token ""
              record id "".
    
    This causes subsequent CREATE TABLESPACE operations to fail with
    error SQL0803N when trying to create the a new tablespace using
    the same name as the pre RENAME TABLESPACE name.
    

Local fix

  • Contact IBM DB2 Service to assist with cleanup of the system
    catalog.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 Fix Pack 9                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 version 9.7 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC96196

  • 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

    2013-09-24

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

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

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

    IC96217 IC96218 IC96219

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 #: IC96196

Modified date: 23 December 2013