View previous topic :: View next topic
|
Author |
Message |
vignesh31
New User
Joined: 20 Dec 2011 Posts: 4 Location: India
|
|
|
|
Hi,
I am in the process of creating a tool that would retrieve data from DB2 tables in Production Environment and put it in a dataset. Later we would insert the records in these Datasets into the DB2 tables in Test Environment (Data replication of specific records)
Is there a possibility to have a DS Trigger ESP Event in Test Environment where the Dataset used for triggering the Event being created in Production Environment.
If it’s not a viable condition then what is the alternative available to have the dataset created in Production ESP to trigger a ESP event in Test environment. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
To answer, technically, yes - this can be done; however, can this be done at your shop - I believe you should be asking this to someone at your shop who supports ESP implementation there.
One alternative, OTOH, I think can be - get the data-set XMITted to Test LAPR and get a Data-set triggered Job scheduled in Test LPAR. (This suggestion is subject to the assumption that I understood what is your requirement and it might be wrong.) |
|
Back to top |
|
|
vignesh31
New User
Joined: 20 Dec 2011 Posts: 4 Location: India
|
|
|
|
Hi Anuj,
Thanks for your reply post. Our side ESP implementation do no support transferring datasets between regions.
XMIT is the name I get to come across that could be used for this purpose. I tried to get a manual on using XMIT in Mainframe, but unfortunately couldn't find anything.
Is it possible for you to provide an example Job step for XMITing a dataset from Prod LPAR to Test LPAR. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
XMIT is short for TSO TRANSMIT command to send a mail file. Possibly you can try something like this:
Code: |
//STEP01 EXEC PGM=IKJEFT01,DYNAMNBR=20
//*
//SYSTSIN DD *
XMIT TESTNODE.YOURID DSN('HLQ.SLQ.LLQ')
/*
//* |
You'll execute this in your Prod LPAR and HLQ is something should be allowed in your Test LPAR as HLQ, else the job fails. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Usually,
if your site is correctly setup there will be a specific shared HLQ for this purpuse or transferring data from PROD to TEST. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
A nice way of using "Usually", expat - |
|
Back to top |
|
|
|