Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : All available storage is assigned to the job or jobstep, If REGION is coded 0K or 0M

Google
 
Web mainframegurukul.com

Extract IMS database to a dataset

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> IMS DB
  View previous topic :: View next topic  
Author Message
ouintonfloury
Member


Joined: 25 Jul 2009
Posts: 5
Location: India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Aug 26, 2009 2:33 pm    Post subject: Extract IMS database to a dataset Reply with quote

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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.

Anuj Dhawan
Moderator


Joined: 09 Aug 2008
Posts: 1631
Location: Mumbai, India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Aug 26, 2009 9:58 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
ouintonfloury
Member


Joined: 25 Jul 2009
Posts: 5
Location: India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Aug 27, 2009 9:45 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Anuj Dhawan
Moderator


Joined: 09 Aug 2008
Posts: 1631
Location: Mumbai, India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Aug 27, 2009 9:59 pm    Post subject: Reply with quote

One other easier way is there if you've File-Aid available at your shop?
_________________
Regards,
Anuj
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
ouintonfloury
Member


Joined: 25 Jul 2009
Posts: 5
Location: India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Mon Aug 31, 2009 11:56 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Anuj Dhawan
Moderator


Joined: 09 Aug 2008
Posts: 1631
Location: Mumbai, India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Mon Aug 31, 2009 4:48 pm    Post subject: Reply with quote

Meenakshi,

"log-in" to file-aid, you'll get something like,
Code:
 ----------  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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
ouintonfloury
Member


Joined: 25 Jul 2009
Posts: 5
Location: India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Sep 01, 2009 10:17 am    Post subject: Reply with quote

Hi Anuj,

I do have FIMS available.

Thanks,
_________________
Meenakshi Das
Bangalore
India
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Anuj Dhawan
Moderator


Joined: 09 Aug 2008
Posts: 1631
Location: Mumbai, India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Sep 01, 2009 3:17 pm    Post subject: Reply with quote

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:
----------  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:
 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:
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
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
academyindia4
Guest





Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Sat Jan 30, 2016 10:20 pm    Post subject: Topic deleted by Admin Reply with quote

<< Content deleted By Admin >>
Back to top
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> IMS DB All times are GMT + 5 Hours
Page 1 of 1



 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Related topics
 Topics   Replies   Author   Views   Last Post 
No new posts Search Batch file-aid help 14 frenchman 31561 Mon Feb 01, 2016 10:23 pm
academyindia4 View latest post
No new posts File-Aid Help 3 Nicholas 21374 Mon Feb 01, 2016 10:22 pm
academyindia4 View latest post
No new posts Hi plz help me out 7 Guest 21197 Mon Feb 01, 2016 10:14 pm
academyindia4 View latest post
No new posts Need urgent HELP 4 Sulagna 12528 Mon Feb 01, 2016 1:39 am
academyindia4 View latest post
This topic is locked: you cannot edit posts or make replies. executing java program thru JCL 6 Guest 24809 Tue Feb 12, 2013 1:56 pm
Anuj Dhawan View latest post
 


Cobol Tutorial
This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial
This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial
This Tutorial covers all important aspects of DFSORT. Has more SORT examples
INTERVIEW Questions
This page covers important interview questions
Mainframe Jobs
Mainframe Jobs posted by members of mainframegurukul forum
FaceBook Page
MainframeGurukul FaceBook Page
LinkedIn Page
MainframeGurkul Linkedin Page

This widget requires Flash Player 9 or better







Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials || Mainframe CICS tutorial|| Mainframe COBOL Tutorial

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB

mainframetopic-4615.html