Troubleshooting
Problem
How to unblock the database server after a dbspace has been disabled and the ONDBSPACEDOWN configuration parameter is set to 2.
Symptom
The database server is blocked with a checkpoint request that never finishes. User sessions are only able to perform read operations and any update, delete or insert operations will hang.
When you run the onstat - command, the output shows that the database server is Online, but blocked on a checkpoint request:
- There is a message in the Online.log file that says:
- The output of the onstat -d command shows one or more dbspaces marked as down (indicated by a D in the flags column). Any dbspace marked as down will have all its chunks marked as down as well.
Example
The following output shows that the dbspace test has been marked as down and its associated chunks (numbers 5 and 6) have also been marked as down. The database server is waiting on a checkpoint request - On-Line (CKPT REQ) :
(right click the image for a larger view using your browser)
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"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":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;7.3;9.4;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21153098