HP 3000 Manuals HP 3000 Manuals
Appendix E TurboIMAGE/XL Log Record Formats This appendix shows the TurboIMAGE/XL log record formats for the DBBEGIN, DBCLOSE, DBDELETE, DBEND, DBMEMO, DBOPEN, DBPUT, DBUPDATE, DBXBEGIN, DBXEND, and DBXUNDO intrinsics. Note that the recovery flag will always be zero in the log file records. This flag is used during recovery if user recovery files are created.
NOTE All TurboIMAGE/XL records are contained within MPE/iX "WRITELOG" records. Consequently, all information contained in the header portion of each WRITELOG record is available, in addition to the information provided by TurboIMAGE/XL.
DBBEGIN HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBBEGIN LOG RECORD CODE ("BE") HALFWORD(11) - DATA SEGMENT NUMBER HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) OR MULTIPLE DATABASE TRANSACTION SEQUENCE ID HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER DBBEGIN Mode 4 (MDBXBEGIN) HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - MDBXBEGIN LOG RECORD CODE ("TB") HALFWORD(11) - NOT USED HALFWORD(12) - SEQUENCE ID BITS 0-3 = RESERVED BITS 4-9 = SEQUENCE NUMBER BITS 10-15 = TOTAL NUMBER OF DBBEGIN/DBEND LOG RECORDS IN THE SEQUENCE HALFWORD(13-14) - TRANSACTION ID HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER HALFWORD(17) - NUMBER OF BASE IDs INVOLVED IN MDBX HALFWORD(18) - DATA SEGMENT NUMBER OF FIRST BASE ID HALFWORD(19-20) - TRANSACTION NUMBER FOR 1ST BASE ID HALFWORD(21) - DATA SEGMENT NUMBER OF SECOND BASE ID HALFWORD(22-23) - TRANSACTION NUMBER FOR 2ND BASE ID DBCLOSE HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBCLOSE LOG RECORD CODE ("CL") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - USER PROCESS ABORT INDICATOR HALFWORD(13) - RESERVED FOR DBRECOV RUN TIME USE HALFWORD(14) - RESERVED FOR DBRECOV RUN TIME USE DBDELETE HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBDELETE LOG RECORD CODE ("DE") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - DATA SET NUMBER HALFWORD(16) - DATA SET TYPE ("MA"-MASTER,"DE"-DETAIL) HALFWORD(17) - RECORD NUMBER (1 WORD) HALFWORD(19) - MODE PARAMETER HALFWORD(20) - OFFSET TO KEY ITEM VALUE (IF MASTER TYPE) HALFWORD(21) - OFFSET TO DELETED DATA HALFWORD(22) - START OF KEY AND DATA BUFFER DBEND HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBEND LOG RECORD CODE ("EN"), OR ("AE") IF ABORTED HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) OR MULTIPLE DATABASE TRANSACTION SEQUENCE ID HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER DBEND Mode 4 (MDBXEND) HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - MDBXEND LOG RECORD CODE ("TE") HALFWORD(11) - NOT USED HALFWORD(12) - SEQUENCE ID BITS 0-3 = RESERVED BITS 4-9 = SEQUENCE NUMBER BITS 10-15 = TOTAL NUMBER OF DBBEGIN/DBEND LOG RECORDS IN THE SEQUENCE HALFWORD(13-14) - TRANSACTION ID HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER (pointer to beginning of user text) HALFWORD(17) - NUMBER OF BASE IDs INVOLVED IN MDBX HALFWORD(18) - DATA SEGMENT NUMBER OF FIRST BASE ID HALFWORD(19-20) - TRANSACTION NUMBER FOR 1ST BASE ID HALFWORD(21) - DATA SEGMENT NUMBER OF SECOND BASE ID HALFWORD(22-23) - TRANSACTION NUMBER FOR 2ND BASE ID DBMEMO HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBMEMO LOG RECORD CODE ("ME") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER DBOPEN HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBOPEN LOG RECORD CODE ("OP") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - USER NAME HALFWORD(16) - USER GROUP HALFWORD(20) - USER ACCOUNT HALFWORD(24) - USER IDENTIFIER HALFWORD(28) - DATABASE NAME HALFWORD(31) - DATABASE GROUP HALFWORD(35) - DATABASE ACCOUNT HALFWORD(39) - SECURITY CLASS DBOPEN (continued) HALFWORD(40) - DBOPEN MODE PARAMETER HALFWORD(41) - LOGGING IDENTIFIER HALFWORD(45) - DBSTORE TIME STAMP (3 HALFWORDS) HALFWORD(48) - USER PROGRAM NAME HALFWORD(52) - USER PROGRAM GROUP HALFWORD(56) - USER PROGRAM ACCOUNT HALFWORD(60) - MODE FROM WHO INTRINSIC HALFWORD(61) - CAPABILITY FROM WHO INTRINSIC HALFWORD(63) - LOCAL ATTRIBUTE FROM WHO INTRINSIC HALFWORD(65) - LOGICAL DEVICE OF JOB/SESSION INPUT HALFWORD(66) - PREVIOUS ROLLBACK TIME STAMP (3 HALFWORDS) HALFWORD(69) - CURRENT ROLLBACK TIME STAMP (3 HALFWORDS) HALFWORD(72) - RESERVED FOR DBRECOV RUN TIME USE HALFWORD(73) - RESERVED FOR DBRECOV RUN TIME USE DBPUT HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBPUT LOG RECORD CODE ("PU") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - DATA SET NUMBER HALFWORD(16) - DATA SET TYPE ("MA"-MASTER,"DE"-DETAIL) HALFWORD(17) - RECORD NUMBER (1 WORD) HALFWORD(19) - MODE PARAMETER HALFWORD(20) - OFFSET TO KEY ITEM VALUE (IF MASTER TYPE) HALFWORD(21) - OFFSET TO ITEM LIST HALFWORD(22) - OFFSET TO DATA HALFWORD(23) - BEGIN OF KEY,ITEM LIST,AND DATA BUFFER DBUPDATE HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBUPDATE LOG RECORD CODE ("UP") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - DATA SET NUMBER HALFWORD(16) - DATA SET TYPE ("MA"-MASTER,"DE"-DETAIL) HALFWORD(17) - RECORD NUMBER (1 WORD) HALFWORD(19) - MODE PARAMETER HALFWORD(20) - OFFSET TO KEY ITEM VALUE (IF MASTER TYPE) HALFWORD(21) - OFFSET TO ITEM LIST HALFWORD(22) - OFFSET TO NEW DATA HALFWORD(23) - OFFSET TO OLD DATA HALFWORD(24) - BEGIN OF KEY,ITEM LIST,AND DATA BUFFER DBXBEGIN HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBXBEGIN LOG RECORD CODE ("XB") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 10 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER DBXEND HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBXEND LOG RECORD CODE ("XE"), OR ("XA") IF ABORTED HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 10 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER DBXUNDO HALFWORD(0-8) - MPE WRITELOG RECORD HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH HALFWORD(10) - DBXEND LOG RECORD CODE ("XU") HALFWORD(11) - BASE LOGGING ID BIT 0 TO 5 = USER DBOPEN COUNT BIT 6 TO 10 = INDEX TO THE DBS FOR THE DBG HALFWORD(12) - RECOVERY FLAG ("NO"-FAILED,"OK"-RECOVERED) HALFWORD(13) - TRANSACTION NUMBER (1 WORD) HALFWORD(15) - LENGTH OF USER BUFFER HALFWORD(16) - START OF USER BUFFER