View previous topic :: View next topic
|
Author |
Message |
mfhelp Warnings : 1 New User
Joined: 29 Jun 2006 Posts: 33
|
|
|
|
There is a requirement of removing or stopping DB2 table maintenance jobs thus reducing CPU usage. This is because 65% legacy modernization has taken place and DB2 related stuffs are yet to be decommissioned. My understanding is that we should first have list of the dependent coponents using those tables. I already have the list of tables that need to be decommisioned. How to know precisely what all components (programs, query etc) are using those DB2 tables?
One is endevor scan of programs for the table name. Second is scanning all JCLs, PROCs and SYSIN control cards for the table name.
Is there any approach document which explains other factors that we need to consider or the sequence in which we should adopt this methodology?
Thanks in advance. |
|
Back to top |
|
|
technut
New User
Joined: 27 Dec 2007 Posts: 73 Location: India
|
|
|
|
You will be able to use the SYSIBM.* table to find the programs. For example SYSIBM.SYSTABAUTH table will list the programs accessing the tables. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
However, that list may be incomplete. . . |
|
Back to top |
|
|
|