Start of Content Area

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

Use

You can use this procedure to change the mode of the Informix database server.

Prerequisites

Procedure

  1. Choose Server Mode in SAPDBA to change the current server mode

    2. A dialog box appears displaying the current server mode and stating how many sapr3 users are connected. If not connected is displayed, it is safe to change to offline mode.

    Note

    If your operating system is NT, SAPDBA connects to the database as user sapr3 . If you want to bring the database into offline mode for any reason – for example, useful when reorganizing tables, which requires all users to be disconnected – you can disconnect while keeping SAPDBA running. Choose ServerMode ® Disconnect from OnLine. When the database is later back online and SAPDBA needs a database connection, it automatically reconnects.

  2. Choose the server mode you want to switch to.

Caution

When changing to offline or quiescent mode, make sure that the R/3 System is not running. If it is still running, SAPDBA warns you. If other users are still connected to the database, SAPDBA also warns you.

When changing to online mode, SAPDBA sometimes needs to expand system tables. If so, SAPDBA displays a message and there is a short delay while SAPDBA performs the expand. This occurs automatically and you need take no action.

The Server Mode you switch to can be any of the three switchable server modes – that is, online, offline, quiescent – described in Server Mode with SAPDBA. The change between modes usually lasts only a short period, depending on which change you have requested. For example, changing from offline to online or quiescent with a large database might take longer since a large amount of shared memory has to be initialized.

Result

SAPDBA switches the database server to the mode you choose.

 

See also:

Informix documentation