Sample Package BIND job is below.
//BIND EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB0T) RETRY(5)
BIND PACKAGE(MYCOLLID) -
OWNER(T9289ATD) -
QUALIFIER(T9289ATD) -
MEMBER(TESTPGM) -
LIBRARY('MY.DBRM.LIB') -
ACTION(REPLACE) -
EXPLAIN(YES) -
VALIDATE(BIND) -
ISOLATION(CS) -
FLAG(I) -
CURRENTDATA(NO) -
DEGREE(1) -
RELEASE(COMMIT) -
ENABLE(*) -
SQLERROR(NOPACKAGE)
//*Sample Plan BIND job is below.
//BIND EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB0T)
BIND PLAN ( MYPLAN ) -
OWNER ( OWNERID) -
QUALIFIER ( QUALIFIERID ) -
PKLIST ( COLL1.*,COLL2.*) -
VALIDATE ( BIND ) -
DEGREE ( 1 ) -
CACHESIZE ( 256 ) -
ISOLATION ( CS ) -
ACQUIRE ( USE ) -
RELEASE ( COMMIT ) -
ACTION ( REPLACE ) RETAIN
//*
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.