To determine the state of each storage space and its chunks, or the status of the restore, examine the output of the onstat -d utility. The onstat -d utility works only with the database server online. For more information on onstat -d, see onstat -d. The following table describes the information in the second position of the flags column in the first (storage spaces) and second (chunks) sections of the onstat -d output and the actions required to solve the problems.
On Extended Parallel Server, you can use the xctl onstat -d utility to check the storage spaces on all coservers.
| onstat -d Flag | Storage Space or Chunk State | Action Required |
|---|---|---|
| (No flag) | Storage space no longer exists. | Perform a point-in-time cold restore to a time before the storage space was dropped. |
| D | Chunk is down or storage space is disabled. | Perform a warm restore of the affected storage space. |
| I | Chunk has been physically restored, but needs a logical restore. | Perform a logical restore. |
| L | Storage space is being logically restored. | Retry the logical restore. |
| N | Chunk is renamed and either down or inconsistent. (IDS) | Perform a warm restore of the chunk when the physical device is available. |
| O | Chunk is online. | No action required. |
| P | Storage space is physically restored. | Perform a logical restore, if one is not already in progress. |
| R | Storage space is being restored. | Perform a physical or logical restore. |
| X | Storage space or chunk is newly mirrored. | No action required. |