Db2

 View Only
Expand all | Collapse all

DCW for native Db2 (DB2_COMPATIBILITY_VECTOR=NULL)

  • 1.  DCW for native Db2 (DB2_COMPATIBILITY_VECTOR=NULL)

    Posted Wed June 15, 2022 01:28 PM
    Hello.  This is questions regarding DCW and DCW Lite.

    [Question]
    1) Can we set DCW to convert SQL and PL/SQL for native Db2 (DB2_COMPATIBILITY_VECTOR=NULL)?
    2) Can we set DCW Lite (a.k.a. Database Harmony Profiler) to convert SQL and PL/SQL for native Db2 (DB2_COMPATIBILITY_VECTOR=NULL)?

    [Background]
    A customer going to migrate his Oracle wants to use native Db2, because he believes performance is better in the native mode than in the compatibility mode.

    [Reference]
    https://www.ibm.com/docs/en/db2/11.5?topic=features-db2-compatibility-vector-registry-variable
    DB2_COMPATIBILITY_VECTOR registry variable

    ------------------------------
    KAZUTAKA YAMASAKI
    ------------------------------

    #Db2


  • 2.  RE: DCW for native Db2 (DB2_COMPATIBILITY_VECTOR=NULL)

    Posted Wed June 22, 2022 02:24 AM
    I hear from a Db2 development person that the answers are NO.  That is, Oracle compatibility mode should be ON for both DCW and DCW Lite.

    ------------------------------
    KAZUTAKA YAMASAKI
    ------------------------------