Home > IT Answers > AS/400 > Impact Analysis – None Answered till now
Kumari
0 pts.
 Impact Analysis – None Answered till now
AS/400, Database, DB2 Universal Database, RPG
Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that. Doubt:I'll just input the file name,It should search from the Library List and should display all the programs, that file is being used. Actually it should search for the file that i have inputed and if it has any dependent files, then taking those dependent files also it should search and should display all the programs. I dont want to use DSPPGMREF because then i have to check for every program whether that file is present or not.This would be again time consuming. I also dont want to use FNDSTRPDM, as we may not know how many Source Physical Files are present for each library.Also this would be again time consuming. If it is possible through an API also its fine. If any one knows about this please respond.It would of great help if you do so.Thanks in advance................ My Mail id : srikanth.karedla@wipro.com

Software/Hardware used:
ASKED: October 27, 2005  2:58 AM
UPDATED: November 30, 2010  8:17 AM
RELATED QUESTIONS
Answer Wiki:
We use Pathfinder from Hawkeye Information systems to do the research you just described. Not only does it find every query and program that use the file but it also builds a mass compile list for you to recompile the programs that are affected by the file change.
Last Wiki Answer Submitted:  October 27, 2005  7:21 am  by  Ddune3566   0 pts.
All Answer Wiki Contributors:  Ddune3566   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please explain why you don’t want to use DSPPGMREF. You won’t get more information that’s useful to you from an API and it’ll be easier (for you) processing the file from DSPPGMREF than output from an API.

Even so, that part will only take 1-2% of the entire project time because it’s so easy relative to the rest. You’ve already put more time into thinking about it than it would take to actually do it. And the rest is far more difficult.

Just use DSPPGMREF and get on to the hard stuff.

Tom

TomLiotta
 108,055 pts.
 

DSPPGMREF is a good option to start with and normally we uses Hawk-eye tool. But tools are also made of similar commands…..

nirmu400
 55 pts.
 

I have an impact analysis utility availiable for free to the public and it has been in use for years. It builds a metafile and displays file usage (PF,LF,DSPF and PRTF) instantly. Can send it to you in a downloaded savefile.

reg
 280 pts.
 

Tom has the right of it.

I’ve used the following a number of times:

DSPPGMREF  PGM(*ALL/*ALL) OUTPUT(*OUTFILE) OBJTYPE(*ALL) OUTFILE(library/file)

Scanning the resulting outfile is easy using just RUNQRY. I don’t see what’s ‘time consuming’ about that, especially compared to writing your own utility to accomplish the same result.

Splat
 5,670 pts.
 

DSPPGMREF doesn’t catch SQL uses of the file or External Data Structures.
Important? sometimes.
Phil

philpl1jb
 44,160 pts.
 

DSPPGMREF doesn’t catch SQL uses of the file…

Since at least V5R3, it does. I don’t know when it started, but it was apparently quite a few years ago.

I’d guess that the external DS wouldn’t be caught because the program doesn’t actually reference the object — the compiler just copies the field definitions.

Tom

TomLiotta
 108,055 pts.