View previous topic :: View next topic
|
Author |
Message |
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
Hi,
Could anyone please let me whether is it possible to access Production datasets from TEST region and vice versa.
Thanks |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Realistically, you'd hope not. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
can it be done somehow using route card.
Can the route card be step specific? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
karisurya
New User
Joined: 02 Aug 2007 Posts: 64 Location: Bangalore
|
|
|
|
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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
karisurya,
Exactly i was about to do the same thing.. It works...
Thanks |
|
Back to top |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
i could do it with two jobcards in a JCl as i am using Route command.
Thanks a lot for everyone |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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" . . . |
|
Back to top |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008 Posts: 36 Location: Bangalore
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Robert Sample wrote: |
Under JES3 . . . |
My shop is still deal with JES2 . . . -- if I'm not mistaken that construct is not valid in JES2? Please assist. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
This will do it if you are with JES2. |
|
Back to top |
|
|
JAGAN_SRIRAM
New User
Joined: 21 Jul 2007 Posts: 4 Location: INDIA
|
|
|
|
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 |
|
|
|