Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Is it possible to access production datasets from test regio

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Mon May 04, 2009 5:54 pm    Post subject: Is it possible to access production datasets from test regio
Reply with quote

Hi,

Could anyone please let me whether is it possible to access Production datasets from TEST region and vice versa.

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

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Mon May 04, 2009 5:58 pm    Post subject:
Reply with quote

Yes, no, maybe -- this is a site-specific question that could not possibly be answered here. You need to contact your peers or the site support group to get this question answered.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Mon May 04, 2009 5:59 pm    Post subject: Reply to: Is it possible to access production datasets from
Reply with quote

it all depends on Your system setup....
( dasd sharing and proper access permissions )
ask You support for the standards used in Your organization
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon May 04, 2009 6:47 pm    Post subject: Reply to: Is it possible to access production datasets from
Reply with quote

Realistically, you'd hope not.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 04, 2009 11:47 pm    Post subject:
Reply with quote

Hello,

Quote:
is it possible to access Production datasets from TEST region and vice versa
If this is for testing and any permission is given, it would hopefully be read-only permission.
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Tue May 05, 2009 2:54 pm    Post subject:
Reply with quote

hi Dick,

I just want the read access, If i submit the job in test region it has to access input files from production and vice versa.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue May 05, 2009 3:18 pm    Post subject:
Reply with quote

As said by Robert. You are the only person in a position to know or to find out.

Either ask your peers or submit the jobs and see what happens. We know less than nothing about your system set up.
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Tue May 05, 2009 4:23 pm    Post subject:
Reply with quote

can it be done somehow using route card.

Can the route card be step specific?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue May 05, 2009 4:29 pm    Post subject:
Reply with quote

Quote:
Can the route card be step specific?

In what way - that you run some steps on one LPAR and other steps on another.

The answer is NO. The job can only process on the LPAR it is submitted on.

What have you actually tried yourself and what results did you get ?
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Tue May 05, 2009 4:36 pm    Post subject:
Reply with quote

Actually i was plannin to submit a single job in Production region which unloads the DB2 table and then load the same in test region.

So was finding a way which could make unloading step to run in production and loading step to run in TEST region.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 05, 2009 7:49 pm    Post subject:
Reply with quote

Hello,

Suggest you speak with your dba or some senior on your project.

This is a requirement many places, and the process has probably already been established. All you would need to do is clone/modify one that works for your table(s).
Back to top
View user's profile Send private message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Wed May 06, 2009 4:10 pm    Post subject:
Reply with quote

Quote:

Actually i was plannin to submit a single job in Production region which unloads the DB2 table and then load the same in test region.


I have done some thing like this some time back, what i done is create a job which will unload the the db2 table to a flat file in test region and by using route command executed the job in prod. next step will be transfer the flat file to test region and Later use the flat file to load data in test database.

But yes as others suggested first you need to find out your access permissions.
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Wed May 06, 2009 8:45 pm    Post subject:
Reply with quote

karisurya,

Exactly i was about to do the same thing.. It works...

Thanks
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Wed May 06, 2009 8:47 pm    Post subject:
Reply with quote

i could do it with two jobcards in a JCl as i am using Route command.

Thanks a lot for everyone
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu May 07, 2009 2:31 pm    Post subject:
Reply with quote

Vinay N.G wrote:
i could do it with two jobcards in a JCl as i am using Route command.
Sorry - but I did not get this, did that mean other job (or the second job card) was used in a JOB intiated by "internal reader" . . . icon_confused.gif
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Thu May 07, 2009 3:49 pm    Post subject:
Reply with quote

Hi Anuj,

Two jobcards in a JCL will result in submission of two jobs.
Here in my case one in production and the one in test region.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Thu May 07, 2009 5:35 pm    Post subject:
Reply with quote

Anuj: read section 28.14.5 in the JCL Language Reference manual. Under JES3, the following construct is valid and results in routing the job JOBN2 to another system for execution
Code:
     //JOBN1   JOB   options ...
     //*ROUTE  XEQ   2
     //JOBN2   JOB   options ...
     //STEP1   EXEC  PGM=REPORTER
     //DD1     DD    SYSOUT=A,DEST=N1R33
     //DD2     DD    SYSOUT=A,DEST=N2R33
     //DD3     DD    SYSOUT=B,DEST=R33
     //DDIN    DD    *
               .
               .
               data
               .
     /*

Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu May 07, 2009 7:16 pm    Post subject:
Reply with quote

Robert Sample wrote:
Under JES3 . . .
My shop is still deal with JES2 . . . icon_cry.gif -- if I'm not mistaken that construct is not valid in JES2? Please assist.
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Thu May 07, 2009 7:22 pm    Post subject:
Reply with quote

Code:
/*ROUTE  XEQ   2

This will do it if you are with JES2.
Back to top
View user's profile Send private message
JAGAN_SRIRAM

New User


Joined: 21 Jul 2007
Posts: 4
Location: INDIA

PostPosted: Thu May 07, 2009 7:41 pm    Post subject: Reply to: Is it possible to access production datasets from
Reply with quote

Hi,
Normally due to security measures, user cannot access the data sets of production from test region. we can NDM the data to test region and access it.

Thanks & Regards,
Sriram
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us