MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Format of IMS X'99' Log record

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
Suchay
Beginner


Joined: 29 Jun 2017
Posts: 43
Topics: 9

PostPosted: Wed Feb 07, 2024 11:28 am    Post subject: Format of IMS X'99' Log record Reply with quote

Hello,

We are working on capturing data changes in IMS DB. We have to read IMS X'99' Logs for extracting the changes. We are looking for the sample format of X'99' record to understand layout, since we couldn't find the information from web.

Also, appreciate any insights on how to read the CDC from X'99' Logs.

Thanks in advance.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12359
Topics: 75
Location: San Jose

PostPosted: Wed Feb 07, 2024 3:11 pm    Post subject: Reply with quote

Suchay,

The log type record X'99' is mapped by the macro, DFSDXBLK, which is not shipped.

Code:

X'99'   DFSDXBLK   DFSDXBLK   Created by the logging option on the EXIT= parameter on the DBDGEN. This allows a user to capture database changes that can then be propagated to another environment (for example, Db2 for z/OS). The subcodes indicate the type of record being logged:

X'04'
    Changed data
X'28'
    End of job (EOJ)
X'30'
    SETS call
X'34'
    ROLS call



You can find the above information here
https://www.ibm.com/docs/en/ims/15.1.0?topic=aids-log-records
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Suchay
Beginner


Joined: 29 Jun 2017
Posts: 43
Topics: 9

PostPosted: Thu Feb 08, 2024 11:01 pm    Post subject: Reply with quote

Thank you kolusu
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group