TMF Planning and Configuration Guide (H06.05+)

Doing an Initial Configuration
HP NonStop TMF Planning and Configuration Guide—540136-002
2-8
NonStop SQL/MP Considerations When Configuring
TMF
dumps necessary to support the online dumps. (Again, as mentioned in Example 1:
Small-Scale Database, 10-Hour Work Day, you should base your tape storage
requirements on four generations of online dumps.)
Given the system, application, and database just defined, you would configure TMF by
using the following sequence of commands:
25>TMFCOM
TMF 50> ADD AUDITTRAIL MAT, FILESIZE 2047, FILESPERVOLUME 2,&
>>>ACTIVEVOLS ($AT1, $AT2), OVERFLOWVOL $AT3, &
>>>RESTOREVOL $AT3
TMF 51> START TMF
TMF 52> ADD DATAVOLS($DATA1, $DATA2, $DATA3, $DATA4, $DATA5,&
>>>$DATA6, $DATA7, $DATA8, $DATA9, $DATA10, $DATA11, &
>>>$DATA12, $DATA13, $DATA14, $DATA15, $DATA16, $DATA17, &
>>>$DATA18, $DATA19, $DATA20, $DATA21, $DATA22, $DATA23)
TMF 53> ALTER AUDITDUMP MAT, COPIES 2 PARALLEL
TMF 54> ADD TAPEMEDIA (TMF001, TMF002, TMF003, TMF004, &
>>>TMF005, TMF006, TMF007, TMF008, TMF009, TMF010), &
>>>LABEL ON!, DRIVE $TAPE1, STATUS SCRATCH
NonStop SQL/MP Considerations When
Configuring TMF
The following guidelines apply to configuring TMF for use with NonStop SQL/MP:
•
In general, it is recommended that you audit all volumes on your system except the
TMF audit-trail volume. Because the audit-trail volume is not audited, SQL objects
do not reside on that volume.
•
SQL catalogs, tables, views, indexes, and partitions of tables and indexes must
reside on volumes enabled for auditing by TMF. Individual SQL tables and their
associated indexes do not have to be audited; however, both audited and
nonaudited objects must reside on data volumes because the file labels are
audited.
•
Tables in which data is changed should be audited to protect the consistency of the
database.
•
SQL catalogs must be audited by TMF to assure that the data dictionary can be
recovered after system failure.
Note. For this sample TMF environment, you would ultimately have to add at least 1608
scratch tapes to the TMF catalog using ADD TAPEMEDIA commands such as the one shown
above (25 volumes * 6 tapes for each volume * 1 copy * 4 generations for the online dumps
plus 24 audit dumps * 1 tape for each audit dump * 2 copies * 21 days for the audit dumps).