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
 
extract whole segment using FILEAID for IMS, Batch or online

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

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Wed Sep 16, 2009 8:10 pm    Post subject: extract whole segment using FILEAID for IMS, Batch or online
Reply with quote

Hi,

I want to extract the root segment and all its child segments thru jcl or FILE-AID for IMS. Both these segments have key fields.

Actually, we can use only certain PSBs in production enviroment to browse/edit and those PSB do not contain this DBD containing the above segments. But we can use other PSBs in a batch job for extracting/updating etc.

If somebody has used FILE-AID for IMS for creating the segment/field selection criteria and using selection criteria, or know how to extract segments using batch or fileaid, please assist.

Thanks,
Ajay
Back to top
View user's profile Send private message

Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Wed Sep 16, 2009 8:24 pm    Post subject:
Reply with quote

just now found out that probably DFSURGU0 could be used. Researching on this. icon_lol.gif
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Thu Sep 24, 2009 9:42 pm    Post subject: Reply to: extract whole segment using FILEAID for IMS, Batch
Reply with quote

Created the selection criteria and was able to extract (unload) the segments to a sequential file thru the batch job created by the EXTRACT option in file-aid/IMS.

As mentioned in my previous post, we are permitted only selected PSB in production environment. So it works when i use those PSBs in this batch job. However, when I use the psbs which we are not authorised in Production environment, it seems like the IXPDTFDV (dbextrct) program is flagging it as invalid PSB.

//DBEXTRCT EXEC PGM=IXPDTFDV,PARM=......

In this parm parameter, I am specifying PSB whose access we have in test but not in prod, and "IMS System" as our production system S2P2.

but i am getting error:
E740 invalid parameter S2P2 passed to the pgm


But this is working if i use the psb which we are authorised in production.

Thank you,
Ajay
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Sep 25, 2009 7:45 pm    Post subject:
Reply with quote

One more time - always use your very own PSB. Can you image copy the production database into the test environment and run it as test?
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 Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts Extract Data till prev hour balaji81_k DB2 16 Fri Aug 25, 2017 9:25 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm

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