× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.