Object documentationINSTANCE Locate this document in the navigation structure

 

The system table SYSINFO.INSTANCE describes some details about the database.

Structure

INSTANCE

NODE

CHAR(64)

Name with which the database instance can be addressed by applications

LOCALNODE

CHAR(64)

Name with which this hot standby instance can be addressed (if you have a hot standby configuration)

ADMINSTATEDATE

TIMESTAMP

Time at which the ADMIN operational state was reached

ONLINESTATEDATE

TIMESTAMP

Time at which the ONLINE operational state was reached

KERNELPROCESSID

FIXED(20)

Identification of the kernel process

More Information

Evaluating System Tables, INSTANCE