IBM 000-8697 Manual De Usuario

IBM

9-2

IBM Informix OnLine Database Server Administrator’s Guide

Two-Phase Commit and Automatic Recovery . . . . . . . .

Coordinator Recovery . . . . . . . . . . . . . . .

Participant Recovery. . . . . . . . . . . . . . . .

Presumed-Abort Optimization . . . . . . . . . . . .

Independent Action and Manual Recovery . . . . . . . . .

Heuristic Decisions: What and Why . . . . . . . . . . . .

Heuristic Rollback . . . . . . . . . . . . . . . . . .

Condition 1: Logical Log Fills to a High-Water Mark. . . . .

Condition 2: You Execute tbmode -z . . . . . . . . . .

When a Heuristic Rollback Occurs . . . . . . . . . . .

Heuristic End-Transaction . . . . . . . . . . . . . . .

Two-Phase Commit Protocol Errors . . . . . . . . . . . .

Two-Phase Commit and Logical Log Records

. . . . . . . .

. . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . .

TABLOCKS . . . . . . . . . . . . . . . . . . .

HEURTX . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . .

Transaction Commit Records . . . . . . . . . . . . .

Heuristic Rollback Records

. . . . . . . . . . . . .

Heuristic End-Transaction Records . . . . . . . . . . .

Determining Database Consistency . . . . . . . . . . . .

Step 1: Determine Where a Heuristic Decision Occurred . . .

Step 2: Determine If the Networked Database Contains

Inconsistent Data . . . . . . . . . . . . . .

Steps 3 and 4: Decide If Correction Is Needed . . . . . . .

Step 5: Use Logical Log Records . . . . . . . . . . . .

Example Manual Recovery

. . . . . . . . . . . . .

IBM Informix STAR Configuration Parameters . . . . . . . .

DEADLOCK TIMEOUT

. . . . . . . . . . . . . .

TXTIME-OUT . . . . . . . . . . . . . . . . . .

Track a Transaction with tbstat Output . . . . . . . . . . .

Tracking a Global Transaction

. . . . . . . . . . . .

Transaction address Field . . . . . . . . . . . . . .

Transaction flag Field

. . . . . . . . . . . . . . .

Transaction user Field . . . . . . . . . . . . . . .

Transaction locks Field . . . . . . . . . . . . . . .

Transaction log begin

. . . . . . . . . . . . . . .

Transaction isolation Field . . . . . . . . . . . . . .

Transaction retries Field

. . . . . . . . . . . . . .

Transaction coordinator Field. . . . . . . . . . . . .