Start of Content Area

Function documentation System Information with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Informix to view system information about your database. SAPDBA calls the Informix tool onstat for the information.

Integration

System information is fully integrated in SAPDBA. You can use this functionality for databases running on UNIX and NT operating system platforms.

Prerequisites

You need to know how to use SAPDBA and to have set it up correctly. Refer to Getting Started with SAPDBA.

Features

List Information on

Information Displayed

onstat Command

Message File

Last 20 lines of the system message log (the name of the log file is specified by the MSGPATH parameter in the ONCONFIG file – see next function)

onstat -m

Configuration File

ONCONFIG file

onstat -c

Profile Information

Profile counts

onstat -p

User Information

Profile of user activity

onstat -u

Lock Information

Active locks on the database

onstat -k

Physical and Logical-Log Information

Physical and logical logs

onstat -l

Activities

When Listing System Information with SAPDBA, you do not need to know how to use onstat , because SAPDBA handles this for you.

 

See also:

Informix documentation