Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Doubt on how to identify who edited table manualy in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Sourabh_1221

New User


Joined: 24 Jan 2010
Posts: 2
Location: India

PostPosted: Mon Feb 08, 2010 12:10 am    Post subject: Doubt on how to identify who edited table manualy in DB2
Reply with quote

Hi,
In our DB2 database we have few provision tables.A couple of times we had issues when some person manually edited test tables rows that caused system instability.
My Question is there any way to put a check anywhere in adb2 by which can identify who manually edited and saved table.
or if there is any way by which we can generate reports that can reflect who has updated which row manually in which table.
Thanks!!
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Feb 08, 2010 12:40 am    Post subject:
Reply with quote

Hello,

Suggest that "some person" should not be able to "manually edit" production tables. . .

This would fail any audit or quality review. Indeed, it probably means that any/all of the data is possibly tampered with.

For these tables, there should be a maintanace process that will do the updates as well as generate an audit trail of what was done and by whom.
Back to top
View user's profile Send private message
Sourabh_1221

New User


Joined: 24 Jan 2010
Posts: 2
Location: India

PostPosted: Mon Feb 08, 2010 12:54 am    Post subject:
Reply with quote

Thanks dick for reply.
Usually Editing happens in test DB2 provision tables as lot of persons simultaneously works in test DB2 tables.
I will be thankful if you can send me any reference link using which I can have an idea of implementing maintanace process that can help us in generating Audit reports of what was done and by whom.
Thanks!!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Feb 08, 2010 1:01 am    Post subject: Reply to: Doubt on how to identify who edited table manualy
Reply with quote

Quote:
My Question is there any way to put a check anywhere in adb2 by which can identify who manually edited and saved table.


on the test environment is not usual to do some quick and dirty manual data fixing.

anybody with the proper authorizations can use qmf,spufi,dsntep to do manual table update
har to control or limit ! usually in the test environment the rules are a bit relaxed!
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Feb 08, 2010 2:48 am    Post subject:
Reply with quote

Hello,

I'm not aware of a link. . .

The environments i've supported have implemented an audit table (or series of tables) and when maintenance is performed, it is also posted in the audit. It i not difficult, but it is done in all of the maintenance programs. Typically, these are the online transactions that are recordrd. Large updaes done in batch might not be recorded the same way. It depends on the needs of the organization.

In these environments, maintenance is only done thru the installed maintenance code - not ad hoc queries.

If developers are permited to modify test data on the fly as they need, other developers may be impacted if this is not coordinated.

Several database systems have an easy was to process the log of transactions executed to aid looking for this type of info. I'm not aware of an easy way to do this with db2. . . Maybe someone else is. . .
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1239
Location: Richfield, MN, USA

PostPosted: Mon Feb 08, 2010 10:12 am    Post subject:
Reply with quote

The only method I've seen of limiting this kind of problem is to assign ranges of key values to various groups of developers and hope that each group remains "inside" their assigned ranges.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Doubt in MFS abdulrafi IMS DB/DC 2 Fri Oct 21, 2016 3:09 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us