Page 1 of 1

TRACKMOD YES

PostPosted: Wed Mar 06, 2013 6:25 pm
by Gandosio
Please help..

I know that if i have setted the parameter TRACKMOD to yes the database manager tracks database modifications so that the backup utility can detect which subsets of the database pages must be examined by an incremental backup and potentially included in the backup image. I can't find where this information is stored. If i need to know with a select on a catalog table if a page has been changed since last image/full copy, is it possible?
I think that perhaps the information is in the column EPOCH of the systablepart but a tried to do a fullcopy and then to modify some records and the value of the column don't change....

Can someone give me more information?

Thanks...

Re: TRACKMOD YES

PostPosted: Thu Mar 07, 2013 2:11 pm
by GuyC
not to my knowledge, changed pages are kept in the space map pages at the start of every tablespace and there is no way to select from that.