It is recommended that the CMPFILDTA command be used in tandem with the CMPFILA command. Use the CMPFILA command to determine whether you have a matching set of files and attributes on both systems and use the CMPFILDTA command to compare the actual data within the files.
Files with LOBs - When comparing files with LOBs, you must specify a data group when the CMPFILDTA request specifies a value other than *NONE for REPAIR.
Files with permissions or masks - When the CMPFILDTA command is invoked from a command line or by a program other than MIMIX and a file to be compared is protected by permissions or masks, be aware of the following:
-
If you specify a data group, or if the file to be compared is identified to MIMIX by a data group file entry, the command temporarily changes the user profile of the job to the MIMIXOWN user profile while processing the file. The user profile of the job is changed back to its original value before the job ends.
-
If you do not specify a data group and the file to be compared is not identified by a data group file entry, the command will fail.
Temporal tables and history tables with a versioned relationship - When the CMPFILDTA command is invoked from a command line or by a program other than MIMIX and a file to be compared is a system-period temporal table or a history table for which a versioned relationship exists, be aware of the following:
-
If you specify a data group, or if the file to be compared is identified to MIMIX by a data group file entry, the command temporarily changes the user profile of the job to the MIMIXOWN user profile while processing the file. The user profile of the job is changed back to its original value before the job ends.
-
If you do not specify a data group and the file to be compared is not identified by a data group file entry, the command will fail.
Keyed replication - Although you can run the CMPFILDTA command on keyed files, the command only supports files configured for *POSITIONAL replication. The CMPFILDTA command cannot compare files configured for *KEYED replication.
Apply threshold and apply backlog - Do not compare data using active processing technology if the apply process is 180 seconds or more behind, or has exceeded a threshold limit.