db_restartinfo
With this command you display the restart information of the database.
You can thus determine which data pages are in the log area and whether a restart of the database is possible. You need this information, for example, when you want to restart a database.
-
You have the server permission Recovery.
-
The database is in the ONLINE or ADMIN operational state.
db_restartinfo
OK
Used LOG Page <page_no>
First LOG Page <page_no>
Restartable (1|0)
Id Restart Record <database_ID>
Id LOG Info <database_ID>
Consistent (1|0)
Log Volume Enabled (1|0)
Log Auto Overwrite (1|0)
Master Servernode <computer_name>
Converter Version <converter_version_no>
Oldest Compatible Version <software_version_no>
Queue Count <log_queue_no>
Repository Imports <NO | YES>
|
Value |
Description |
|---|---|
|
Used LOG Page |
Next log page to be used by the system after the restart |
|
First LOG Page |
Oldest available log page |
|
Restartable |
Restartability 1: The database can be restarted. 0: The database cannot be restarted. |
|
Id Restart Record |
Database ID stored in the data area |
|
Id LOG Info |
Database ID stored in the log area |
|
Consistent |
Consistency of the database, that is, restartability without importing log entries 1: can be started without importing log entries 0: cannot be started without importing log entries |
|
Log Volume Enabled |
1: The database system writes redo-log entries (default value). 0: The database system does not write any redo-log entries. |
|
Log Auto Overwrite |
Overwrite Mode for the Log Area 1: switched on 0: switched off |
|
Master Servernode |
Only relevant for hot standby systems: Name of the host on which the master instance is running |
|
Converter Version |
Converter version |
|
Oldest Compatible Version |
Oldest compatible version of the database software |
|
Queue Count |
Number of log queues |
|
Repository Imports |
One or more shared repositories have been imported, other database/s required for restart Possible values are: NO | YES YES: dabase can be restartet NO: database requires other database/s for restart |
In the event of errors, see Reply Format.
Log on to Database Manager CLI as the operator OLEG with the password MONDAY, connect to the database DEMODB on computer PARMA, and display the restart information:
> dbmcli -u OLEG,MONDAY -d DEMODB db_restartinfo
OK
Used LOG Page 710
First LOG Page 2147483647
Restartable 1
Id Restart Record PARMA:DEMODB_20060202_141737
Id LOG Info PARMA:DEMODB_20060202_141737
Consistent 1
Log Volume Enabled 1
Log Auto Overwrite 1
Master Servernode PARMA
Converter Version 13
Oldest Compatible Version 7.6.00.22
Queue Count 1
Concepts of the Database System, Example: Restart