Attempting to stop Db2 results in SQL1035 message

Symptoms

Attempting to stop Db2 by using the Content Manager OnDemand command arsdb -h results in an SQL1035 "Database in use" message.

Causes

This problem can occur if a Content Manager OnDemand database table is damaged.

Resolving the problem

Review the db2diag.log file for the following type of message:

2001-12-12-09.39.02.760439  Instance:archive  Node: 000
PID:24832(db2agent (ARCHIVE))  Appid:*LOCAL.archive.011212143855
buffer_pool_services  sqlbrdpg  Probe:1141  Database:ARCHIVE
DIA3726C  An invalid page checksum was found for page " ".
ZRC=FFFFE119

where ZRC refers to a damaged Content Manager OnDemand database table.

To recover, restore the Content Manager OnDemand database table from a good backup, and then roll forward.

Note: This section applies only to Content Manager OnDemand for z/OS®.