iX V6.5 (30391-90011)

Chapter 5 201

TurboIMAGE/XL Library Procedures

DBINFO

Element 5 is always 0.

ß indicates blank. Elements 6 to 14 are always blank.

Elements 15 and 16 are reserved.

Mode 403: Dynamic Roll-Back

Mode 403 obtains information related to dynamic transaction activity on a given database.

Qualiﬁer is ignored.

Buffer returns the following (each element is a halfword or two bytes):

The log identiﬁer name is left-justiﬁed and padded with blanks if shorter

than 8 characters.

If the database is enabled for logging, the database log ﬂag is 1; otherwise

it is 0.

If you are logging, the user log ﬂag is 1; otherwise it is 0.

If no logical transaction is in progress, the transaction ﬂag is 0. If a static

transaction is in progress, the ﬂag is set to 1; if a multiple database

transaction is in progress, the ﬂag is set to 2.

The user transaction number is one word.

The Transaction Management (XM) log set is measured in megabytes.

If the XM log set is circular, the log set type is CR; otherwise it is LN

indicating a linear log.

If the database is attached to XM, the database attached ﬂag is 1;

otherwise it is 0.

If the user is processing a dynamic transaction, the dynamic transaction

ﬂag is 1; otherwise it is 0.

Element Contents

1–4 Log identiﬁer name

5 Database log ﬂag

6 User log ﬂag

7 Logical transaction ﬂag

8–9 User transaction number

10–11 XM log set size (in megabytes)

12 XM log set type

13 Database attached ﬂag

14 Dynamic transaction ﬂag

15–26 XM log set name