IC86755: DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK

APAR status

• Closed as program error.

Error 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.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 10.1 Fix Pack 3.                      *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 Version 10.1 Fix Pack 3.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP