SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-3
Starting the Transaction Management Facility (TMF)
audit trails and the dump process. For information about TMF auditing requirements,
configuration guidelines, and considerations for SQL/MP, see The TMF Subsystem on
page 4-10 and the TMF Planning and Configuration Guide.
Your version of TMF must be compatible with your version of SQL/MP software as
noted under Hardware and Software Requirements on page 2-1.
When you start the TMF subsystem, the configured data volumes are started for
transaction processing if they are accessible. You must ensure the volumes you intend
to use for SQL/MP catalogs 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:
21> TMFCOM
~STATUS TMF <--Request for TMF status.
TMF Status:
System: \SQLNLS, Time: 4-Nov-1994 13:35:26
State: started
Transaction Rate: 5.0 TPS
AuditTrail Status:
Master
Active audit trail capacity used: 14%
First pinned file: $DATA.ZTMFAT.AA000012
Reason: Current file
Current file: $DATA.ZTMFAT.AA000012
BeginTrans Status: ENABLED
Catalog Status:
Status: up
~STATUS DATAVOLS <--Request for status of data
volumes.
~status datavols
Audit Recovery
Volume Trail Mode State
-------------------------------------------------------------
$RAT MAT Online Started
$D00 MAT Online Started
$XCEED MAT Online Started
$C30SYS MAT Online Started
$SYSTEM MAT Online Started
$SQL MAT Online Started
$TES MAT Online Started
~EXIT <--Exits 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). Both of these mechanisms can be used to monitor and
control TMF operation.