trace modified rows in certain time interval?

Posted in 2007

GERARDO PADIERNA — Thu, 26 Jul 2007 10:48:34 — source: IIUG Forums & Mailing Lists

Hello, I'd like to know if it's possible to find out wich tables have been modified (by an insert or an update) for a given database in a certain time interval (e.g. last 24h). I've read about the onlog tool in the IBM Admin-Manual, that seems to be somehow what I'm looking for, but I cannot figure out how. (The database for wich I need to find out is in buffered logging mode). Maybe this info is contained also in the system catalog tables... Anyone has a clue? Thanks a lot.

↪ replying to GERARDO PADIERNA

Jack Parker — Thu, 26 Jul 2007 11:43:23 — source: IIUG Forums & Mailing Lists

Provided you don't have auditing turned on, onlog is your best shot for specifics like that. System catalogues do not contain information of that nature. I had a colleague (lost touch with him) who rebuilt a database based on onlog output which he parsed programmatically, it is possible. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of GERARDO PADIERNA Sent: Thursday, July 26, 2007 6:49 AM To: ids@iiug.org Subject: trace modified rows in certain time interval? [9624] Hello, I'd like to know if it's possible to find out wich tables have been modified (by an insert or an update) for a given database in a certain time interval (e.g. last 24h). I've read about the onlog tool in the IBM Admin-Manual, that seems to be somehow what I'm looking for, but I cannot figure out how. (The database for wich I need to find out is in buffered logging mode). Maybe this info is contained also in the system catalog tables... Anyone has a clue? Thanks a lot. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to GERARDO PADIERNA

ART KAGEL, — Fri, 27 Jul 2007 14:52:57 — source: IIUG Forums & Mailing Lists

There's no info about this in the system catalog. If you are not using the Secure Audit product, then the only thing you can do is to scan the logical logs with onlog looking for updated records for the table's partnum(s). You can get the partnum(s) of the table from sysmaster:systabnames or from <database>:systables (or sysfragments for fragmented tables). Please read the manuals about how to read and interpret the onlog output. Art S. Kagel ----- Original Message ----- From: Gerardo Padierna <ids@iiug.org> At: 7/26 6:49:29 Hello, I'd like to know if it's possible to find out wich tables have been modified (by an insert or an update) for a given database in a certain time interval (e.g. last 24h). I've read about the onlog tool in the IBM Admin-Manual, that seems to be somehow what I'm looking for, but I cannot figure out how. (The database for wich I need to find out is in buffered logging mode). Maybe this info is contained also in the system catalog tables... Anyone has a clue? Thanks a lot. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.