RCSBIND - Bind a static
RLX
SQL application plan

Describes the RCSBIND catalogued procedure to BIND the Db2 application plan to be used in conjunction with your compiled
RLX
application.
The sample JCL shows the RCSBIND catalogued procedure to BIND the Db2 application plan to be used in conjunction with your compiled
RLX
application.
//*--------------------------------------------------------------------- //* (C) COPYRIGHT RELATIONAL ARCHITECTS INTL. //* LICENSED MATERIAL - PROGRAM PROPERTY RELATIONAL ARCHITECTS INTL //*--------------------------------------------------------------------- //* RLX/COMPILE - BIND Db2 APPLICATION STATIC PLAN //*--------------------------------------------------------------------- //RCSBIND PROC RLXEXEC='RAI.Rvrm.CRAIEXEC, ** RLX SYSTEM EXEC LIB // RLXCNTL='RAI.Rvrm.CRAIJCL', ** RLX SYSTEM CNTL LIB // RCSDBRM='USER.DBRMLIB', ** USER DBRMLIB // DSNLOAD='DSN.SDSNLOAD', ** Db2 LOAD LIBRARY // DSNLINK='DSN.SDSNLINK' ** Db2 LINKLIST LIBRARY //*--------------------------------------------------------------------- //* BIND Db2 APPLICATION STATIC PLAN //*--------------------------------------------------------------------- //BIND EXEC PGM=IKJEFT01,DYNAMNBR=10,REGION=1536K,COND=(4,LT) //STEPLIB DD DSN=&DSNLOAD,DISP=SHR // DD DSN=&DSNLINK,DISP=SHR //SYSPROC DD DSN=&RLXEXEC,DISP=SHR //SYSUT1 DD DISP=NEW,SPACE=(CYL,(0,1),RLSE),UNIT=SYSDA //SYSUT2 DD DISP=NEW,SPACE=(CYL,(0,1),RLSE),UNIT=SYSDA //SYSUT3 DD DISP=NEW,SPACE=(CYL,(0,1),RLSE),UNIT=SYSDA //SYSUT4 DD DISP=NEW,SPACE=(CYL,(0,1),RLSE),UNIT=SYSDA //SYSUT5 DD DISP=NEW,SPACE=(CYL,(0,1),RLSE),UNIT=SYSDA //SYSPRINT DD SYSOUT=* //SYSTERM DD SYSOUT=* //SYSIN DD SYSOUT=* //DBRMLIB DD DSN=&RCSDBRM,DISP=SHR /* USER DBRMS //SYSTSPRT DD SYSOUT=* //SYSTSIN DD DSN=&CRAIJCL(RCSBINDI),DISP=SHR
The next sample illustrates how to invoke the RCSBIND catalogued procedure to BIND the static Db2 application plan associated with your compiled
RLX
application. The numbers in the right margin correspond to the numbered, annotating paragraphs:
(1)
RCSBIND is invoked as a catalogued procedure. RCSBIND can also be included instream with the JCL.
(2)
The default DBRM library that is identified by the procedure RCSDBRM parameter is overridden explicitly to identify your own DBRM library. Other procedure defaults should be overridden as required.
(3)
Bind input parameters are defined and supplied through the RCSPARMS DD statement. This example illustrates their specification instream with the JCL but they can also be specified through an external dataset. The BIND parameters themselves are described individually in items (4) through (9).
(4)
The first positional BIND parameter (labeled USERID) specifies the Db2 authorization ID of the plan owner.
(5)
The next positional BIND parameter (labeled PLAN_NAME) specifies the name of the static Db2 application plan being bound.
(6)
The next positional BIND parameter (labeled Db2_SUBSYSTEM) identifies the Db2 subsystem into which the application plan should be bound.
(7)
The next positional BIND parameter (labeled Db2_RELEASE) identifies the version and release level of the Db2 subsystem into which the application plan is bound. Valid values are releases of Db2 that IBM currently supports.
(8)
The next positional BIND parameter (labeled DBRM_1) identifies the name of the first (and only) DBRM to be bound into the static Db2 application plan. The DBRMs to be bound into the plan are those produced by one or more executions of the RCSPC procedure.
(9)
The next positional BIND parameter (labeled DBRM_2) identifies the name of the second DBRM (if any) to be bound into the static Db2 application plan. You can specify as many DBRM positional parameters as necessary.
//JOB3 JOB (PARMS) //STEP1 EXEC RCSBIND, (1) // RCSDBRM='YOUR.DBRMLIB' (2) //RCSPARMS DD * (3) USERID,PLAN_NAME,Db2_SUBSYSTEM,Db2_RELEASE,DBRM_1,DBRM_2,.... (4) (5) (6) (7) (8) (9)