Old Statistics records from a Connect:Direct node that was unattached from Control Center for a long time bring down SCC with a DB error
Sterling Control Center shuts down with a CJDB026E error. The Engine log shows the root error was SQL Exception msg : DB2 SQL Error: SQLCODE=-327, SQLSTATE=22525 trying to insert a record into the database.
The Connect:Direct server that this statistical record is coming from is many weeks old because the network connection to this node was down for a long time.
THE ROW CANNOT BE INSERTED BECAUSE IT IS
OUTSIDE THE BOUND OF THE PARTITION RANGE FOR THE LAST PARTITION.
While Control Center is down go to the directory;
and delete the checkpoint file for the specific node.
Then start Control Center and it will not poll the statistics so far back.
More support for:
IBM Control Center
Software version: 5.3, 5.4
Operating system(s): AIX, HP-UX, Solaris, Windows
Software edition: All Editions
Reference #: 1596389
Modified date: 2013-04-19