|
Problem IC67539
|
Status: Closed |
X LOCKS LEFT ON CATALOG CACHE AFTER EXECUTION OF REORGCHK COMMAND |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem 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 ... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* APAR IC65204 fix user *
****************************************************************
* PROBLEM DESCRIPTION: *
* Some locks are still held on table after execution of *
* reorgchk command on APAR IC65204 fix included system. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 9.8 FixPak 3 *
**************************************************************** |
| Local Fix: |
Execute "db2 commit" after reorgchk command. |
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Problem was first fixed in Version 9.8 FixPak 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.03.2010
22.12.2010
22.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
