SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Preparing to Install NonStop SQL/MX

HP NonStop SQL/MX Installation and Management Guide—544536-007

2-4

Starting TMF

Typically, you develop TMF startup and configuration files as OBEY command files.

These files contain the TMF configuration options and parameters that describe the

audit trails and the dump process. For information about TMF auditing requirements,

configuration guidelines, and considerations for NonStop SQL/MX, see Section 5,

Planning Database Security and Recovery and the TMF Planning and Configuration

Guide.

The product version of TMF provided on the SUT must be compatible with the SQL/MX

software provided with the SQL/MX SPR you install.

When you start the TMF subsystem, configured data volumes are started for

transaction processing if they are accessible. You must ensure that the volumes you

intend to use for SQL/MX metadata and audited objects are configured and started for

transaction processing. You must also ensure that the TMF subsystem as a whole is

started for transaction processing. You can request status from TMFCOM, the TMF

command interface, by entering the TMFCOM command at the operating-system

command interpreter prompt and then issuing specific STATUS commands through

TMFCOM.

If you plan to use a system management program to operate TMF, you can use

TMFSERVE, a TMF process that provides access to TMF by using the Subsystem

Programmatic Interface (SPI). Use both these mechanisms to monitor and control TMF

operation. For more information, see the TMF Management Programming Manual.

This OPEN SERVER command establishes a connection between an existing

TMFSERVE process and the current TMFCOM process. The TMFSERVE process is

named $SERVE and runs on the same node as your current TMFCOM process:

TMF 61> OPEN SERVER $SERVE

The STATUS SERVER command displays the activity of the currently open

TMFSERVE process, $SERVE:

TMF 62> STATUS SERVER

TMF Server Status:

System: \FOXII (147)

Date-Time: 06-Mar-2002 01:09:12

Process $SERVE (6,91)

Creator ID: (8,21)

Process ID: (8,21)

Priority: 125

Object Name: \FOXII.$SYSTEM.SYS00.TMFSERVE

HomeTerm: \TSII.$ZTN1A

Swap Volume: $SYSTEM

Version: TMFSERVE - T8694D46 - (26DEC2000 - TMF)

The next OPEN SERVER command creates a new TMFSERVE process and

establishes a connection between this process and the current TMFCOM process. The