Start of Content Area

Procedure documentation Checking the Database with onstat Commands  Locate the document in its SAP Library structure

Use

You can use the detailed database analysis in the SAP/Informix database monitor to check the database by using onstat commands.

Prerequisites

Make sure that the interface to the Informix tool ontstat is working correctly. For more information if you have problems calling onstat (or the interface program infstrfc ), see SAP Note 16454. This kind of problem is indicated if you see an error message like the one shown in the procedure below.

Procedure

  1. Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu ® Onstat commands.
  2. The system displays a list of onstat commands.

  3. Select the required command and choose Choose.

Note

You might see an error like the following:

RFC error /No such file or directory /usr/sap/ARG/SYS/exe/run/infstrfc

Please check TCP/IP destination DBSERVER with transaction SM59

Choose Recreate DBSERVER to try to fix the problem. If this fails, see SAP Note 16454.

 

See also:

Informix documentation