I'm trying to get snapshot table function to work but I'm stuck for the
moment. I want to collect information about rows_read , rows_written
etc and if I runs the following after I switched on all the monitors
switches
select substr(table_schema,1,10) as tbschema,
substr(table_name,1,30) as tbname,
rows_read,
rows_written,
overflow_accesses,
page_reorgs
from table (SNAPSHOT_TABLE(' ',-1)) as snapshot_table
where (table_schema not like 'SYS%' and
(table_name not like 'SYS%' and table_name not like 'EXP%'))
order by rows_read desc
fetch first 10 rows only;
rows_read is always zero.. but a db2 get snapshot for tables on dbalias
shows rows_read,rows_written and I dont understand why it doesn't show
up on a select from SNAPSHOT_TABLE...
DB21085I Instance "db2idbpr" uses "64" bits and DB2 code release
"SQL08023"
with level identifier "03040106".
Informational tokens are "DB2 v8.1.0.96", "s050811", "U803921", and
FixPak
"10".
Product is installed at "/opt/IBM/db2/V8.1".
on Solaris but I have also tried this on Linux and Windows with the
same level on db2 and the result is the same...
/Roger