Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Impacted DB2 Modules

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

New User


Joined: 14 Nov 2008
Posts: 6
Location: Bangalore

PostPosted: Tue Dec 08, 2009 11:27 pm    Post subject: Impacted DB2 Modules
Reply with quote

If DB2 table gets altered ,how to identify the impacted programs through packages or plans?
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Dec 08, 2009 11:37 pm    Post subject:
Reply with quote

Quote:
how to identify the impacted programs through packages or plans?


by looking at the sysibm.sysplans (spelling) and .syspackages tables.

but, you have to know the package/plan names.

there are other threads in the forum (last month or so) that discussed this very topic and there were some very good suggestions made as how to determine which modules are impacted by an alter of a DB2 table.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Dec 09, 2009 10:46 am    Post subject:
Reply with quote

.systabauth will give you all the plans and packages that are using a particular table. That should be a good starting point.
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 Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts How to find possible traces of ARCH 7... Prosenjit2011 All Other Mainframe Topics 5 Mon Aug 17, 2015 10:53 am
No new posts COBOL Update to 5.1, recompile all mo... vickey_dw COBOL Programming 1 Thu Jun 18, 2015 10:45 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us