View previous topic :: View next topic
|
Author |
Message |
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Hi Everyone,
I have to find out the jobs which update a particular DB2 table. For this, i am searching the production source library with the particular table name and then inside the resulted members searching for keywords like insert,update,delete.
Am i doing the right thing or do i need to do something else also to find out jobs updating that particular table. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Rather than source, I would search the DBRM's.
either way, you will overlook utilities: - load jobs
- archiving jobs which can delete
which means you need to search the appropriate parameter libraries (parm libs).
in the future, it would help if you gave a more appropriate subject for your post.
such as 'finding update programs', which topic has been discussed earlier.
suggest you look at the db2 forum and look thru previous topics,
with any luck, previous Topic Starters provided a more appropriate subject. |
|
Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Thanks Dick,
I'll follow your approach and will also give appropriate subject names in future posts. |
|
Back to top |
|
|
|