Use of the system table SYSINFO.INSTANCE
You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB an: Logging On to a Database.
You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview
Note the General Instructions for formulating SQL statements.
You can use the system table INSTANCE to determine the following database information, among other things:
Name with which the database instance can be addressed by applications
SELECT node
FROM SYSINFO.INSTANCE
Time at which the ONLINE operational state was reached
SELECT onlinestatedate
FROM SYSINFO.INSTANCE