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
 
Can records in IMS/DB be related using SETs (just as IDMS)?

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

New User


Joined: 07 Dec 2015
Posts: 19
Location: India

PostPosted: Fri Oct 19, 2018 3:53 pm    Post subject: Can records in IMS/DB be related using SETs (just as IDMS)?
Reply with quote

Hi Database Experts,

I am a COBOL developer and mainly use DB2 as backend for my applications.

Recently, I have been included into a migration project wherein IMS/DB records need to be migrated to CA-IDMS. I was selected because of my COBOL skills however this new project requires lots of understanding on IMS/DB and CA-IDMS- both of which are new to me.

The problem is this project is still going through SOW negotiations. Till that time I cant contact the backend database admin teams.

Meanwhile I have been told to look into the COBOL apps which use the DL/I interfaces to retrieve the records from the backend IMS/DB and also take a look at the existing IDMS schemas (during the requirements gathering stage my team was given some trainings but nothing beyond that) and suggest performance improvements and even give my inputs to create a migration plan.

I would be grateful if the experts could help me out regarding the capabilities of IMS/DB

I understand that in CA-IDMS a CALC+RECORD+SET combination helps frontend applications to retrieve records much faster than using normal table indexes:

https://plus.google.com/105480211036566033816/posts/LS1AqZ6E3Jm

Since going forward all IMS/DB data will be migrated to IDMS, I was curious whether IMS/DB has a similar "record association" capability? If yes, then I plan to start making COBOL changes to have the existing IMS/DB records to be retrieved using these "record relationships." This will greatly help me in my migration activity.

I would be grateful if the experts can provide some actual COBOL DL/I code which utilizes any such "record association objects" in IMS/DB.

Thanks & Regards,
Infra Application Developer
Back to top
View user's profile Send private message

prino

Senior Member


Joined: 07 Feb 2009
Posts: 1119
Location: Oostende, Belgium

PostPosted: Fri Oct 19, 2018 6:01 pm    Post subject:
Reply with quote

Holy flucking 'ell, a project manager for an migration from IMS to IDMS project asking for help here, because he's got no knowledge of either.

Please tell us which major US/European company is about to do this, so that we can break all ties with it, to prevent us from being locked out of our accounts for weeks.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Fri Oct 19, 2018 11:34 pm    Post subject:
Reply with quote

You need to get the Basic straight by signing up for coaching class within your firm or outside or at the least go through the manuals or videos and get the understanding of how both the DB works and then it will be easy to do the Migration and understand the existing code. Such questions and answers to them might help temporarily but on a lager scale it don't.
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 DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 0 Tue Nov 13, 2018 7:55 pm
No new posts Writing multiple records into a CSV r... hiravibk DFSORT/ICETOOL 2 Wed Nov 07, 2018 2:35 pm
This topic is locked: you cannot edit posts or make replies. Data Sets are files. Please stop str... jasorn JCL & VSAM 11 Wed Aug 08, 2018 1:55 am
No new posts Copy records with unknown LRECL oerdgie DFSORT/ICETOOL 8 Tue Jul 24, 2018 7:50 pm
No new posts Need Help to Create 4 Output Records ... satish.ms10 DFSORT/ICETOOL 5 Thu Jul 19, 2018 1:55 am

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