Db2

 View Only
  • 1.  Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives

    Posted Mon March 13, 2023 09:31 AM

    Hello All,

    Looking for the alternate columns/joining queries from new table functions , which were present in deprecated functions (Versioned 10.1 or 10.5).

    Sharing the list below:



    ------------------------------
    Khushbu Jain
    ------------------------------



  • 2.  RE: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives

    Posted Tue March 14, 2023 03:15 AM

    Hello Khushbu,

    I cannot see the list.

    Usually the documentation for the new functions mention which functions they replace.

    Regards



    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------



  • 3.  RE: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives

    Posted Wed March 15, 2023 02:04 AM
      |   view attached
    Thanks for the reply Yves-Antoine .
    Sharing the list as a image for reference along with excel sheel , as those columns were not seen in new functions. 


    ------------------------------
    Khushbu Jain
    ------------------------------

    Attachment(s)



  • 4.  RE: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives

    Posted Wed March 15, 2023 06:08 AM
    Edited by Yves-Antoine Emmanuelli Wed March 15, 2023 06:10 AM

    Hello Khushbu,

    You may have to use other functions, the catalog tables, or maybe special registers to get the information you want.

    For example you can join the results of MON_GET_ACTIVITY and MON_GET_PKG_CACHE_STMT on column EXECUTABLE_ID to retrieve SQL Statement specific information such as STMT_TYPE_ID.

    In MON_GET_ACTIVITY, you have local_start_time to fullfill the need for stmt_start, member, coord_member, dbpartitionnum, coord_partition_num, to fullfill the need for stmt_node.

    I am mostly happy to use view MON_DB_SUMMARY instead of MON_GET_DATABASE.

    If you have a lot of queries referencing deprecated objects, you might consider hiring a specialised skill to rewrite them.

    Hope this helps.

    Regards.



    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------



  • 5.  RE: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives

    Posted Thu March 16, 2023 08:59 AM

    Thanks for the suggestion and pointers Yves-Antoine Emmanuelli.

    Really appreciate that .



    ------------------------------
    Khushbu Jain
    ------------------------------