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
 

 

Run a JCL in Test environment by pulling data from PROD

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
byasmeen

New User


Joined: 01 Mar 2010
Posts: 15
Location: chennai

PostPosted: Thu Jul 28, 2011 3:40 pm    Post subject: Run a JCL in Test environment by pulling data from PROD
Reply with quote

Hi,

Please can you provide me with information on how to run a JCL in Test environment by directly pulling data from production environment.

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Thu Jul 28, 2011 3:47 pm    Post subject: Reply to: Run a JCL in Test environment by pulling data from
Reply with quote

clarify the meaning of the word pulling

the safest approach is to clone the data from production and access the cloned data

I have seen a few cases where tests were run by using production data in READ ONLY fashion but never directly by the testing team

it is a murky situation, from any point of view,
information security ( wrong people accessing sensitive data )
data integrity ( what if )
data sharing
auditing
Back to top
View user's profile Send private message
byasmeen

New User


Joined: 01 Mar 2010
Posts: 15
Location: chennai

PostPosted: Thu Jul 28, 2011 3:54 pm    Post subject:
Reply with quote

I need to access data present in the production environment using a JCL which will run in Dev set up. Is this possible?

Thanks.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Thu Jul 28, 2011 4:01 pm    Post subject: Reply to: Run a JCL in Test environment by pulling data from
Reply with quote

if You did not understand my previous reply meditate about a career shift icon_cool.gif

the question anyway belongs to the category

is it possible to shoot <Myself/Yourself> ?
unfortunately/fortunately in both cases ( accessing production data/ shooting ) the answer is
YES

why not ask Your support for the how ?
do not dare to ask us! You will be banned instantly icon_evil.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jul 28, 2011 4:02 pm    Post subject:
Reply with quote

as usual, piss-poor problem definition.

in a professional IT environement,
production data is unloaded
and then this data is (maybe with a little anonymising) loaded into developement tables, files.

then the jobs are constructed to run the tests.
normally this is JCL that uses symbolics to allow for mult-environments.
all of our production JCL can be used in the dev, test, qa environment with only changes of symbolics. The procs do not have to be changed.


is the above the scenario that you wish?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Thu Jul 28, 2011 4:03 pm    Post subject: Reply to: Run a JCL in Test environment by pulling data from
Reply with quote

Quote:
is the above the scenario that you wish?


that' s not the scenario / He did not read my previous reply icon_biggrin.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Thu Jul 28, 2011 4:11 pm    Post subject: Reply to: Run a JCL in Test environment by pulling data from
Reply with quote

As enrico has said, yes you can. For hecks sake don't do it on your own.

As dbz has outlined, that is how it is done. To do this you will have to involve your "production control" department - the technical people with responsibility for the production data. If your requirement is valid, they are the people who will satisfy it, along dbz's lines.

If they say no, but your requirement has no choice but to use the data, you either go "up the line" through your bosses until you either get it done or a flat no, or you put your requirement through to production in the normal way when you will have no problem accessing the production data.

If you try another approach, you'll likely loose your job. Everything possible you could think of to get at the production data outside of proper channels will leave a trail that leads right to you. Don't for a microsecond consider it.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Jul 28, 2011 4:19 pm    Post subject:
Reply with quote

All the answers are wrong. The TS should ask his company to put all
data on shared dasd, so the TS can test till the company goes down the drain. We lose another competitor and hopefully a lot of so called IT engineers/specialists and whatever they call themselves.
Back to top
View user's profile Send private message
byasmeen

New User


Joined: 01 Mar 2010
Posts: 15
Location: chennai

PostPosted: Thu Jul 28, 2011 4:38 pm    Post subject:
Reply with quote

I am aware of the scenario mentioned by dbzTHEdinosauer. But it is not what i am looking for.
Usually when we run a job we will access the data from the same environment as that of job. But i want to run a job in TEST setup by directly accessing data from another environment.
I am extremely sorry if my point is not clear according to you. But this is the requirement i got which i am analyzing if it can be done.

Thanks.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Thu Jul 28, 2011 4:42 pm    Post subject: Reply to: Run a JCL in Test environment by pulling data from
Reply with quote

topic locked to prevent further stupidity !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Unwrap the data based on delimiter X'25' bhavana yalavarthi DFSORT/ICETOOL 30 Fri Dec 09, 2016 10:25 am
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm


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