Show TOC

Example documentationINSTANCE

 

Use of the system table SYSINFO.INSTANCE

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

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