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
 

 

DS Trigger an ESP

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vignesh31

New User


Joined: 20 Dec 2011
Posts: 4
Location: India

PostPosted: Thu Aug 22, 2013 6:19 pm    Post subject: DS Trigger an ESP
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


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

PostPosted: Fri Aug 23, 2013 4:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
vignesh31

New User


Joined: 20 Dec 2011
Posts: 4
Location: India

PostPosted: Tue Sep 03, 2013 10:11 am    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


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

PostPosted: Tue Sep 03, 2013 12:37 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Sep 03, 2013 1:27 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


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

PostPosted: Tue Sep 03, 2013 7:55 pm    Post subject:
Reply with quote

A nice way of using "Usually", expat - icon_wink.gif icon_biggrin.gif
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to track incoming input files tha... shreya19 JCL & VSAM 6 Thu Feb 25, 2016 6:15 pm
No new posts Issue in trigger vickey_dw DB2 3 Wed Feb 10, 2016 5:41 pm
No new posts Trigger a mainframe job by mail Praveen Thenraj IBM Tools 8 Wed Jan 13, 2016 12:05 pm
No new posts Setting up a new trigger krisprems DB2 4 Thu Dec 24, 2015 10:33 pm
No new posts Can a DB2 insert trigger execution of... TS70363 DB2 6 Tue Nov 24, 2015 10:44 pm


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