Need SP23BIND job for DB2 z/OS verion 11.

Document ID : KB000093677
Last Modified Date : 01/05/2018
Show Technical Document Details
Question:
The job SP23BIND that the manual says to use for BIND only has PLAN to be BIND and is missing the PACKAGE BIND part, that is necessary from DB2 above version 9. 
Could you let us know where we can find the correct job?
Environment:
z/OS 
Common Services
CA JARS w/DB2 interface
Answer:
This job has been certified under DB2 V12 and should work going forward.
 
//DBRMLIB DD DSN=&SMPHLQ..CAIMAC,DISP=SHR ---> this should be your Common Services CAIMAC 
// PEND 
//* 
//SP23BIND EXEC SP23B 
//BIND.SYSTSIN DD * 
DSN SYSTEM( ) /* *** NOTE 2 *** */ 
BIND PLAN(CAISSQL2) MEM(CAISSQL2) + 
ACTION(REPLACE) RETAIN 
BIND PLAN(CAISSQL3) MEM(CAISSQL3) + 
ACTION(REPLACE) RETAIN 
BIND PLAN(CAISSQL9) MEM(CAISSQL9) + 
ACTION(REPLACE) RETAIN 
END 
 
Sample output to be expected:
The PACKAGE is automatically generated for each of the SQL provided by Common Services. 

ex: 
BIND PLAN(CAISSQL2) MEM(CAISSQL2) ACTION(REPLACE) RETAIN 
DSNT226I !D12A DSNTBAP1 BIND WARNING FOR PLAN CAISSQL2 
THE MEMBER OPTION IS DEPRECATED AND 
SUPPORT WILL BE REMOVED IN THE FUTURE 
DSNT254I !D12A DSNTBCM2 BIND OPTIONS FOR 
PACKAGE = D12APTIB.DSN_DEFAULT_COLLID_CAISSQL2.CAISSQL2.() 
ACTION ADD