File Maintenance Facility

Use the File Maintenance Facility to remove rows from registered Archive Files and compress Archive and Extract Files, using parameters you provide in a command file.

The File Maintenance Facility reads the command file and generates “process objects” that correspond to the process blocks in the command file. The File Maintenance Facility either updates the processed file or creates a new copy of the file.

The File Maintenance Facility generates two types of output: progress messages that go to the console and a report file (if the OUTPUT= command is specified). See the following examples.

Progress Messages

D:\RtWin\730\Source\DebugUni>pr0cmnd /fmf @FMFRef1.txt output=FMFout.txt
Reading command file C:\ExtractFiles\FMFRef1.txt...
Preparing processes...
        1 of 1
Running process 1 of 1...
        Process: remove rows from files
        1 of 1: File C:\ExtractFiles\DDLtest640.AF on server (Local)
                Start Time:     8/6/2010 17:09:46
                Finding rows...
                Removing rows...
                No index file to update
                Process completed successfully.
                End Time:       8/6/2010 17:09:55

Output Report

File Maintenance Facility Process Report


Command Line Parameters     @FMFRef1.txt output=FMFout.txt
Client User ID              edg
Time Started                8/6/2010 17:09:46
Time Finished               8/6/2010 17:09:55
Elapsed Time                00:00:09
Process Status              no errors, no warnings

Process Summary:
   Files processed          1
   Index files processed    0

Process 1 of 1
------- - -- -

   Process Commands:
   1)    PSTDIR UNI_ORA92 
   2)    AF (local)    %DDLtest640.AF
   3)    SELCRIT UNI_ORA_92.EDG.CUSTOMERS STATE='NY'
   4)    RETAINORIGINAL YES
   5)    RUN REMOVEROWS

File 1 of 1 for process 1 of 1
---- - -- - --- ------- - -- -

Server Name                 (Local)
Archive File                C:\ExtractFiles\DDLtest640.AF
Subset Extract File         C:\ExtractFiles\DDLtest640.AF.sub00002.xf
New Archive File            C:\ExtractFiles\DDLtest640.AF.fmf_remove00001.af
Archive Index File          (None)
New Archive Index File      (None)
Time Started                8/6/2010 17:09:46
Time Finished               8/6/2010 17:09:55
Elapsed Time                00:00:09
Process Status              no errors, no warnings

Process Summary:
   Tables Processed         5
   Archive File Rows        6133
   New Archive File Rows    668

Row Details:
   Archive File  New Archive File    Table Name
   ------- ----  --- ------- ----    ----- ----
          22             0           UNI_ORA_92.EDG.SALES
         704           668           UNI_ORA_92.EDG.CUSTOMERS
        3596             0           UNI_ORA_92.EDG.DETAILS
        1709             0           UNI_ORA_92.EDG.ORDERS
         102             0           UNI_ORA_92.EDG.ITEMS