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.
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
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