Configuring Transaction Handling

Overview

To configure Transaction Processing on your system a raw log partition must be created and configured using the mklog command. Refer to the topic mklog - Making a Raw Log. This procedure is normally carried out at installation, so there should already be a raw log configured on your system. The procedure varies depending upon the host system being configured. If you wish to re-configure the raw log partition, contact your NEC Software Solutions representative for details.

Once a raw log is configured on your system, you should use tlmenu to configure a database for Transaction Handling.

Note

tlmenu is also used to administer Transaction Logging, Rapid Recovery, Shadow Database and Failsafe.

To configure Transaction Handling, first select option 2 - Configuration and Setup on the tlmenu main Administration Options menu. This displays the Configuration and Setup menu.

Each procedure, started by selecting a sub-menu option, comprises a sequence of message prompts to guide you through the process. Refer to Replies to Prompts for a description of the required responses.

Transaction Logging Menu System              Mon Jul 31 1999
Database name : dbase2                       Host name : crime
State         : Transaction Handling/Logging not enabled

        Configuration and Setup
        =======================

        1.  Define/Redefine the Database Configuration
        2.  Start Transaction Handling/Logging
        3.  Stop Transaction Handling/Logging
        4.  Configure the Transaction logging Status Monitor
        Enter option (1-4) : _

At the Configuration and Setup menu, select option 1 to define the database as a Transaction Handling database, then you can start Transaction Handling by selecting option 2.

Each procedure, started by selecting a sub-menu option, comprises a sequence of message prompts to guide you through the process. Refer to Replies to Prompts for a description of the required responses.

Defining a Transaction Handling Database

Note

If you are redefining a database, ensure that Transaction Handling is stopped before you commence.

The following procedure must be carried out before you can start Transaction Handling.

  1. Select option 1 on the Configuration and Setup menu. A message is then displayed describing the purpose of the procedure and prompting you to confirm that you wish to continue.

    When you enter y  at the confirmation prompt, you are asked to select the resilience option that you want to configure, from the menu:

    Configure database for :
        1. Transaction Handling
        2. Stand-Alone Transaction Logging
        3. Shadow
        4. Failsafe/Heartbeat
        5. Stand-Alone Rapid Recovery
       
        Enter option (1-5) :

  2. Select option 1 to start the procedure to define the database for Transaction Handling.

    If Transaction Handling is already configured, the following message prompt is returned:

    Transaction Handling already configured
Do you want to continue (y/n/q) ? :

    Enter y  to re-define Transaction Handling on the database.