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 Northgate support 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 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.

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.

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) :
```
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.