Hello all,
I'm trying to use sqlurlog to read the DB2 log (on DB2 UDB on Windows XP) and I have some questions.
1) From what I've seen with the LSN's, the returned data is big-endian. Can someone confirm this for me? Is it true for all platforms?
2) (this is a little long) The output I'm getting in the logBuffer doesn't seem to match my interpretation of the docs. I'm expecting the following sequence (assuming one record in the log to be returned):
LSN of record
Log Manager Header
Log Record
But I seem to be getting this instead:
null byte
LSN of current active (end of log)
Not exactly sure what's after that anymore.
When I check the firstReadLSN and lastReadLSN in the SQLU-RLOG-INFO, they are different and valid for one record from what I can tell. Has anyone had any experience with sqlurlog that can help me out?
I based my test off of the sample asynrlog.sqc, but it only queries then reads without checking any data. Not much help there.
Thanks for any help.
I'm trying to use sqlurlog to read the DB2 log (on DB2 UDB on Windows XP) and I have some questions.
1) From what I've seen with the LSN's, the returned data is big-endian. Can someone confirm this for me? Is it true for all platforms?
2) (this is a little long) The output I'm getting in the logBuffer doesn't seem to match my interpretation of the docs. I'm expecting the following sequence (assuming one record in the log to be returned):
LSN of record
Log Manager Header
Log Record
But I seem to be getting this instead:
null byte
LSN of current active (end of log)
Not exactly sure what's after that anymore.
When I check the firstReadLSN and lastReadLSN in the SQLU-RLOG-INFO, they are different and valid for one record from what I can tell. Has anyone had any experience with sqlurlog that can help me out?
I based my test off of the sample asynrlog.sqc, but it only queries then reads without checking any data. Not much help there.
Thanks for any help.