IBM Support

IC89995: 'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When 'LOAD QUERY' command encounters SQL6024C, it will keep
    holding locks on catalog tables such as
    "SYSIBM.SYSPARTITIONMAPS" and "SYSIBM.SYSTABLES", until the next
    COMMI/ROLLBACK statement is performed.
    
    Here is an example of the problem reproduced by DB2 CLP:
    ===========================================
    db2 "load query table tmp_1_2_3"
    SQL6024C  Table or index "TMP_1_2_3" is not defined on node "0".
    
    db2pd -db sample -locks showlocks -alldbpartitionnums
    Locks:
    Address            TranHdl    Lockname                   Type
    Mode Sts Owner      Dur HoldCount  Att        ReleaseFlg rrIID
    0x07000000305F0780 2          0000002A000000000000000054 Table
    .IS  G   2          1   0          0x00003010 0x40000000 0
    TbspaceID 0     TableID 42
    0x07000000305F0680 2          00000005000000000000000054 Table
    .IS  G   2          1   0          0x00003000 0x40000000 0
    TbspaceID 0     TableID 5
    ===========================================
    
    This might result in SQL0911N in case other applications need to
    access the catalog tables at the same time.
    

Local fix

  • 1. Release locks by issuing a ROLLBACK statement in the
    application that is holding the locks.
    2. Force off the application that is holding the locks.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of version 9.7 on Linux, Unix and Windows          *
    * platforms.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to DB2 LUW Version 9.7 Fix Pack 9 or higher levels.   *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 LUW Version 9.7 Fix Pack 9.
    

Temporary fix

  • 1. Release locks by issuing a ROLLBACK statement in the
    application that is holding the locks.
    2. Force off the application that is holding the locks.
    

Comments

APAR Information

  • APAR number

    IC89995

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

  • Closed date

    2013-10-08

  • Last modified date

    2013-10-08

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

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

    IC90269 IC91791 IC95428

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

Modified date: 08 October 2013