<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"/> Run Database Statistics Authors: [[UpgradeTroubleshootingTeam][UpgradeTroubleshootingTeam]] <br> Build basis: CLM 4.x %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> This topic discusses running the database statistics prior to an upgrade. ---++ 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: <br>REPOSITORY.ITEM_STATES <br>REPOSITORY.ITEM_CURRENTS <br>REPOSITORY.ITEM_TYPES <br>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 process ---+++ DB2: Runstats fails *Version:* Upgrade to 4.x using DB2 <br> *Error During Upgrade:* The default runstats, <i>db2 runstats on table REPOSITORY.ITEM_STATES</i>, command fails, it results in an error related to the INDEX-Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true" is not properly formatted. <br> *Resolution:* Have your DBA run the following command: <verbatim>db2 runstats on table REPOSITORY.ITEM_STATES on all columns and sampled detailed indexes all allow write access</verbatim> ---+++++!! Related topics: * For more upgrade troubleshooting topics, refer to [[UpgradeTroubleshooting][Upgrade Troubleshooting]]. ---+++++!! External links: * None ---+++++!! Additional contributors: Main.SusanWu ---+++++!! Questions and comments: %COMMENT{type="below" target="UpdateConfigurationFilesComments" button="Submit"}% %INCLUDE{"UpdateConfigurationFilesComments"}% <sticky></div></sticky>
This topic: Deployment
>
WebHome
>
DeploymentTroubleshooting
>
UpgradeTroubleshooting
>
CLMUpgradeTroubleshooting
>
RunStatistics
History: r1 - 2014-06-23 - 17:12:19 - Main.sbagot
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
.