home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT04356 Status: Geschlossen

LOW PERFORMANCE OF QUERIES ON ADMSINTABINFO

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1fp5.                                     * 
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.09.2014
15.07.2015
15.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList