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 IC86755 Status: Geschlossen

DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
The tool db2ckupgrade evaluates the table status for each table 
defined in a database to ensure no table is in load pending 
state. 
 
If the database has a large number of tables and indexes defined 
and hosts a considerable amount of data this check can take very 
long. 
A DB2 trace with perfcount option (db2trc on -perfcount -t) will 
show a lot of time spend in following functions: 
 
sqlrlAdminGetTabInfo 
sqldGetTableData 
sqldGetTableDataForPermOrTemp 
sqlbReadPageInternal 
sqldGetDataForObjSizes 
sqlbGetObjActualSize 
sqlbDMSGetObjActualSize 
sqldGetIndexObjInfo 
sqldGetDataForTableInfo 
 
This APAR will change the way db2ckupgrade checks the table load 
pending state to improve performance. 
 
The tool db2ckupgrade is run from the installation/CD of the new 
DB2 server copy to which one is upgrading to. However, it is run 
against the downlevel DB2 server which is targeted for upgrade. 
The fix requires both the downlevel DB2 server as well as the 
new DB2 server to be at a fix level mentioned in the 
Recommendation section below.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3.                      * 
* (Note: The fix requires both the DB2 server as well as the   * 
* db2ckupgrade tool to be at the fix level mentioned.)         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 10.1 Fix Pack 3.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC94505 IC94506 IC94507 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.09.2012
19.02.2013
31.07.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList