Search which DBRM has been included in particular Plan

kramesh · New User Joined: 25 Jul 2005 Posts: 1

Hi all,

How to search which DBRM has been included in particular Plan?

Thanks...

shinjini_t · Posted: Tue Aug 02, 2005 10:49 am Post subject: Re: db2

This will be mentioned in the JCL which you are using for the BIND.

See the example below:

//*---------------------------------------------------------------------
//* PERFORM DB2 BIND ON PLAN
//*---------------------------------------------------------------------
//*
//BIND EXEC PGM=IKJEFT01,
// DYNAMNBR=20,
// COND=(04,LT,FIR0ERM)
//*
//STEPLIB DD DISP=SHR,DSN=SYS1.DSNDBN1.RUNLIB.LOAD *1 DAI#DB2S
// DD DISP=SHR,DSN=SYS1.DSNDBN1.SDSNLOAD *1 DAI#DB2S
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM (DBN1)
BIND PLAN(FIR0ERMU) -
MEMBER(FIR0ERM) -
LIBRARY( -
'FIRR034.SHINJU.DBRM' -
'FIRR034.DEV.DBRM' -
'FIRR034.SYS.DBRM' -
'FIRR034.REL.DBRM' -
) -
OWNER(FIRDEV),QUALIFIER(FIRDEV),KEEPDYNAMIC(YES) -
DEGREE(ANY),CURRENTDATA(NO),DYNAMICRULES(BIND)
END
//*

here name of the DBRM is FIR0ERM and the libraries where to search for them are:
'FIRR034.SHINJU.DBRM' -
'FIRR034.DEV.DBRM' -
'FIRR034.SYS.DBRM' -
'FIRR034.REL.DBRM' -

Thanks & Regards,
Shinjini

kvivek