TMF Operations and Recovery Guide (G06.24+)

Contents

HP NonStop TMF Operations and Recovery Guide—522417-002

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-4

Table 1-3. Catalog States 1-5

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

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

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

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

Table 2-4. Transaction States 2-17

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

Table 3-1. Resolving Distributed Transactions 3-22

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-30

Table C-1. Impact of SQL Operations on TMF Online Dumps C-8