DB2:getTableMetrics

Get license usage information.

Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.

Type

SYNC, IMPACT_INFO

None.

Name	Type	Description
Table Schema	String	Schema name.
Table Name	String	Table Name
Table Type	String	Table Type. One of: USER_TABLE, TEMP_TABLE, CATALOG_TABLE
Total Table Scans	Big Integer	Total Table Scans.
Total Rows Read	Big Integer	Total Rows Read.
Total Rows Inserted	Big Integer	Total Rows Inserted.
Total Rows Updated	Big Integer	Total Rows Updated.
Total Rows Deleted	Big Integer	Total Rows Deleted.

Invoke this method to identify information about various table metrics.

Did you find this helpful?

Yes No