I'm an intern in a software company and thus I'm really new at the whole DB2 thing. So I hope you don't mind if I ask some newb questions.
As I see it there are 2 general possibilities to get any kind of snapshot (besides "get snapshot for ..." command). These are to use the db2GetSnapshot() API or to issue SQL queries like "select * from table (snapshot_dbm (-1)) as snapshot_dbm".
I also read that SQL queries for snapshot function are only available in DB2 V8. Is that correct?
My problem now is to find out, which one is the most efficient way to access the snapshot data. Does anyone have some experience on using db2getsnapshot api? Can you also access single values without taking an entire snapshot?