|
Problem IT03500
|
Status: Closed |
LOW PERFORMANCE OF QUERIES ON ADMSINTABINFO |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Queries on ADMSINTABINFO are slow even if all TCBs are loaded in
memory already.
I set DBHEAP to 40000, should be able to store 20000 tables' TCB
info, actually about 10000 tables in that db.
Check with "db2pd -db testdb -tcb" to make sure all tables TCB
was in DBHEAP.
time db2 "select tabname from sysibmadm.admintabinfo where
reorg_pending='Y'"
TABNAME
----------------------------------------------------------------
----------------------------------------------------------------
ADMIN99
ADMIN999
2 record(s) selected.
real 2m48.74s
user 0m0.01s
sys 0m0.01s
I still saw bufferpool data read as below
Buffer pool data logical reads = 337188
Buffer pool data physical reads = 323543 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 V9.7 users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fix Pack 11 or higher. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 V9.7 Fix Pack 11. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.07.2014
13.10.2015
13.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
