logo
Powered by QM on a Rpi server

KnowledgeBase 00047: LIST.FILES - Who Has That File Open?

Last updated: 17 Feb 2017
Applies to: All versions
Search  
Top level index       Full Index Search Tips
Previous article     Next article

This article was originally published as a Tip of the Week.

Sometimes it is useful to know which files are open and by which users. The LIST.FILES command provides this functionality.


Which Files?

With no additional options, the LIST.FILES command shows the pathnames of all files open across all QM sessions.

   Number of files open = 4. Peak = 16. Limit (NUMFILES) = 40. 
   C:\QM\VOC 
   C:\QMSYS\$IPC 
   C:\QM\BP 
   C:\QM\&SED.EXTENSIONS& 
The first line of this report shows the total number of files currently open, the peak number of files that have ever been open simultaneously, and the limit on the number of open files.

The NUMFILES configuration parameter sets a hard limit on the number of QM files open, system wide. Multiple processes opening the same file only contribute a single file to this count. The LIST.FILES command is very useful in determining whether the NUMFILES parameter should be increased. Setting it too low will result in application failures. Setting it significantly too high causes a very small performance degradation.

Using LIST.FILES with the BRIEF option shows only the first line from the default output.


Who Has Each File?

The DETAIL option extends the report to show the user numbers and user names for each QM process that has the file open.

   Number of files open = 4. Peak = 16. Limit (NUMFILES) = 40. 
   C:\QM\VOC 
    2 smithm, 7 sales 
   C:\QMSYS\$IPC 
    2 smithm, 7 sales 
   C:\QM\BP 
    7 sales 
   C:\QM\&SED.EXTENSIONS& 
    7 sales 

Adding a filename after the DETAIL keyword restricts output to the named file.


Specific User

Using the USER option restricts the report to show only the files open to the process with a specific user number. If no number follows the USER keyword, the report is for the process in which the command is executed.



Related Articles

None.



Please tell us if this article was helpful
Very     Slightly     Not at all
Comments
Email (optional)