r2 - 2015-05-27 - 16:57:29 - Main.sbagotYou are here: TWiki > 
Deployment Web > DeploymentTroubleshooting > UpgradeTroubleshooting > CLMUpgradeTroubleshooting > RunStatistics
Deployment Web > DeploymentTroubleshooting > UpgradeTroubleshooting > CLMUpgradeTroubleshooting > RunStatistics
This topic discusses running the database statistics prior to an upgrade.
REPOSITORY.ITEM_STATES
REPOSITORY.ITEM_CURRENTS
REPOSITORY.ITEM_TYPES
LINKS.AUDITABLE_LINK
Error During Upgrade: The default runstats, db2 runstats on table REPOSITORY.ITEM_STATES, command fails, it results in an error related to the INDEX-Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true" is not properly formatted.
Resolution: Have your DBA run the following command:
Database Statistics
The upgrade documentation suggests that prior to any upgrade, you should update the database statistics for your CLM Deployment. Otherwise, the upgrade process may take significantly longer. The following tables must contain up-to-date database statistics:REPOSITORY.ITEM_STATES
REPOSITORY.ITEM_CURRENTS
REPOSITORY.ITEM_TYPES
LINKS.AUDITABLE_LINK
Running the Database Statistics
Work with your DBA to run the database statistics.Common Issues
Below are some known issues which arise during the update configuration files step in the upgrade processDB2: Runstats fails
Version: Upgrade to 4.x using DB2Error During Upgrade: The default runstats, db2 runstats on table REPOSITORY.ITEM_STATES, command fails, it results in an error related to the INDEX-Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true" is not properly formatted.
Resolution: Have your DBA run the following command:
db2 runstats on table REPOSITORY.ITEM_STATES on all columns and sampled detailed indexes all allow write access
Related topics:
- For more upgrade troubleshooting topics, refer to Upgrade Troubleshooting.
External links:
- None
Additional contributors: SusanWu
-
Deployment web
-
Planning and design
- Installing and upgrading
- Migrating and evolving
- Integrating
- Administering
- Monitoring
- Troubleshooting
Community information and contribution guidelines 
Topic list 
Search 
Advanced search 
Notify 
RSS 
Atom 
Changes 
Statistics 
Web preferences 
NOTE: Please use the Sandbox web for testing -
To do
-
Under construction
-
New
-
Updated
-
Constant change
- None - stable page
- Smaller versions of status icons for inline text:
-
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors. Contributions are governed by our Terms of Use. Please read the following disclaimer.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.