Start of Content Area

Function documentation Server Mode with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Informix to change the server mode of the Informix database server. SAP recommends you to use SAPDBA rather than the Informix tools ( ON-Monitor , onmode , oninit ) to change server mode because it is very easy to handle. Furthermore, SAPDBA warns you if you attempt to bring the server down while the R/3 System is still running.

Integration

Changing server mode is fully integrated in SAPDBA. It is available for changing the server mode with databases running on UNIX and NT operating system platforms.

Prerequisites

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

Features

The database management system (DBMS) for the Informix database – for example, the Informix Dynamic Server – has a number of different operating modes, as shown in the table below. The first three modes described below come directly under your control with SAPDBA (offline, quiescent, online). The last three modes are invoked as background modes and are all transitory.

Operating Modes for an Informix Database

Mode

Description

Offline

Database server is not running.

Quiescent

Database server is running but paused. Users informix and root (UNIX) can perform administrative functions. Other users cannot connect to the database but can see status information.

Online

Database server is fully operational and users can connect to the database for all activities.

Recovery

Database server is moving from offline to quiescent mode. This mode is automatically invoked if required to bring the database to a consistent state.

Shutdown

Database server is moving from online to quiescent mode, or from online to offline mode.

Initializing

Database server is moving from offline to quiescent mode and the shared memory structures are being initialized.

Activities

For more information about using this function, see Changing Server Mode with SAPDBA.