Extraction for session lock information for db2 is using old functions that are now depreciated and should be fixed.
DB2 LUW 9.0
SNAPSHOT_LOCK (dbname,dbpartitionnum)
Note: This table function has been deprecated and replaced by the SNAPLOCK administrative view and SNAP_GET_LOCK table function – Retrieve lock logical data group snapshot information.
SNAPSHOT_APPL_INFO
Note: This table function has been deprecated and replaced by the SNAPAPPL_INFO administrative view and SNAP_GET_APPL_INFO table function – Retrieve appl_info logical data group snapshot information.
DB2 LUW 9.5 +
SNAPSHOT_APPL_INFO
Note: This table function has been deprecated and replaced by the SNAP_GET_APPL_INFO table function – Retrieve appl_info logical data group snapshot information.
Issue #5083 |
Closed |
Duplicate |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
duplicates #11923
Issue #11923IBM DB2 UDB 10.5 Session Manager - No authorized routine named "SNAPSHOT_APPL" |