176 DB2 Manager User Guide
StorageTek Proprietary
OTDBPKG
Member OTDBPKG creates the DB2 Manager DB2 application packages.
//OTDBPKG JOB
//*
//* DB2 Manager DB2 package creation job.
//*
//* Change history:
//* GW 19-Mar-03 V1.1 created
//* GW 02-Apr-04 V1.1 re-branded
//* GW 30-Apr-04 V1.1 OTDBL130 added
//*
//* This job creates the DB2 application packages
//* required for DB2 Manager implementation.
//*
//* Amend the job as follows before submitting:
//*
//* 1. Alter the STEPLIB DD card to specify name of the
//* DB2 runtime load library on the host system.
//*
//* 2. Change the name of the DB2 subsystem (DB2) in
//* the DSN statement to match the subsystem name
//* in use on the host system.
//*
//* 3. Change the dataset name on the DBRMLIB card
//* to specify the name of the DB2 Manager DBRM
//* library unloaded from file 2 of the distribution tape.
//*
//BIND EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=DB2.runtime.library,DISP=SHR
//DBRMLIB DD DSN=Database.Manager.DBRM.library,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2)
BIND PACKAGE(OTDBL100) -
MEMBER(OTDBL100) -
ACTION(REPLACE) -
VALIDATE(BIND) -
ISOLATION(CS) -
FLAG(E) -
SQLERROR(CONTINUE) -
RELEASE(COMMIT) -
EXPLAIN(NO) -
KEEPDYNAMIC(YES)
BIND PACKAGE(OTDBL120) -
MEMBER(OTDBL120) -
ACTION(REPLACE) -
VALIDATE(BIND) -
ISOLATION(CS) -
FLAG(E) -
SQLERROR(CONTINUE) -
RELEASE(COMMIT) -
EXPLAIN(NO) -