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
 

 

is the approach correct ?

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

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Mon Apr 19, 2010 9:02 pm    Post subject: is the approach correct ?
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Apr 19, 2010 9:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Mon Apr 19, 2010 9:20 pm    Post subject:
Reply with quote

Thanks Dick,

I'll follow your approach and will also give appropriate subject names in future posts.
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 Is the explanation correct? XRST,CHKP Martylin IMS DB/DC 1 Wed Mar 15, 2017 9:26 am
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts print out the correct info in LOOP? jackzhang75 CLIST & REXX 7 Wed Dec 23, 2015 10:39 pm
No new posts Introducing Commits to batch programs... Div Grad DB2 10 Tue Apr 07, 2015 7:45 pm
No new posts Need help on Best approach for IMS Ke... Kiran.Kumar IMS DB/DC 1 Tue Mar 31, 2015 6:41 am


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