Multiple DB2 version / Alpar support for DB2ID:
Using the following EXEC Db2I2 script to support multiple DB2 versions
The example are for co-exist of DB2 V8 & V9

-- BIND Plan:       DB2I2A                                         
DB2CMD  BIND PLAN (DB2I2A)                                       - 
DB2CMD  OWNER(DB2ADM) QUALIFIER(SYSIBM)                          - 
DB2CMD  PKLIST(                                                  - 
DB2CMD   *.DB2I2A.*                                              - 
DB2CMD  ,*.DB2I2V8.*                                             - 
DB2CMD  ,*.DB2I2V9.*                                             - 
DB2CMD         )                                                 - 
DB2CMD  NODEFER(PREPARE)  ACQUIRE(USE)                           - 
DB2CMD  CURRENTDATA(NO) DEGREE(1)                                - 
DB2CMD  CACHESIZE(1024)  DISCONNECT(EXPLICIT)                    - 
DB2CMD  ACTION(REPLACE) RETAIN                                   - 
DB2CMD  ENABLE(*)                                                - 
DB2CMD  EXPLAIN(NO)  FLAG(I) ISOLATION(CS)                       - 
DB2CMD  REOPT(NONE)  KEEPDYNAMIC(NO)                             - 
DB2CMD  DBPROTOCOL(DRDA)                                         - 
DB2CMD  ENCODING(1047) IMMEDWRITE(NO)                            - 
DB2CMD  RELEASE(COMMIT)  SQLRULES(DB2)  VALIDATE(RUN)              

-- BIND Package:    DB2I2V8.DSNTIAD                               
DB2CMD  BIND PACKAGE(DB2I2V8)                                    -
DB2CMD  OWNER(DB2ADM) QUALIFIER(SYSIBM)                          -
DB2CMD  MEMBER(DSNTIAD) LIBRARY('DSN810.DBRMLIB.DATA')           -
DB2CMD  ACTION(REPLACE)                                          -
DB2CMD  CURRENTDATA(NO) DEGREE(1)                                -
DB2CMD  ENABLE(*)                                                -
DB2CMD  EXPLAIN(NO)  FLAG(I) ISOLATION(CS)                       -
DB2CMD  REOPT(NONE)  KEEPDYNAMIC(NO)                             -
DB2CMD  DBPROTOCOL(DRDA)                                         -
DB2CMD  ENCODING(37)  IMMEDWRITE(NO)                             -
DB2CMD  SQLERROR(NOPACKAGE) VALIDATE(BIND)                        

-- BIND Package:    DB2I2V9.DSNTIAD                                
DB2CMD  BIND PACKAGE(DB2I2V9)                                    - 
DB2CMD  OWNER(DB2ADM) QUALIFIER(SYSIBM)                          - 
DB2CMD  MEMBER(DSNTIAD) LIBRARY('DSN910.DB9G.DBRMLIB.DATA')      - 
DB2CMD  ACTION(REPLACE)                                          - 
DB2CMD  CURRENTDATA(NO) DEGREE(1)                                - 
DB2CMD  ENABLE(*)                                                - 
DB2CMD  EXPLAIN(NO)  FLAG(I) ISOLATION(CS)                       - 
DB2CMD  REOPT(NONE)  KEEPDYNAMIC(NO)                             - 
DB2CMD  DBPROTOCOL(DRDA)                                         - 
DB2CMD  ENCODING(37)  IMMEDWRITE(NO)                             - 
DB2CMD  SQLERROR(NOPACKAGE) VALIDATE(BIND)                         


On SSID change plan name from DSNTIAD to DB2I2A.

By doing this, allows multiple DSNTIAD co-exist.