About PACKAGE BIND support of PANSQL R2.4 for DB2 V10 and above

Products

• PAN/SQL

Issue/Introduction

Since the DB2 V10, based on the changes of the specifications of the DB2 system, a PACKAGE is required for a PLAN.
What does PANSQL R3.4 need to support DB2 V10 or higher?

Environment

Release : 2.4

Resolution

The following PTFs must be applied to the PANSQL R2,4C.
Then, the IJ3STGE1 and CB2ACMDL must be rerun after applying those PTFs.
(The IJ3STGE1 and CB2ACMDL must be also rerun after each upgrade of their DB2)

QO81095
QO81778
QO93564
RO20082

In the prepared BIND commands for the PANSQL R2.4, the PANSQL PLAN is created from a DBRM.
Even if the prepared BIND commands are performed on the DB2 V10, a proper PANSQL PLAN can be created after a PACKAGE is created automatically by the DB2 system.
However, the name of the automatically created PACKAGE is generated as a anyname by the DB2 system.
If you want to create a PACKAGE with a distinct name, you can use the following BIND command.

Please use the following SYSTSIN in Prefix.SAMPJCL(IJ3STGE1) jcl.

Sample:
The SYSTSIN member of the DB2BIND step should be as follows.

DSN SYSTEM(xxxx)                                                   
 BIND PACKAGE(PKDQPSAN) MEMBER(DQPS024) ACT(REPLACE) -             
      ISOLATION(CS) LIBRARY ('xxxxxxxx.DBRMLIB') -                 
      VALIDATE (BIND) SQLERROR(NOPACKAGE) -                        
      DEFER(PREPARE) ENCODING(EBCDIC)                              
 BIND PLAN(DQPS024) ACT(REPLACE) ISOLATION(CS) -                   
      VALIDATE (RUN)    -                                          
      PKLIST(*.PKDQPSAN.DQPS024) DEFER(PREPARE)   -                
      ENCODING(EBCDIC)                                             
 RUN  PROGRAM(DSNTIxx)  PLAN(DSNTIAxx)  -                          
      LIB('xxxx.RUNLIB.LOAD')                                      
END

 

Additional Information

If you have multiple DB2 subsystems, you can run the SQLINST4 instead of the IJ3STGE1 and CB2ACMDL on the other subsystems after you run the IJ3STGE1 and CB2ACMDL on one base subsystem. 
(However, if you run the SQLINST4 on subsystems, you must specify the same DBRMLIB as the IJ3STGE1 jcl, in the SQLINST4 jcl. In addition, You must use the same PANSQL load library as the CB2ACMDL, on the other subsystems)