Db2 Tools for zOS

 View Only

Deprecated Function snap_get_lock alternative columns

  • 1.  Deprecated Function snap_get_lock alternative columns

    Posted Mon April 03, 2023 08:44 AM

    Hi Team,

    I have 8 columns from snap_get_lock table function , whose alternative columns in new version I am able to find.


    suggested new table function in the site is MON_GET_LOCKS but It doesn't contain these values.

    Could you please tell me table Names and column Name where i can find these columns alternative :

    snap_get_lock

    1. SNAPSHOT_TIMESTAMP
      2. AGENT_ID
      3. LOCK_ESCALATION
      4. TABNAME
      5. TABSCHEMA
      6. TBSP_NAME
      7. DATA_PARTITION_ID
      8. DBPARTITIONNUM


    Regards,
    Ritu






    ------------------------------
    Ritu G
    ------------------------------