MXCMPFILD outfile (CMPFILDTA command) - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2023
First publish date
1999
ft:lastEdition
2024-05-07
ft:lastPublication
2024-05-07T13:36:02.962500

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.

Compare File Data (CMPFILDTA) output file (MXCMPFILD)

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)

What differences were detected by #FILDTA

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