IBM 000-8697 Bedienungsanleitung PDF herunterladen (Seite 682)

100

101

9-62 IBM Informix OnLine Database Server Administrator’s Guide

Track a Transaction with tbstat Output

Transaction isolation Field

The isolation ﬁeld describes the transaction isolation level. Four isolation

levels are valid under IBM Informix STAR:

■ COMMIT (Committed Read)

■ CURSOR (Cursor Stability)

■ DIRTY (Dirty Read)

■ REPEAT (Repeatable Read)

A ﬁfth value, NO TRANS, might appear in this ﬁeld. NO TRANS is reserved

for two situations:

■ Database user processes (such as daemons) that perform work but

are not considered to be owners of a transaction

■ Databases that do not use logging

For more details about isolation levels, refer to IBM Informix Guide to SQL:

utorial.

Transaction retries Field

The transaction retries ﬁeld indicates the number of times that the period

speciﬁed by the TXTIMEOUT conﬁguration parameter has expired (and this

participant transaction has attempted to contact its coordinator).

Transaction coordinator Field

The transaction coordinator ﬁeld speciﬁes the name of the coordinator of

this transaction.The namethat appearsis theDBSERVERNAME ofthe coordi-

nator OnLine.

1 2 ... 677 678 679 680 681 682 683 684 685 686 687 ... 701 702

Kommentare zu diesen Handbüchern

Keine Kommentare

IBM 000-8697 Bedienungsanleitung Seite 682

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Datenbanksoftware IBM 000-8697