TMF Operations and Recovery Guide (G06.26+)

Contents

HP NonStop TMF Operations and Recovery Guide—522417-003

C. Managing SQL Objects

Audited Objects C-1

TMF Guidelines for SQL Objects C-1

Operations for SQL/MP Only C-2

Operations for Both SQL/MP and SQL/MX C-6

Impact of SQL Operations on Online Dumps C-8

Index

Tables

Table 1-1. Understanding the STATUS TMF Display 1-4

Table 1-2. TMF States 1-5

Table 1-3. Catalog States 1-6

Table 1-4. Understanding the INFO TMF Display 1-7

Table 2-1. Understanding the STATUS AUDITTRAIL Display 2-4

Table 2-2. Understanding the STATUS DATAVOLS Display 2-10

Table 2-3. Understanding the STATUS TRANSACTIONS Display 2-18

Table 2-4. Transaction States 2-18

Table 2-5. Homogeneous Distributed Transaction States 2-22

Table 3-1. Resolving Distributed Transactions 3-23

Table 4-1. Understanding Audit Dump State and Status Values 4-2

Table 4-2. Audit Dump Problems and Basic Solutions 4-4

Table 7-1. Resolving Distributed Transactions After Recovering a Database 7-32