IBM Support

Unable to start IBM Sterling Control Center engine with CCTR075E ERROR

Troubleshooting


Problem

When running configCC to configure the IBM Sterling Control Center engine the startup fails with error CCTR075E

Symptom

The following error is seen in the configCC output


13 Jul 2013 01:27:17,359 113594 [main] INFO DB_Init - Executing SQL command ....CREATE TABLE TEST_PART(COL1 VARCHAR(30) ) PARTITION BY RANGE(COL1) (PARTITION P1 STARTING MINVALUE ENDING '2009/09/01' )
13 Jul 2013 01:27:17,359 113594 [main] ERROR DB_Init - An error occurred while executing SQL command.
CREATE TABLE TEST_PART(COL1 VARCHAR(30) ) PARTITION BY RANGE(COL1) (PARTITION P1 STARTING MINVALUE ENDING '2009/09/01' )
SQL Error code = -8027
Error code : InstallErrorCodeList.4008
13 Jul 2013 01:27:17,359 113594 [main] ERROR DB_Init - com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-8027, SQLSTATE= , SQLERRMC=null, DRIVER=3.57.82

Cause

Customer is using a DB2 database and does not have the Database Partitioning feature enabled.

Environment

IBM Sterling Control Center with DB2 as database

Resolving The Problem

Add the Database Partitioning feature to the DB2 license or reconfigure the IBM Sterling Control Center engine to use a Production and Staging database instead.

[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.4;5.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 December 2019

UID

swg21646093

Page Feedback