Extract IMS database to a dataset

IMS DB database, DL/I commands etc

Moderator: Moderator Group

Post Reply
ouintonfloury
Member
Posts: 5
Joined: Sat Jul 25, 2009 3:47 am
Location: India

Extract IMS database to a dataset

Post by ouintonfloury » Wed Aug 26, 2009 2:33 pm

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
Meenakshi Das
Bangalore
India

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Aug 26, 2009 9:58 pm

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?
Regards,
Anuj

ouintonfloury
Member
Posts: 5
Joined: Sat Jul 25, 2009 3:47 am
Location: India

Post by ouintonfloury » Thu Aug 27, 2009 9:45 am

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.
Meenakshi Das
Bangalore
India

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Aug 27, 2009 9:59 pm

One other easier way is there if you've File-Aid available at your shop?
Regards,
Anuj

ouintonfloury
Member
Posts: 5
Joined: Sat Jul 25, 2009 3:47 am
Location: India

Post by ouintonfloury » Mon Aug 31, 2009 11:56 am

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,
Meenakshi Das
Bangalore
India

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Aug 31, 2009 4:48 pm

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?
Regards,
Anuj

ouintonfloury
Member
Posts: 5
Joined: Sat Jul 25, 2009 3:47 am
Location: India

Post by ouintonfloury » Tue Sep 01, 2009 10:17 am

Hi Anuj,

I do have FIMS available.

Thanks,
Meenakshi Das
Bangalore
India

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Tue Sep 01, 2009 3:17 pm

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              
Regards,
Anuj

academyindia4

Topic deleted by Admin

Post by academyindia4 » Sat Jan 30, 2016 10:20 pm

<< Content deleted By Admin >>

Post Reply

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



Other References
Mainframe Tools and others