Page 1 of 1

Track Changes to tablespace

PostPosted: Thu Feb 10, 2011 4:16 pm
by jaggz
Hi,

This question is just for the knowledge purpose. Is it possible to track the changes made to any Tablespace by the users.

Please let me know if it needs more explanation.

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 2:56 am
by dick scherrer
Hello,

Users should not make changes to tablespaces. . .

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 1:59 pm
by GuyC
I think he means changes to the data inside a table in a tablespace:
you could try to rewrite this http://www-01.ibm.com/software/data/db2 ... ls/db2lat/

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 2:10 pm
by jaggz
Guyc,

You pointed out right. Apology for not being more precise too. Instead of tools are there any other methods or process using which we can track these changes.

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 2:17 pm
by GuyC
triggers

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 5:15 pm
by Viswanathchandru
Hello Guy C,
The same scenario but different need. My scenario wherein we have to find the person who has gone for an update in a particular table space( i mean the user) what you have addressed is trigger that could possibly find only the changes that has happened.( upto my knowledge apologies if m wrong). Will that be helpful to find the changes in the log datasets to find the user who has gone for a change in the table space. Apologies if m wrong.

Regards,
V

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 8:21 pm
by GuyC
no, triggers are small programs that are executed when a row is inserted, updated or deleted.
If you define & write them, then you can keep a kind of audit trail yourself.

I'm sure - theoretically - you can dump/read the transaction logs somehow & do search in the internal structures (just like the tools do) , but I have never bothered to do so. because it would require a huge amount of research, diskspace and time.

try reading this, maybe you can figure it out :
http://publib.boulder.ibm.com/infocente ... record.htm

Re: Track Changes to tablespace

PostPosted: Fri Feb 11, 2011 8:53 pm
by jaggz
Guy,

For a specific audit trail the SMF records works wonders. As I found from the IBM site that DB2 trace would fetch the desired result.