IBM 000-8697 Instrukcja Użytkownika Pobierz pdf (Strona 534)

100

101

7-56 IBM Informix OnLine Database Server Administrator’s Guide

Interpreting tblog Output

Record Types

In addition to the six columns that display for every record, some record

types display additional columns of information. The information that is

displayed varies, depending on record type. A complete listing of record

types, alphabetized by type, is contained in the table on page 7-57. The

following paragraphs containadditionalnotes about speciﬁcrecordtypes or

processing conditions.

Transactions that involve dropping tables or dropping indexes generate a

PREPCOM log record when the commit begins. The ERASE, DINDEX, and

COMMIT records follow.

One record of type CLR (24 bytes in size) is generated for each record that is

rolled back as partof processing. If the phrase “includesnext record” occurs

on a CLR record, the next log record printed is included within the CLR log

record as the compensating operation. Otherwise, assume that the compen-

sating operation is the logical undo of the log record pointed to by the CLR

record.

Ifthereareactivetransactionsatthetimeof a checkpoint, checkpoint records

include subentries that describe each of the active transactions using the

following columns:

■ Log begin (decimal format)

■ Transaction ID (decimal format)

■ Unique log number (decimal format)

■ Log position (hexadecimal format)

■ Username

When a VARCHAR data type is included in an operation, three columns of

additionaloutputareaddedtothelogicallogrecordheadertoaccommodate

the tblspace number, the rowid, and the slot-table entry number. The eight

log record types represent the following operations:

■ Home page insert

■ Home page delete

■ Home page update

■ Remainder page insert

■ Remainder page delete

1 2 ... 529 530 531 532 533 534 535 536 537 538 539 ... 701 702

Komentarze do niniejszej Instrukcji

Brak uwag

IBM 000-8697 Instrukcja Użytkownika Strona 534

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie bazy danych IBM 000-8697