TMF Planning and Configuration Guide (H06.05+)

Contents
HP NonStop TMF Planning and Configuration Guide—540136-002
ii
2. Doing an Initial Configuration
2. Doing an Initial Configuration
The Major Steps 2-1
Adding the Master Audit Trail (MAT) 2-2
Adding Data Volumes 2-4
Changing the Number of Audit Dump Copies 2-4
Preparing the TMF Catalog 2-5
Two Examples of Typical Configurations 2-6
Example 1: Small-Scale Database, 10-Hour Work Day 2-6
Example 2: Medium-Scale Database, 24-Hour Work Day 2-7
NonStop SQL/MP Considerations When Configuring TMF 2-8
3. Reconfiguring Audit Trails
Using Auxiliary Audit Trails 3-1
Partitioning the Database 3-2
Improving the Performance of Large Database Applications 3-2
Changing the Audit-Trail Configuration 3-3
Number of Files Per Active Audit Volume 3-3
Number of Active-Audit Volumes 3-4
Number of Overflow-Audit Volumes 3-5
Number of Restore-Audit Volumes 3-5
Increasing Audit-Trail Capacity 3-6
Increasing Audit-Trail Throughput 3-7
Moving Active-Audit Volumes 3-7
Moving Data Volumes 3-8
Changing the Overflow Threshold 3-8
Changing the Begin-Transaction-Disable Threshold 3-9
Turning On Automatic Audit Dumping 3-10
4. Reconfiguring Transaction Limits
Controlling Transaction Duration (Autoabort) 4-1
Avoiding Runaway Transactions 4-2
Limits on the Number of Active Transactions 4-2
Active Transactions in the System 4-3
Active Transactions in a Processor 4-3
Memory Usage Limits 4-4
TMF Library Memory Usage Limit 4-4
TMP Memory Usage Limit 4-4