Background documentationDatabase ID Locate this document in the navigation structure

 

The database ID uniquely identifies the data area of a database. The database system creates the database ID during the creation of a new database according to the following pattern:

<computer_name>:<database_name>_<date>_<time>

Example Example

Database ID of the data area of the DEMODB database on the PARMA computer, which was created on 01/30/2006 at 11:26:33.

PARMA:DEMODB_20060130_112633

End of the example.

When restoring a database, the system uses the database ID to check whether the backups really belong to this database.

The database ID of the data area changes in the following situations:

  • After initializing the database and then restoring it from a data backup. The data area of the database inherits the database ID that was stored in the backup.

    Note that after importing a backup into another database (for example when creating a database copy), the database ID contains the name of the backed-up database. Only after performing the first backup of the restored database is a new database ID assigned, which contains the correct database name and the current time stamp.

  • After carrying out a data backup in a database with an interrupted backup history (for example after the restart of the database up to a certain time, or after the overwrite mode for the log area was switched on).

    The data area of the database gets a new database ID with the current time stamp.

The database system stores the database ID in the following places:

  • The restart record in the data area (identifies the data area of the database)

  • The information page of the log area (identifies the log area of the database)

  • The information page of each backup (identifies the backup)

In the following cases the database ID of data area and log area do not match:

  • After importing a database backup from another database without initializing the database (and thereby emptying the log area).

  • In hot standby systems (multiple databases use the same log area)

More Information

Database Manager CLI