Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Migrating data to IMS DB

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

New User


Joined: 24 Mar 2010
Posts: 61
Location: Cape of Good Hope

PostPosted: Tue Jun 02, 2015 6:33 pm    Post subject: Migrating data to IMS DB
Reply with quote

Hello

We have a requirement to migrate customer data from one of the systems( which is going to sunset. lets call it 'A') to another system which has IMS/DB( call it 'B'). B has transcations which get triggered by web intereface which add/update customer information. Web - > MQ - > IMS Queue -> IMS Tran -> DB

Now possible solutions for migrating the data :

1) Write a batch program having the same rules as those of transactions. This will require analysis of all the rules how each and every segment gets modified and test all of it.

2) Trigger the IMS transactions feeding them input in a format which they require through batch.
Problems here - Where to write the transactions statistics - customers,addresses updated deleted etc. Also , if a customer update fails it will be a huge task to analyse production dumps.

I prefer the second one since it reduces test effort dramatically and possible errors in customer data migration and most importantly the volume is in a few thousands. However, since I am new to IMS ( have been a CICS DB2 guy) I am not sure what best options are there for the second solution.
Any pointers/suggestions for the approach or considerations which I might have missed will be really helpful.

Thanks
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Tue Jun 02, 2015 6:56 pm    Post subject: Reply to: Migrating data to IMS DB
Reply with quote

Quote:
We have a requirement to migrate customer data from one of the systems( which is going to sunset. lets call it 'A') to another system which has IMS/DB( call it 'B'). B has transcations which get triggered by web intereface which add/update customer information. Web - > MQ - > IMS Queue -> IMS Tran -> DB


it is not clear what customer data You are talking about ...
if a transaction, whatever the logic path, adds/updates customer data in an IMS database
it means that the data is already there , so no need to migrate anything.
unless You clarify , the chances of getting help are pretty slim!
Back to top
View user's profile Send private message
rocky_balboa

New User


Joined: 24 Mar 2010
Posts: 61
Location: Cape of Good Hope

PostPosted: Tue Jun 02, 2015 7:22 pm    Post subject:
Reply with quote

My bad that it caused confusion.
The data to be migrated is of a different application having its own customer data in their own DB.( Referred to it as 'A' in the first post). This data has to be migrated to another application which runs on IMS DB.(This is 'B').

When I mentioned That "B has transcations which get triggered by web intereface which add/update customer information. Web - > MQ - > IMS Queue -> IMS Tran -> DB " I just gave an idea how transactions on B run. These transactions do not propogate data from application A to B.

A and B are not connected to each other in any way.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Tue Jun 02, 2015 8:09 pm    Post subject: Reply to: Migrating data to IMS DB
Reply with quote

OK, let' s see ...

system A has some application which deals with some customer data,
( inquiry,updates,add,delete)

system B has some application which deals with some customer data
(inquiry,add,delete,update)
why cannot the migrated data be updated using the same logic of the existing application on B ?

Why not just write a run once application to convert the data from the old(A) structure/layout to the new(B) structure
and use the existing b application to update the data ???
Back to top
View user's profile Send private message
rocky_balboa

New User


Joined: 24 Mar 2010
Posts: 61
Location: Cape of Good Hope

PostPosted: Tue Jun 02, 2015 10:23 pm    Post subject: Reply to: Migrating data to IMS DB
Reply with quote

They will be migrated using the application logic in B. The logic for customers' maintenance is in the IMS transactions which apart from customer maintenance, do other things as well.

Now possible solutions for migrating the data :

1) Write a batch program having the same rules as those of transactions. This will require analysis of all the rules how each and every segment gets modified and test all of it.

2) Trigger the IMS transactions from batch feeding them input in a format which they require.
Problems here - Where to write the transactions statistics - customers,addresses updated deleted etc. Also , if a customer update fails it will be a huge task to analyse production dumps.

I prefer the second one since it reduces test effort dramatically and possible errors in customer data migration and most importantly the volume is in a few thousands. However, since I am new to IMS ( have been a CICS DB2 guy) I am not sure what best options are there for the second solution.
Any pointers/suggestions for the approach or considerations which I might have missed will be really helpful.

Thanks
Back to top
View user's profile Send private message
rocky_balboa

New User


Joined: 24 Mar 2010
Posts: 61
Location: Cape of Good Hope

PostPosted: Wed Jun 03, 2015 10:40 am    Post subject:
Reply with quote

Is my post so confusing still?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Thu Jun 04, 2015 2:06 am    Post subject:
Reply with quote

second one is better to make it. write an error file out if the trx fails to troubleshoot the issue.
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
This topic is locked: you cannot edit posts or make replies. Unwrap the data based on delimiter X'25' bhavana yalavarthi DFSORT/ICETOOL 30 Fri Dec 09, 2016 10:25 am
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us