Hi friends,

Could some one here tell me why db2 does not grab history for applications where as it has history for dynamic sql snapshot

db2 "select UOW_START_TIME,UOW_STOP_TIME from table(SNAPSHOT_APPL('MARKETDB',-1)) as SNAPPL"


When i use the above statement,it just gives the information about the current running applications..Both my instance level and CLP level monitor switches are on..Shouldnt it give the earlier ones like yesterday`s or day before..If not why does the snapshot_dyn_sql give the history and not SNAPSHOT_APPL??


Thanks

By definition, snapshot is a momentary copy of the system state. Dynamic SQL snapshot obtains information from the statement cache, where statement plans and the corresponding statistics can remain for some time, until it is replaced by more recent statements. In other words, it is not a "history" of dynamic SQL, it's a momentary state of the dynamic statement cache.

What about the number of rows read in SNAPSHOT_TABLE function..Does that have a historical counter??

So, with out using event monitors there is no way we can capture historical info in DB2?

I would call that "cumulative", not "historical". Normally you cannot rely on the absolute value of those counters, because you have no idea when they were reset; you look at the change in the counter value between two consecutive snapshots.

If you want to keep history for a known interval you would need to schedule regular snapshots during that interval. That is what the snapshot function are for.