db2 snapshot timestamp explanation
Posted on 2010-08-30
If i scheduled snapshot through crontab at every 15 minutes as ,
db2 get snapshot for all on <dbname> |
gzip -9 > $DIR/snapshot_all_<dbname>_$(date +%Y_%m_%d_%H_%M).out.gz
then as output i got following files,
If I open 2nd file i.e. snapshot_PRDDB_2010_08_16_14_30.out then I got following value
Snapshot timestamp = 08/16/2010 14:30:02.182330
What does this timestamp mean,
SQL's logged in this snapshot executed from 14:15 to 14:30 OR 14:30 to 14:45 ?
If anyone has Idea please help me on this.