Hi,

When I use the following command the right values for all fields are
returned properly.

db2 get snapshot for all on '<db name>'

When using the SNAPSHOT Monitor SQL table functions some fields are
reurned as zero.

db2 "select * from table (SNAPSHOT_DYN_SQL('<db name>',-1)) as T" >
dyn_sql_activity.txt

Fields that come back with the correct value are :

PREP_TIME_WORST,
PREP_TIME_BEST

Fields that come back with a zero value:

ROWS_READ
ROWS_WRITTEN
TOTAL_EXEC_TIME
TOTAL_SYS_CPU_TIME
TOTAL_USR_CPU_TIME

I would like al of the fields returned when using the SNAPSHOT Monitor SQL
table functions.

What am I doing wrong?

Thanks

Dave Fritz
Technical Specialist
Manulife Japan
25 Water, Ground Floor, Del Stn KC-10
Tel: (519) 747-7000 x38714 Fax: (519) 743-8316
Email: [Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page