Background documentationdb_restartinfo Locate this document in the navigation structure

 

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.

Prerequisites

  • You have the server permission Recovery.

  • The database is in the ONLINE or ADMIN operational state.

Structure

db_restartinfo

Result

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>

Values for the Reply Fields

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.

Example

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

More Information

Concepts of the Database System, Example: Restart