CISCOMMON SERVICES FOR Z/OS90S SERVICESDATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OSCOMMON PRODUCT SERVICES COMPONENTCommon ServicesDatacom/ADCA ECOMETER SERVER COMPONENT FOCEasytrieve Report Generator for Common ServicesINFOCAI MAINTENANCEIPCUNICENTER JCLCHECK COMMON COMPONENTMainframe VM Product ManagerCHORUS SOFTWARE MANAGERCA ON DEMAND PORTALCA Service Desk Manager - Unified Self ServicePAM CLIENT FOR LINUX ON MAINFRAMEMAINFRAME CONNECTOR FOR LINUX ON MAINFRAMEGRAPHICAL MANAGEMENT INTERFACEWEB ADMINISTRATOR FOR TOP SECRETXpertwareCompress Data Compression for MVSCompress Data Compression for FujitsuJARSJARS Resource AccountingJARS SMF Director
Issue/Introduction
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
Resolution
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