how many programmes are using any perticular database file in as400

310 pts.
Tags:
AS/400 database
Logical Files
RPG
RPG ILE
hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

You could try using DSPPGMREF or ANZPGM.

Regards,

Martin Gilbert.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi, Don't forget that there could always be programs that get missed by whatever method you use to look for this - for example where file names are stored in a file or data area instead of being coded in your program. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • philpl1jb
    More bad news. OVRDBF in a CL or RPG can cause the program to use a file other than the one shown on the DSPPGMREF command. Also User Open files can be redirected with the F spec keywork Extfile. The OVRDBF coupled with an OPNQRYF can make access even more difficult to identiy. Imbedded SQL commands can use files that are not identified in DSPPGMREF. Query 400 also uses logicals. Phil
    51,355 pointsBadges:
    report
  • Gilly400
    Hi, The OVRDBF can normally be picked up on the DSPPGMREF if it's hard coded, however if used in combination with data files and data areas, etc it can be much harder to find - you will probably see files referred to as something like &FILENAME, then you have to look to see where the variable is coming from. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • ten2008
    Hi, i think the DSPPGMREF displays the objects referred by a program. Hence if you want to know the programs that are using a particular file this is not directly useful. Then you need to write a CL program using the DSPPGMREF command inside the program and some processing finally to achieve the goal. Hope somebody can eloborate on this... thanks Ram
    1,150 pointsBadges:
    report
  • Gilly400
    Hi, Unless you have your database files journalled, you have to start from the program end to see which program uses which file instead of from the file end to check which file is used by which program. This is why DSPPGMREF and ANZPGM are used in this case. Since DSPPGMREF can be used to create an outputfile, you can then use query to find out which programs use a particular data file. You only need to run DSPPGMREF once across all the objects in your program library(ies) and you have all the necessary data. If you have journalling, you can check in the journals to see which programs have accessed a file, but then if you have something like a year-end procedure, you will need journals for a year or more to find all the programs that access your file. Most people don't have that sort of disk space available for journal storage. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • nirmu400
    DSPPGMREF is a good option to start with and normally we uses Hawk-eye tool. But tools are also made of similar commands.....
    55 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following