DB2 FOR LUW / DB2FORLUW / A10 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1fp5.                                     * 
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.09.2014
15.07.2015
15.07.2015