IBM Mainframe Forum

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.

Hello,

Users should not make changes to tablespaces. . .

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/

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.

triggers

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

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

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.