File Report OP Instruction

Lund Consulting Services frequently uses a software tool called File Report to collect and prepare data for a Second Opinion service. File Report provides Lund's consultants with specific system performance information about a system's most frequently accessed files.

In order for us to access the system log files, Lund Consulting Services will need SM capabilities. We understand that some clients prefer not to give out SM capabilities. If this is the case we ask that you, the Client, complete the File Report for our consultants' use in preparing your Second Opinion. Please send the File Report to us as soon as possible. If, for some reason, you are unable to provide Lund Consulting Services with a complete File Report in a timely manner, the system performance data regarding most frequently accessed files will be omitted from your Second Opinion.

To log File Report data, do the following:

1. Get system manager capabilities.
2. At the MPE prompt, do a SWITCHLOG. Make a note of the logfile number.
3. Run the logging utility, SYSLOG.UTIL.LPS. For example, type: RUN SYSLOG.UTIL.LPS
4. At the Syslog: prompt type SHOW. This will give you a list of the logging options available.
5. Set the following parameters:
   :SET FILE_CLOSE or :SET 105
   :SET CM_FILE_CLOSE or :SET 160
6. Type EXIT to get back to the MPE prompt.
7. Allow the system to log for several days to a week.
8. The system log files will increase in size for the duration these items are on.

To stop logging:

1. Run the logging utility again. For example, type: RUN SYSLOG.UTIL.LPS
2. Reset the following parameters to stop logging these items in the system log files.
   :RESET FILE_CLOSE or :RESET 105
   :RESET CM_FILE_CLOSE or :RESET 160
3. Type EXIT to get back to the MPE prompt.

To create a File Report of the logged data, do the following:

1. Run the File Report program, FILERPT.UTIL.LPS for example, type: RUN FILERPT.UTIL.LPS;PARM=1000. (The PARM value is very important)
2. At the prompt, "Enter command (CR=CREATE:)" Press ENTER.
3. At the prompt, "Exclusions set:" Type ZERO if it stops and wants an answer.
4. At the prompt, "Are the log files in PUB.SYS? " Type the letter Y.
5. At the prompt, "Want a LISTF of the log files? " Type the letter Y.
6. The log file names will be displayed in numerical order without consideration of dates. For example:
   
   FILENAME
   
   LOG1259 LOG1260 LOG1261 LOG1263 LOG1264 LOG1264
   LOG1265 LOG1266 LOG1267 LOG1268 LOG1269 LOG1270
   
7. Enter the first log file number. For example, 1259.
   (From the SWITCHLOG command above.)
8. Enter the last log file number. For example, 1270.
9. At the prompt, "Enter name of new summary file (CR = SUMLOG):"
   Press the ENTER key. The program will now create a new SUMMARY LOGFILE.
10. At the prompt, "Enter command (CR = LIST): ", Press ENTER.
11. At the prompt, "Enter name of summary file (CR = SUMLOG):" Press ENTER.
12. At the prompt, "Enter sort type [1..9] (CR=1):" Press ENTER.
    
    STOP!!!
    On the Reflections window, click on FILE, then go down and click LOGGING.
    
    Select LOGGING ON
    Deselect PRINTER
    Select DISK
    
    In the box to the right of this option you will be putting in the path and name of a text file. This file will capture all of the information that will scroll across the screen from the SUMLOG output file on the host. You can call this file whatever you want. Example: C:\FILERPT.TXT
    
    Click OK - This will close the dialog box and take you back to the Reflections host window
    
13. At the prompt, "Enter cutoff percentage, or # followed by number of files to list
    (CR = 100%): " Press ENTER.
    
    The screen will now scroll and all information will be captured in
    the .TXT file on the PC.
    
14. At the prompt, "Enter command (CR = LIST ): "
    Press //. This will end the program and take you back to the MPE prompt.
15. On the Reflections window, click on FILE, then go down and click LOGGING.
    
    Deselect LOGGING ON
    Click OK - This will close the text file on the PC.
    
16. Open the .TXT file in Notepad or your favorite text editor or word processing program.
17. The file will be sorted by the number of records processed. The first host file listed will be the most heavily accessed file on your host system followed by the second and third etc.
18. The top 10 -15% of these files are the ones you want to concentrate on when using the actual DEFRAG & FRAGMENT commands in DEFRAG/X.
19. If requested by a Lund Consultant, please send the original .TXT file to us via email.

For more information please contact a customer service representative at (541) 812-7600.
To submit an email, please click here.

NOTE: You must be a registered user to access Lund Performance Solutions' support services. Lund Performance Solutions' support services are subject to Lund Performance Solutions' prices, terms, and conditions in place at the time the service is used.