|
|
| Author |
Message |
kanisha_prabha
New User
Joined: 10 Mar 2006
Posts: 13
|
|
|
|
Hi,
I want a DB2-PLI program which is compile/bound in PROD region to run in TEST region. (There are a large no. of such programs that are used to set up a region with data and since they are in prod i dont want to compile/bind each of them in TEST). I am using IKJEFT01 utility to run programs. Firstly, Can i do it? If so, then how should i modify my run JCL?
//PPogram EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=DSN2.DSNLOAD,DISP=SHR
// DD DSN=........PROD.LOAD,DISP=SHR
//I1PCHG DD DSN=........................,DISP=SHR
//O1REPT DD DSN=.........................,DISP=(,CATLG),
// UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE),
// DCB=(RECFM=FBA,LRECL=133)
//O1PRICE DD DISP=(,CATLG),DSN=.........................,
// UNIT=SYSDA,SPACE=(CYL,(10,10),RLSE),
// DCB=(RECFM=FB,LRECL=74)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2D)
RUN PROG(MYPROG) PLAN(MYPLAN) PARM('/')
END
/*
TIA,
Kanisha. |
|
| Back to top |
|
 |
References
|
|
 |
raak
Active User
Joined: 23 May 2006
Posts: 174
Location: chennai
|
|
|
|
hi there,
i guess u need to compile and bind it everytime.... in our shop, for enterprise cobol conversion testing, we are doing like that....
not very sure whether there is something of the kind u r asking |
|
| Back to top |
|
|
surya_pathaus
Active User
Joined: 28 Aug 2006
Posts: 92
|
|
|
|
Hi,
| Quote: |
Firstly, Can i do it?
|
Your program is binded with Production Database, so whatever selection, updation, deletion process will be done on Production Database.
If you want to test it then be careful about Updations, insertions, deletions of tables. Only select/read of tables affected then you can continue your testing.
No need to change the JCL because Load library you need to pick from Production and Region you binded with Production. |
|
| Back to top |
|
|
Nimesh.Srivastava
Active User
Joined: 30 Nov 2006
Posts: 76
Location: SINGAPORE
|
|
|
|
Hi,
Okay here is what we do to run programs from production to test / UAT environment.
firstly for a DB2 program you need to definately bind the packages to your UAT plan in DB2. And then the same executable can be used to run the programs.
a sample run JCL would go like
//STEP010 EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=X
//STEPLIB DD DSN=SYS2.DSNLOAD,DISP=SHR
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(<your batch program>) PLAN(<UAT Plan>) -
LIBRARY ('<production load library>') -
PARMS('<optional parms>')
END |
|
| Back to top |
|
|
|
|
|
