DB2 - L

Expand all | Collapse all

NuLlid collection in DB2 12 FL500

  • 1.  NuLlid collection in DB2 12 FL500

    Posted 4 days ago
    Hi 

    Our application is heavily dependent on NULLID collection ,and its packages.

    After migrating to v12 FL500, Do we need to rebind packages of NULLID collection?

    If so, My concern is REBIND will impact SQL Access paths?

    Thanks 
    Regards 
    Leila 


  • 2.  RE: NuLlid collection in DB2 12 FL500

    Posted 4 days ago
    These packages do not control the access paths for the dynamic SQL that is passed through them.  You may want to rebind them and change the APPLCOMPAT level to reflect the new version and enable the new SQL functionality.

    ------------------------------
    David Simpson
    Lead Data Engineer
    Transamerica
    ------------------------------



  • 3.  RE: NuLlid collection in DB2 12 FL500

    Posted 4 days ago
    Thanks David 






  • 4.  RE: NuLlid collection in DB2 12 FL500

    Posted 4 days ago
    Hi Leila,

    You can bind multiple copies of the NULLID collection (using SDSNSAMP(DSNTIJLC)).
    For example:
    NULLID (keep at V11R1 or V12R1M100 or possibly V12R1M500)
    NULLID_V12R1M500 (bound at FL500)
    NULLID_V12R1M501 (bound at FL501)
    ...
    NULLID_V12R1M509 (bound at FL509)

    By default applications will use NULLID, but applications that want to exploit higher function levels can then use currentPackageSet=NULLID_V12R1Mxxx

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 5.  RE: NuLlid collection in DB2 12 FL500

    Posted 3 days ago
    Hello Leila,

    You only need to rebind your NULLID packages with a new APPLCOMPAT if your applications want to exploit the new SQL functionality introduced by function level 500. You can see a list of all the SQL changes in the IBM documentation. You can find out more in my two part blog on DB2 12 for z/OS, DRDA Applications and Application Compatibility .

    Regards,

    Gareth

    ------------------------------
    Gareth Copplestone-Jones
    Triton Consulting
    ------------------------------