|
Problem IC86755
|
Status: Closed |
DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC94505 IC94506 IC94507
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.09.2012
19.02.2013
31.07.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
