|
View previous topic :: View next topic
|
| Author |
Message |
satyapn9
New User
Joined: 08 Oct 2010
Posts: 27
Location: India
|
|
|
|
Hi,
Is there a way we can find out which job/process/person last updated a table looking at system tables or something in DB2?
In IBM-DB2 System Catalog, we can see only the IMAGE COPY Job/Process.
Can someone help in this please? |
|
| Back to top |
|
 |
Parthiban DS
New User
Joined: 07 Aug 2011
Posts: 5
Location: India
|
|
| Back to top |
|
|
satyapn9
New User
Joined: 08 Oct 2010
Posts: 27
Location: India
|
|
|
|
Hello, This might be very delayed reply to this question. But I do not see a direct/quick solution posted for this.
Yes, you can see the table details in IBM-DB2 System Catalog using below options:
1) Select a table using T option
2) Give a command "I" against the table and this brings you the details of table "DB2P Interpretation of an Object in SYSTABLES". It will have a lot more details.
Also you can query SYSIBM.SYSTABLES for this type of information. |
|
| Back to top |
|
|
Binop B
Active User
Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN
|
|
|
|
Sorry... I could't stop myself from replying to this post... Did Mr. Satya Prasad reply to his own question which he posted almost a year ago... 
This is the first time am seeing something like that...  |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
| Binop B wrote: |
Sorry... I could't stop myself from replying to this post... Did Mr. Satya Prasad reply to his own question which he posted almost a year ago...
This is the first time am seeing something like that... |
Satya did not understand his own question.
You need to read DB2 Logs, Tools like CA Log Analyzer will help you get that information.
Regards,
Sushanth |
|
| Back to top |
|
|
razesh84
New User
Joined: 05 Apr 2010
Posts: 41
Location: Kolkata,India
|
|
|
|
I once tracked some records which were accidentally created & then deleted few days after by some users.
Well I used CA Log analyser but there also I only found Plan name for Online programs.I did not find any User ids there. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Ask your DB2 administrator if SMF is activated for DB2. Record types 100,101,102. If yes, see IBM DB2 Administration Guide for these record types. |
|
| Back to top |
|
|
|
|
