For additional information for interpreting this outfile, see Interpreting results of audits for record counts and file data.
The following fields require additional explanation:
Major mismatches before - Indicates the number of mismatched records found. A value other than 0 (zero) indicates that there are either missing records or data within records does not match.
Major mismatches after - Indicates the number of mismatched records remaining. If repair was requested, this value should be 0 (zero); otherwise, the value should equal that shown in the Major mismatches before column.
Minor mismatches after - Indicates the number of differences remaining that do not affect data integrity.
Apply pending - Indicates the number of records for which the database apply process has not yet performed repair processing.
|
Field |
Description |
Type, length |
Valid values |
Column headings |
|---|---|---|---|---|
|
TIMESTAMP |
Timestamp (YYYY-MM-DD.HH.MM.SSmmmmmm) |
TIMESTAMP |
SAA timestamp |
TIMESTAMP |
|
COMMAND |
Command name |
CHAR(10) |
“CMPFILDTA” |
COMMAND NAME |
|
DGSHRTNM |
Data group short name |
CHAR(3) |
Short data group name |
DGDFN SHORT NAME |
|
DGNAME |
Data group definition name |
CHAR(10) |
User-defined data group name * blank if not DG specified on the command |
DGDFN NAME |
|
SYSTEM1 |
System 1 |
CHAR(8) |
User-defined system name *local system name if no DG specified |
SYSTEM 1 |
|
SYSTEM2 |
System 2 |
CHAR(8) |
User-defined system name *remote system name if no DG specified |
SYSTEM 2 |
|
DTASRC |
Data source |
CHAR(10) |
*SYS1, *SYS2 |
DATA SOURCE |
|
SYS1OBJ |
System 1 object name |
CHAR(10) |
User-defined name |
SYSTEM 1 OBJECT |
|
SYS1LIB |
System 1 library name |
CHAR(10) |
User-defined name |
SYSTEM 1 LIBRARY |
|
MBR |
Member name |
CHAR(10) |
User-defined name |
MEMBER |
|
SYS2OBJ |
System 2 object name |
CHAR(10) |
User-defined name |
SYSTEM 2 OBJECT |
|
SYS2LIB |
System 2 library name |
CHAR(10) |
User-defined name |
SYSTEM 2 LIBRARY |
|
OBJTYPE |
Object type |
CHAR(10) |
*FILE |
OBJECT TYPE |
|
DIFIND |
Differences indicator |
CHAR(10) |
DIFFERENCE INDICATOR |
|
|
REPAIRSYS |
Repair system |
CHAR(10) |
*SYS1, *SYS2 |
REPAIR SYSTEM |
|
FILEREP |
File repair successful |
CHAR(10) |
Blank, *YES, *NO |
FILE REPAIR SUCCESSFUL |
|
TOTRCDS |
Total records compared |
DECIMAL(20) |
0 - 99999999999999999999 |
TOTAL RECORDS COMPARED |
|
MAJMISMBEF |
Major mismatches before processing |
DECIMAL(20) |
0 - 99999999999999999999 |
MAJOR MISMATCHES BEFORE PROCESSING |
|
MAJMISMAFT |
Major mismatches after processing |
DECIMAL(20) |
0 - 99999999999999999999 |
MAJOR MISMATCHES AFTER PROCESSING |
|
MINMISMAFT |
Minor mismatches after processing |
DECIMAL(20) |
0 - 99999999999999999999 |
MINOR MISMATCHES AFTER PROCESSING |
|
APYPENDING |
Apply pending records |
DECIMAL(20) |
0 - 99999999999999999999 |
ACTIVE RECORDS PENDING |
|
ASPDEV1 |
System 1 ASP device |
CHAR(10) |
*NONE, User-defined name |
SYSTEM 1 ASPDEVICE |
|
ASPDEV2 |
System 2 ASP device |
CHAR(10) |
*NONE, User-defined name |
SYSTEM 2 ASPDEVICE |
|
TMPSQLVIEW |
Temporary target system SQL view pathname |
CHAR(33) |
IBM i-format path name or blanks |
TEMPORARY TARGET SQL VIEW |
|
RCDSINMBR |
Number of records in member |
DECIMAL (20) |
0 - 99999999999999999999 |
RECORDS IN MEMBER |