473,465 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DB2 archive log file layout

1 New Member
I am trying to determine the layout of the DB2 archive log files. I am using DB2 V9.7 Express C.
The dblognoconn.sqc reads the logs and displays the following to fetch the inserts, updates and deletes.


Record type: Normal
component ID: DMS log record
function ID: Insert Record
RID: x070000000000
subrecord length: 58
subrecord offset: 5656
subrecord type: Updatable, Formatted user data
user data fixed length: 15
user data:
30 30 30 30 33 30 0F 00 05 00 *000030....*
14 00 1E 00 00 61 73 63 69 69 *.....ascii*
69 00 00 00 54 68 69 73 20 69 *i...This.i*
73 20 61 6E 6F 74 68 65 72 20 *s.another.*
6E 65 77 20 72 65 73 75 6D 65 *new.resume*
recordSize: 42

Record type: Normal commit
UTC transaction committed (in seconds since 70-01-01): 1280598517
authorization ID of the application: DB2INST1
recordSize: 97

Record type: Normal
component ID: DMS log record
function ID: Delete Record
RID: x060000000000
subrecord length: 53
subrecord offset: 5714
subrecord type: Updatable, Formatted user data
user data fixed length: 15
user data:
30 30 30 31 32 30 0F 00 05 00 *000120....*
14 00 19 00 00 61 73 63 69 69 *.....ascii*
69 00 00 00 54 68 69 73 20 69 *i...This.i*
73 20 61 20 6E 65 77 20 72 65 *s.a.new.re*
73 75 6D 65 2E *sume. *
recordSize: 102

Record type: Normal
component ID: DMS log record
function ID: Delete Record
RID: x070000000000
subrecord length: 58
subrecord offset: 5656
subrecord type: Updatable, Formatted user data
user data fixed length: 15
user data:
30 30 30 30 33 30 0F 00 05 00 *000030....*
14 00 1E 00 00 61 73 63 69 69 *.....ascii*
69 00 00 00 54 68 69 73 20 69 *i...This.i*
73 20 61 6E 6F 74 68 65 72 20 *s.another.*
6E 65 77 20 72 65 73 75 6D 65 *new.resume*
recordSize: 42


Would anyone have material elaborating on the archive logfile layout.

Thanks
mpk
Aug 15 '12 #1
0 1434

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Claire | last post by:
I need to interface to an MFC CArchive file created with Visual Studio 6. I've found some online sample code to translate an archived string into C# I now need to read in and translate a CTime...
6
by: JezB | last post by:
From a windows application, I want to provide an "archive" facility which will scan a specific directory and put specific files into some single "Archive file", a bit like a zip-file I guess, but...
1
by: dwainew | last post by:
Problem: I'd like to archive off the contents of a text file. However, other processes may have the file open, so MoveTo(newfilepath) can't be done, as far as I've found. Start with a 5 MB...
1
by: Ritesh Raj Sarraf | last post by:
Hi, The program downloads the files from the internet and compresses them to a single zip archive using compress_the_file(). Upon running syncer() which calls the decompress_the_file(), the...
1
by: PTM | last post by:
I have created an xml file using normal file write (was less code than DOM), the layout of which is nice and easy to view both in a text editor (eg, wordpad) and in a browser. eg: <xml header...
0
by: cong | last post by:
web.xml: <?xml version="1.0" encoding="ISO-8859-1"?> <web-app> <display-name>ShowLifecycles</display-name> <description>An example of how to use lifecycle events</ description> <listener>...
4
by: dexter48 | last post by:
Hi I'm searching for a string occurance in a text file. I find the string ok and write the results to a log file. But on the line above is also some information I need. How can i get that. The string...
17
by: Prosdo | last post by:
Hi eveyone. I am very new to C++ and have an assignment coming up. I understand most of it except for two parts. The For Loop and the layout in the output file. The assignment is to do mailing...
0
by: shaheda begum | last post by:
Hi everyone, Can anyone guide me how to link archive file(libxyssl.a) to my shell script( .sh file) in Perl using swig interface. Thank you in advance.
5
by: swethak | last post by:
hi, i want to zip the folder using php. Any body plz help for that.
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.