Track Changes to tablespace



IBM's flagship relational database management system

Track Changes to tablespace

Postby jaggz » Thu Feb 10, 2011 4:16 pm

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.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: Track Changes to tablespace

 

Re: Track Changes to tablespace

Postby dick scherrer » Fri Feb 11, 2011 2:56 am

Hello,

Users should not make changes to tablespaces. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Track Changes to tablespace

Postby GuyC » Fri Feb 11, 2011 1:59 pm

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

Re: Track Changes to tablespace

Postby jaggz » Fri Feb 11, 2011 2:10 pm

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.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: Track Changes to tablespace

Postby GuyC » Fri Feb 11, 2011 2:17 pm

triggers
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Track Changes to tablespace

Postby Viswanathchandru » Fri Feb 11, 2011 5:15 pm

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
Viswanathchandru
 
Posts: 271
Joined: Mon Oct 25, 2010 2:24 pm
Has thanked: 25 times
Been thanked: 0 time

Re: Track Changes to tablespace

Postby GuyC » Fri Feb 11, 2011 8:21 pm

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

Re: Track Changes to tablespace

Postby jaggz » Fri Feb 11, 2011 8:53 pm

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.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post