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_STMT alternative columns

  • 1.  Deprecated Function SNAP_GET_STMT alternative columns

    Posted 04/03/23 08:44 AM

    Hi Team,

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

    suggested new table function in the site is MON_GET_ACTIVITY. 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_STMT :
    https://www.ibm.com/docs/en/db2/10.5?topic=views-snap-get-stmt


    1. stmt_start
    2. stmt_type 
    3. creator
    4. stmt_node_number
    5. stmt_operation


    Regards,
    Ritu






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


Related Content