Page 1 of 1
Extract IMS database to a dataset
Posted: Wed Aug 26, 2009 2:33 pm
by ouintonfloury
Hi,
I am new to IMS. I am having a requirement where I should unload an IMS database to a dataset with the help of a jcl.
Could you please tell whether any utility is there to do the same or not.
Thanks,
Meenakshi
Posted: Wed Aug 26, 2009 9:58 pm
by Anuj Dhawan
Hi Meenakshi,
You need to answer some of the question before we can proceed to successful solution to your query:
1. Is your shop using ONLY the IBM utilities?
2. Some shops are using third-party software like BMC's to do this work. Those third-party utilities allow for user-written exit routines to do exactly what you're talking about?
At my shop I use a IMS-COBOL program to do this "unload"? Check with some "senior" if you also have any such program?
Posted: Thu Aug 27, 2009 9:45 am
by ouintonfloury
Hi Anuj,
I dont have anything related to IMS in our work. I am recently going to start working with IMS because of a new requirement. I do not have any program where we unload it through IMS-COBOL.
My main requirement is unloading the databases, but it would be easier if we can use any utility either from IBM of BMC.
Thanks in advance.
Posted: Thu Aug 27, 2009 9:59 pm
by Anuj Dhawan
One other easier way is there if you've File-Aid available at your shop?
Posted: Mon Aug 31, 2009 11:56 am
by ouintonfloury
HI Anuj,
I do have FILE-AID, but how do we use the same in JCL. My requirement is to run the jcl everyday and extract the database details to a sequential file.
Thanks,
Posted: Mon Aug 31, 2009 4:48 pm
by Anuj Dhawan
Meenakshi,
"log-in" to file-aid, you'll get something like,
Code: Select all
---------- XXXX UTILITY & FOREGROUND COMMAND SELECTION (ALPHABETIC) ---------
SELECT OPTION ===> ____________________________________________________________
E - EZYEDIT - PDSMAN/MVS ISPF Productivity Facility
FA - File-Aid - Dataset Manipulation Utility
FIMS - File-Aid IMS- Dataset Manipulation Utility for IMS
.
.
though I'm pretty sure such setting would differ shop to shop but main concern is, you should have FIMS available. Please check if you've File-Aid IMS- Dataset Manipulation Utility available?
Posted: Tue Sep 01, 2009 10:17 am
by ouintonfloury
Hi Anuj,
I do have FIMS available.
Thanks,
Posted: Tue Sep 01, 2009 3:17 pm
by Anuj Dhawan
Select the options which I show in below screens and the stuff after that is quite site-specific. You need to get in touch with some one at your shop to know about them.
1.
Code: Select all
---------- XXXX UTILITY & FOREGROUND COMMAND SELECTION (ALPHABETIC) ---------
SELECT OPTION ===> fims________________________________________________________
E - EZYEDIT - PDSMAN/MVS ISPF Productivity Facility
FA - File-Aid - Dataset Manipulation Utility
FIMS - File-Aid IMS- Dataset Manipulation Utility for IMS
.
.
2.
Code: Select all
File-AID for IMS 07.03.00 ------ Primary Option Menu --------------------------
OPTION ===> 4
ENV: IMSN - IMSN - DEVELOPMENT IMS SUB-SYSTEM
0 Parameters Specify user parameters User ID - XXXXXX
1 Browse Display data base contents PF Keys - 24
2 Edit Create or change data base contents Terminal - 3278
3 Utilities Perform utility functions Time - 03:13
4 Extract/Load Extract or load a data base or subset Julian - 09.244
3.
Code: Select all
File-AID for IMS ------ Extract/Load Data Base Menu ------------------------
OPTION ===> 1
ENV: IMSN - IMSN - DEVELOPMENT IMS SUB-SYSTEM
1 Data Base Extract Extract from a data base to a sequential file
2 Data Base Load Load from a sequential file to a data base
Topic deleted by Admin
Posted: Sat Jan 30, 2016 10:20 pm
by academyindia4
<< Content deleted By Admin >>