Output of database operating and status values with UDSMON

The UDS/SQL monitor UDSMON outputs values on database operation with UDS/SQL and UDS-D and on the status of transactions.
UDSMON works with the independent DBH only.
The following information can be output:

• current database performance

  • number of transactions per session and time interval

  • number of DML statements per session and time interval

  • number of SQL statements per session and time interval

  • average transaction times per session and time interval

  • number of input and output operations per session and time interval

• current status of active transactions

• use of system-internal optimization paths

  • inter-task communication (ITC)

  • probable position pointer (PPP)

• use of system-internal resources

  • number of open SQL conversations

  • number of active transactions

  • number of free server tasks

  • number and size of UDS/SQL common pools

• UDS-D operating values relating to

  • communication with remote partner configurations

  • current processing requests to remote configurations

  • current processing requests from remote configurations

  • connections to remote partner configurations

  UDS-D operating values are provided in

  • UDS-D fields of the COUNTER and STATUS masks

  • the UDS-D mask TRANSACTION

  • the UDS-D mask CONNECT

This information allows early detection of blockages resulting, for example, from longrunning jobs and deviations from normal system behavior.

Which values does UDSMON not provide?

UDSMON does not output values which can be provided by other system programs such as:

• SM2
  CPU loading, input/output loading for disks, channel loading, paging rate

• COSMOS
  CPU time, wait times, events 

or by other UDS/SQL utility routines such as:

• BSTATUS

or by means of the system commands:

/SHOW-USER-STATUS;
/SHOW-FILE-ATTRIBUTES FILE-NAME=file-name [,SELECT=*ALL]