The Database Console (program X_CONS) is a database tool that gives you a quick overview of the operating system resources being used by the database system, the distribution of the database sessions among the operating system threads, and the status of the active database sessions.
Depending on the operating system, the database console runs as follows:
· Windows: The console thread, a special thread, processes requests from the Database Console. To do this, the X_CONS program communicates with the console thread.
· UNIX: The database console receives some of the information it requires directly from the shared memory area of the database kernel, and some of the information from the communication between X_CONS and the console thread.
You have the following options for using the Database Console:
·
Start the
program X_CONS from the operating system level:
x_cons
<database_name> <command> [<time>]
[<count>]
For an overview of all possible commands, use the
following command:
x_cons
<database_name> help
· If you are using an SAP system, you can call the database console from the Database Assistant. To do this, proceed as described in the following documentation:
Database Administration in CCMS: MySQL MaxDB, Database Console
Database Administration in CCMS: SAP
liveCache, Console