Extract IMS database to a dataset
Moderator: Moderator Group
-
- Member
- Posts: 5
- Joined: Sat Jul 25, 2009 3:47 am
- Location: India
Extract IMS database to a dataset
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
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
Meenakshi Das
Bangalore
India
Bangalore
India
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
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?
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?
Regards,
Anuj
Anuj
-
- Member
- Posts: 5
- Joined: Sat Jul 25, 2009 3:47 am
- Location: India
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.
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.
Meenakshi Das
Bangalore
India
Bangalore
India
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
-
- Member
- Posts: 5
- Joined: Sat Jul 25, 2009 3:47 am
- Location: India
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
Meenakshi,
"log-in" to file-aid, you'll get something like, 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?
"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
.
.
Regards,
Anuj
Anuj
-
- Member
- Posts: 5
- Joined: Sat Jul 25, 2009 3:47 am
- Location: India
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
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.2.3.
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
.
.
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
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
Regards,
Anuj
Anuj
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page