RE: Physical Files

CHGPF SIZE(*NOMAX) does require exclusive use of the file for a moment.

DSPPGMREF will identify SOME of the programs which use the file, but not all.

DSPPGMREF will not identify the following, and surely other methods of accessing a file:

- anytime a file is over-ridden using OVRDBF

- OPNQRYF use of a file

- SQL use of a file

- embedded SQL

- QUERY/400 use of a file

- and then there are the EXTERNAL file usage such as JDBC, ODBC, SQL, Excel, etc.


Hawkeye is helpful, but also doesn't see a lot of stuff.


The easiest sure-fire way to tell what touches a file: delete the file and see who calls :)







-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Therrien
Sent: Thursday, April 25, 2013 1:02 PM
To: Midrange Systems Technical Discussion
Subject: RE: Physical Files

CHGPF SIZE(*NOMAX)
This will not affect any programs.
You might not be able to do this while users have the file open (I am not certain about this).

To find out what is using a physical file you need to build a cross reference file (see DSPPGMREF command) and then query the file to determine which programs access your file.
If your physical file has logicals then you will want to know where those files are used as well.
Google DSPPGMREF for details on how to use this command and the resulting output file.


Paul

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Mathew
Sent: Thursday, April 25, 2013 12:49 PM
To: Midrange Systems Technical Discussion
Subject: Physical Files

 
I would like to change a PF file size to *NOMAX. How can I change the size.
 
and also how do I check if the physical file is used in any other programs.
 
If I change the size to *NOMAX will it impact other programs.
 
 
John
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.