KB217443: "Name of Object to be Created Identical to Existing Name IS_PERF_MON_STATS_TM of the Object Type Table" error occurs when attempting to upgrade the Statistics and Enterprise Manager Repository

SUMMARY:
Inconsistency exists in the statistics tables as a result of querying the statistics tables. The impact is limited to Strategy Upgrades.  This document shows how to create new statistics tables in Strategy Configuration Wizard 9.x.
 
SYMPTOM:
When users attempt to upgrade their environment to Strategy version 9.4.1, the follow error may be seen below:

Error obtaining a server session (Database error <5>: ODBCPreparedStatement::ExecQuery failed. Error Type: Odbc error. Odbc operation attempted: SQLExecute. [xxx] Cursor C07 NOT IN PREPARED STATE. For more information, please consult DB2 document for error code SQL0514. Database error <5>: OdbcPreparedStatement::ExecQuery failed. Error Type: Odbc error. Odbc operation attempted: SQLExecute. [xxx] Cursoer01 NOT IN PREPARED STATE. For more information, please consult DB2 document for error code SQL0514. Invalid operation in authentication due to one of the following: connection to the database server is lost; no available memory, the configuration is in an inconsistent state.)

1. Open Strategy Configuration Wizard
2. Select "Create Metadata, History List, and Statistics Repository Tables"
3. On the Select the Repository types to configure page, select "Statistics Tables"
4. Select the appropriate DSN and enter the login credentials
5. Select "Finish"

Note: Statistics that currently exist will be lost after creating the new statistics tables