Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need help on Best approach for IMS Key value Masking in Bulk

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Kiran.Kumar

New User


Joined: 31 Mar 2012
Posts: 1
Location: India

PostPosted: Tue Mar 31, 2015 6:41 am    Post subject: Need help on Best approach for IMS Key value Masking in Bulk
Reply with quote

Hi,

I have a requirement to change Key field values (Mask to another value) of the Root segment based on some criteria (Not all Root keys need to be modified). The DB is very large and it has multiple Child segments. Each Root occurence can have upto 5000 Child Segment Occurences.

The following is the structure of the DB:

Root Segment -- Level 0
----Child Segment A -- Level 1
--------Child Segment D -- Level 2
--------Child Segment E -- Level 2
-----Child Segment B -- Level 1
-----Child Segment C -- Level 1
---------Child Segment F -- Level 2
---------Child Segment G -- Level 2
--------------Child Segment H -- Level 3

I was initially thinking of using IMS unload and change the Key values in the Unloaded file and then Load it back. But it seems, the keys should be in sorted order. Hence this Approach seems to require a Group Sort of the data to be done. Also I am not sure if the key values are stored in the First 31 bytes of the Unloaded Data. The Actual Segment data starts from 32 Byte.

The only feasible option I could think of is to write a BMP program to Insert all the segments with new Values and delete the segments with old values. But it requires lot of IO for the Insert/Deletes.

Could you please suggest me a best approach that I could follow.
Back to top
View user's profile Send private message

Balasubramanian

New User


Joined: 23 Apr 2005
Posts: 13
Location: Bangalore

PostPosted: Wed Apr 01, 2015 2:59 pm    Post subject: Reply to: Need help on Best approach for IMS Key value Masking in Bulk
Reply with quote

Delete the old root segments and Insert the new root segments would be the possible approach.

Instead of holding the DB for all the roots while reading, the logic can be split into two programs.
1) One is to find & write the old root and its child segments along with the modified root details into a file with a indicator for Insert and Delete.
2) Second is to read the above file and do the DB call as per Insert or Delete indicator
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Masking Db2 data kishpra DB2 3 Fri Sep 02, 2016 9:23 pm
No new posts Import bulk PDF or TXT files into BLO... satish.ms10 DB2 2 Tue Sep 15, 2015 4:51 pm
No new posts Introducing Commits to batch programs... Div Grad DB2 10 Tue Apr 07, 2015 7:45 pm
No new posts how can we copy the bulk dataset usin... cmsmoon CLIST & REXX 3 Tue Nov 04, 2014 11:58 am
No new posts Masking in easytrieve srinivasarao.gunja CA Products 3 Mon Aug 11, 2014 7:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us