Oninit cdi / Archive
Talk to an expert →

how can findout the last updated for a particular

Posted in 2008

Topics: General Discussion

VENKATESH — — source: IIUG Forums & Mailing Lists

Hi All, I would like to know how I can check through the log and findout when a particular table last updated. Please Help us. Advanced Thanks Ramesh

↪ replying to VENKATESH
GARY GU — — source: IIUG Forums & Mailing Lists

Hi, may try onlog, eg. $onlog -t tblspace_num -n logid |less where tblspace_num is the partnum of a table in systables or partn in sysfragments if the table is fragmented. logid can be one of uniqid from onstat -l output, the max(uniqid) is the current log; if log files are backed up to tape, need to use -b option to read from tape device. Then search on 'UP' to get the update information, you can find the time info at BEGIN/COMMIT records around. Above is based on 7.3, please refer your 'Administrator’s Guide' for more details on how to use onlog and interpret logical-log records. HTH, Gary Gu

↪ replying to GARY GU
VENKATESH — — source: IIUG Forums & Mailing Lists

Thanks for your response.

Related threads