Db2 Tools for zOS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Deprecated Function snap_get_lock alternative columns

  • 1.  Deprecated Function snap_get_lock alternative columns

    Posted 04/03/23 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
    ------------------------------


Related Content