MQL Statements for Server Administrators

Given below are the some mql statments that can used to understand the status of the enovia server.

• This command will be helpful in understanding which users are currently using the enovia database. This command will tell you the user and machine and the process that is being used to connect to the enovia data base.

MQL Stmt
sessions;

• The output of this command will be in the following format
• USERNAME MACHINENAME PROGRAMNAME

• This next command will be helpful in understand the memory status of the enovia server at any given point in time.

MQL Stmt
monitor memory;

• The output of this command will be in the following format.

Used heap 32822573 bytes, free heap 441200 bytes.

Matrix Memory Manager:

31703941 bytes of memory allocated in 2783 blocks, highwater= 31885325 bytes
27754496 bytes of memory reserved in 1694 blocks
JVM total memory: 63778816
JVM max memory: 66650112
JVM free memory: 36291952
JVM memory in use: 27486864
JVM available processors: 2