IBM's flagship relational database management system


Postby Gandosio » Wed Mar 06, 2013 6:25 pm

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?

Posts: 12
Joined: Tue Dec 21, 2010 3:47 pm
Has thanked: 0 time
Been thanked: 2 times


Postby GuyC » Thu Mar 07, 2013 2:11 pm

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.
I can explain it to you, but i can not understand it for you.
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2