DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V9.7 users.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 11 or higher.                   * 
****************************************************************

First fixed in DB2 V9.7 Fix Pack 11.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

31.07.2014
13.10.2015
13.10.2015

9.7.FP11