Monitor the database server status
To monitor the database server status, view the heading of the onstat command.
Whenever the database server is blocked, onstat displays
the following line after the banner line:
Blocked: reasonThe variable reason can be one or more of the following values.
| Reason | Description |
|---|---|
| ADMINISTRATION | Database is in administration mode |
| ARCHIVE | Ongoing storage-space backup |
| ARCHIVE_EBR | Blocked for External Backup and Recovery. |
| CHG_PLOG | Blocked while physical log is being changed. |
| CKPT | Checkpoint |
| CKPT INP | Interval checkpoint in progress |
| DBS_DROP | Dropping a dbspace |
| DDR | Discrete data replication |
| DYNAMIC_LOG | Log file is being added dynamically |
| DYNAMIC_LOG_FOR_ER | Log file is being added dynamically in ER setup |
| FREE_LOG | Log file is being freed |
| HA_CONV_STD | Blocked while High Availability server is being converted to standard server. |
| HA_FAILOVER | Blocked while High Availability server failover being processed. |
| HANG_SYSTEM | Database server failure |
| LAST_LOG_RESERVED4BACKUP | Waiting for last available log to be backed up |
| LBU | Logs full high-watermark |
| LOG_DROP | Log file is being dropped |
| LONGTX | Long transaction |
| MEDIA_FAILURE | Media failure |
| OVERRIDE_DOWN_SPACE | Waiting to override down dbspace setting because the ONDBSPACEDOWN onconfig parameter is set to WAIT |
In this table, the value CHKP INP does not indicate that the database server is blocked, but that a nonblocking interval checkpoint is in progress while the buffer pool is being flushed. This CHKP INP value appears in the status line of onstat output until all pages in the shared-memory buffer pool have been written to disk. For information about setting interval checkpoints to flush the buffer pool, see the CKPTINTVL configuration parameter.