NetMaster Database Administration › Monitor NDB Activity

Monitor NDB Activity

Use the SHOW NDB, SHOW NDBUSER and the TRACE option of the NDB START command to monitor NDB activity.

To determine the number of NDBs currently active, issue the command:

SHOW NDB

The output from this command shows the number of NDBs active, locked, and stopping. To obtain detailed statistics about all active or locked NDBs, or a specific NDB, use the command(s):

SHOWNDB=ALL-* for all, or
SHOWNDB=dbname-* for a specific NDB.

The output from these commands indicates the status of the NDB(s), the number of signed on users, the number of commands processed, and whether the database was started in DEFER status.

This display is particularly useful for monitoring the progress of long-running procedures that are loading or reading large numbers of records.

To determine the user ID(s) of users signed on to all active NDBs, issue the command:

SHOW NDBUSER

The output from this command, which is similar to the SHOW UDBUSER command, indicates details such as the database, user ID, and LU name (terminal) for all users signed on to any NDB.

Note: A SHOW UDBUSER shows *NDB as the only user of a UDB that is an NDB. This serves as an indication to the issuer of the SHOW UDBUSER command that a SHOW NDBUSER command is required for this UDB/NDB to obtain a list of signed on users.

Using the TRACE option of the NDB START command causes a message to be written to the activity log every time an &NDB verb or an NDB command is issued involving that particular NDB. Tracing can be stopped at any time by issuing an NDB START command specifying NOTRACE.