IBM PureData System for Analytics, Version 7.1

$v_hist_table_access_stats

The $v_hist_table_access_stats view lists the names of all the tables that are captured during table access and provides some cumulative statistics.

Table 1. $v_hist_table_access_stats View
Name	Description
dbname	The name of the database to which the session is connected
schemaname	The schema name as specified in catalog.schema.table
tablename	The table name of the table
refs	The number of times that this table was referenced
num_selected num_inserted num_deleted num_updated num_truncated num_dropped num_created num_genstats num_locked num_altered	The number of times that this table was referenced in the following types of clauses: SELECT INSERT DELETE UPDATE TRUNCATE DROP CREATE GENERATE STATISTICS LOCK ALTER