IBM Support

IC67538: X LOCKS LEFT ON CATALOG CACHE AFTER EXECUTION OF REORGCHK COMMAND

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Some locks are still held on table after execution of reorgchk
    command. So, query executed on the table from other shell may
    wait for the locks to be released.
    
    Execute following commands to see the locks :
    
    $ db2 create db TESTDB
    $ db2 connect to TESTDB
    $ db2 "create table TEST.TAB1 ( ID int )"
    $ db2 reorgchk on table TEST.TAB1
    $ db2pd -locks -db TESTDB
    
    Locks:
    Address            TranHdl    Lockname                   Type
       Mode Sts Owner      Dur HoldCount  Att  ReleaseFlg
    0x07000000404F18C0 2          53514C4445464C540763DD2841
    Internal P ..S  G   2          1   0          0x00 0x40000000
    0x07000000404F0C80 2          00000005000000000D6D000752 Row
       ..X  G   2          2   0          0x00 0x40001DE0
    0x07000000404F07C0 2          53514C4332473135AAEB550641
    Internal P ..S  G   2          1   0          0x00 0x40000000
    0x07000000404F0D00 2          00000005000D6D07437817A043
    CatCache   ..X  G   2          255 0          0x00 0x40000000
    0x07000000404F1540 2          0001000007000000437817A043
    CatCache   ..X  G   2          255 0          0x00 0x40000000
    0x07000000404F06C0 2          0000000600000000124B001252 Row
       ..X  G   2          1   0          0x10 0x40000000
    0x07000000404F0640 2          00000108000000000000000054 Table
       .IX  G   2          1   0          0x00 0x40000000
    0x07000000404F0B00 2          00000006000000000000000054 Table
       .IX  G   2          1   0          0x10 0x40000008
    0x07000000404F0840 2          00000005000000000000000054 Table
       .IX  G   2          7   0          0x00 0xC0001DEE
    
    Now, from another shell/session, execute below commands, the
    second command will hang, until "db2 commit" is executed on
    previous shell.
    < another session >
    
    $ db2 connect to TESTDB
    $ db2 "select * TEST.TAB1 with ur "
    ... hold on until commit after reorgchk ...
    

Local fix

  • Execute "db2 commit" after reorgchk command.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * APAR IC65753 fix user                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Some locks are still held on table after execution           *
    * ofreorgchk command on APAR IC65753 fix included system.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2 Version 9.7 FixPak 2                          *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 FixPak 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC67538

  • 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

    2010-03-30

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

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

    IC66792

  • 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

[{"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:
25 May 2010