Really appreciate that .
Original Message:
Sent: Wed March 15, 2023 06:08 AM
From: Yves-Antoine Emmanuelli
Subject: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives
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
Original Message:
Sent: Wed March 15, 2023 02:04 AM
From: Khushbu Jain
Subject: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives
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
Original Message:
Sent: Tue March 14, 2023 03:15 AM
From: Yves-Antoine Emmanuelli
Subject: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives
Hello Khushbu,
I cannot see the list.
Usually the documentation for the new functions mention which functions they replace.
Regards
------------------------------
Yves-Antoine Emmanuelli
Original Message:
Sent: Mon March 13, 2023 08:02 AM
From: Khushbu Jain
Subject: Db2 Deprecated Table Function in 10.1 and 10.5 column alternatives
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
------------------------------