Need SP23BIND job for DB2 z/OS verion 11.
search cancel

Need SP23BIND job for DB2 z/OS verion 11.

book

Article ID: 93677

calendar_today

Updated On:

Products

CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware Compress Data Compression for MVS Compress Data Compression for Fujitsu JARS JARS Resource Accounting JARS 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