Displays the current status of the database:
- Available
- This state indicates that the database is available for use.
- Inconsistent
- This state indicates that a transaction is pending or some other task is
pending on the database and the data is not consistent at this point.
If the system "crashes" while the database is not consistent, you will need to
restart the database to make it usable. If this does not work you will
need to restore the database from a backup image.
- Backup Pending
- This state indicates that you must do a full backup of the database before
accessing it. This state occurs after either LOGRETAIN or USEREXIT has
been set and accepted.
- Restore Pending
- This state indicates that the database is being restored from a backup
image. The restore must complete before you can access the
database.
- Roll Forward Pending
- This state indicates that the database is being rolled forward from the
contents of the database log files. The roll-forward must complete
before you can access the database.
- Table Space Roll Forward Pending
- This state indicates that the changes to a single table space are being
rolled forward from the contents of the database log files. The
roll-forward must complete before you can access the table space.
- Unknown
- This state indicates that a connection cannot be established to the
database. The connection may be faulty, or the database may not be
started.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]