SAPDBA Heading Lines (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

SAPDBA Heading Lines

Definition

The heading lines in SAPDBA appear on all menu screens.

Structure

The heading lines contain the following information about your current system environment:

Informix Version is the full name for your version of the Informix database server.

Informix Server is the name of the database server to which you are currently connected.

Server Mode is the current mode of the database server. For more details about server modes, refer to the Informix documentation.

Informixdir is the installation directory for the database server, which you defined using the INFORMIXDIR environment variable when R/3 was installed.

Database is the name of the Informix database to which you are currently connected. With SAP, this corresponds to the name of the R/3 instance, either in upper or lower case, depending on which release of R/3 you installed (before version 2.2C or 2.1G, this is in upper-case, after in lower-case).

SID is the system id name ( <SID> ) of the R/3 instance that you are running.

‘sapr3’ user(s) shows you how many sapr3 users are connected to the database. If this field shows not connected, then no users are connected to the database. For SAPDBA with NT (which itself connects to the database as user sapr3 ), you can disconnect while keeping SAPDBA running by using ServerMode ® Disconnect from OnLine (this is useful when reorganizing tables, which requires all users to be disconnected).

Logging Mode tells you whether logging for the database is turned on or off. For normal operation, this should always be on. You need to turn logging off during some of the "reorganize" actions under Reorganization but you must turn logging back on when you re-start normal productive operations.

Caution

Logging Mode should normally be on. If it is off, database transactions are not being logged. Therefore, you cannot restore the database correctly in the event of failure. In this case, you risk losing production data.