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 CA Intertest Batch 555shanth CA Products 0 Tue Nov 28, 2017 11:10 am
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts How to Extract BMS Marco Source from ... Howard Hinman CICS 5 Tue Oct 31, 2017 11:13 pm

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