IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

extract whole segment using FILEAID for IMS, Batch or online


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 206
Location: Bangalore

PostPosted: Wed Sep 16, 2009 8:10 pm
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: 206
Location: Bangalore

PostPosted: Wed Sep 16, 2009 8:24 pm
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: 206
Location: Bangalore

PostPosted: Thu Sep 24, 2009 9:42 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts How to get a stack trace on a looping... ABENDS & Debugging 5
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
Search our Forums:

Back to Top