Use the File Maintenance Facility to remove rows from registered Archive Files, validate or compress Archive and Extract Files, or split an Archive File into subset 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.
You can use the File Maintenance Facility to validate Archive or Extract Files, and ensure that they are intact and uncorrupted. You can control the extent of the validation that Optim uses. See File Validation Utility.
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