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)

-

176

DB2 Manager User Guide

 

StorageTek Proprietary

Page 179
Image 179
StorageTek 312564001 manual Otdbpkg