Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

SAP® MaxDB - Database Console (XCONS)

 

 

Moderator: Birgit Malik

WIKI Space Editor: Thiago Lüttig

Introduction

The SAP MaxDB database Console (XCONS) can be used to monitor current operations on the database. The database console program is a database tool that gives you a quick overview of the operating system resources being used by the database system, the distribution of database sessions to threads, and the status of active database sessions.  

Start Database Console Program
 

Call at Shell Level

x_cons <database_name> <command> [<interval> [<repeat>]]

  • <command> : XCONS command
  • <interval> : Time between repetitions of the same command. If you do not specify an <interval>, the command is executed once.
  • <repeat> : Number of times the command is repeated. If you specify an <interval> but no <repeat>, the command is repeated an unlimited number of times.

Further information: documentation XCONS 

Call with Database Manager CLI

dbmcli -d <database_name> -u <dbm_operator>, <password> <command>
You can also execute all console commands with Database Manager CLI.

 Further Information: DBM commands showdb_cons

 

 

SAP Notes

936058 FAQ: MaxDB Runtime Environment

SAP MaxDB Documentation and Training Material