Comparing file member data using subsetting options - assure_mimix - 10.0

You can use the CMPFILDTA command to audit your entire database over a number of days.

Before you begin, see the recommendations, restrictions, and security considerations described in Considerations for using the CMPFILDTA command. You should also read Specifying CMPFILDTA parameter values for additional information about parameters and values that you can specify.

To compare data using the subsetting options, do the following:

1. From the MIMIX Intermediate Main Menu, select option 12 (Compare, verify, and synchronize menu) and press Enter.

2. From the MIMIX Compare, Verify, and Synchronize menu, select option 7 (Compare file data) and press Enter.

3. The Compare File Data (CMPFILDTA) command appears. At the Data group definition prompts, do one of the following:

   • To compare data for all files defined by the data group file entries for a particular data group definition, specify the data group name and skip to Step 6.

   • To compare data by file name only, specify *NONE and continue with the next step.

   • To compare a subset of files defined to a data group, specify the data group name and continue with the next step.

4. At the File prompts, you can specify elements for one or more object selectors that either identify files to compare or that act as filters to the files defined to the data group indicated in Step 3. For more information, see Object selection for Compare and Synchronize commands.

   You can specify as many as 300 object selectors by using the + for more prompt for each selector. For each selector, do the following:

   1. At the File and library prompts, specify the name or the generic value you want.

   2. At the Member prompt, accept *ALL or specify a member name to compare a particular member within a file.

   3. At the Object attribute prompt, accept *ALL to compare the entire list of supported attributes or press F4 to see a valid list of attributes.

   4. At the Include or omit prompt, specify the value you want.

   5. At the System 2 file and System 2 library prompts, if the file and library names on system 2 are equal to system 1, accept the defaults. Otherwise, specify the name of the file and library to which files on the local system are compared.

      Note: The System 2 file and System 2 library values are ignored if a data group is specified on the Data group definition prompts.

   6. Press Enter.

5. The System 2 parameter prompt appears if you are comparing files not defined to a data group. If necessary, specify the name of the remote system to which files on the local system are compared.

6. At the Repair on system prompt, specify a value if you want repair action performed.

   Note: To process members in *HLDERR status, you must specify *TGT. See Step 8.

7. At the Process while active prompt, specify whether active processing technology should be used in the comparison.

   Notes:

   • To process members in *HLDERR status, you must specify *YES. See Step 8.

   • If you are comparing files associated with a data group, *DFT uses active processing. If you are comparing files not associated with a data group, *DFT does not use active processing.

   • Do not compare data using active processing technology if the apply process is 180 seconds or more behind, or has exceeded a threshold limit.

8. At the File entry status prompt, you can select files with specific statuses for compare and repair processing. Do one of the following:

   1. To process active members only, specify *ACTIVE.

   2. To process both active members and members being held due to error (*ACTIVE and *HLDERR), specify the default value *ALL.

   3. To process members being held due to error only, specify *HLDERR.

      Note: When *ALL or *HLDERR is specified for the File entry status prompt, *TGT must also be specified for the Repair on system prompt (Step 6) and *YES must be specified for the Process while active prompt (Step 7).

9. At the Subsetting option prompt, you must specify a value other than *ALL to use additional subsetting. Do one of the following:

   • To compare a fixed range of data, specify *RANGE then press Enter to see additional prompts. Skip to Step 10.

   • To define how many subsets should be established, how member data is assigned to the subsets, and which range of subsets to compare, specify *ADVANCED and press Enter to see additional prompts. Skip to Step 11.

   • To indicate that only data specified on the Records at end of file prompt is compared, specify *ENDDTA and press Enter to see additional prompts. Skip to Step 12.

10. At the Subset range prompts, do the following:

    1. At the First record prompt, specify the relative record number of the first record to compare in the range.

    2. At the Last record prompt, specify the relative record number of the last record to compare in the range.

    3. Skip to Step 12.

11. At the Advanced subset options prompts, do the following:

    1. At Number of subsets prompt, specify the number of approximately equal-sized subsets to establish. Subsets are numbered beginning with 1.

    2. At the Interleave prompt, specify the interleave factor. In most cases, the default *CALC is highly recommended.

    3. At the First subset prompt, specify the first subset in the sequence of subsets to compare.

    4. At the Last subset prompt, specify the last subset in the sequence of subsets to compare.

12. At the Records at end of file prompt, specify the number of records at the end of the member to compare. These records are compared regardless of other subsetting criteria.

    Note: If *ENDDTA is specified on the Subsetting option prompt, you must specify a value other than *NONE.

13. At the Report type prompt, do one of the following:

    • If you want all compared objects to be included in the report, accept the default.

    • If you only want objects with detected differences to be included in the report, specify *DIF.

    • If you want to include the member details and relative record number (RRN) of the first 1,000 objects that have differences, specify *RRN.

    Notes:

    • The *RRN value can only be used when *NONE is specified for the Repair on system prompt and *OUTFILE is specified for the Output prompt.

    • The *RRN value outputs to a unique outfile (MXCMPFILR). Specifying *RRN can help resolve situations where a discrepancy is known to exist but you are unsure which system contains the correct data. This value provides the information that enables you to display the specific records on the two systems and determine the system on which the file should be repaired.

14. At the Output prompt, do one of the following:

    • To generate spooled output that is printed, accept the default, *PRINT. Press Enter and continue with the next step.

    • To generate an outfile and spooled output that is printed, specify *BOTH. Press Enter and continue with the next step.

    • If you do not want to generate output, specify *NONE. Press Enter and skip to Step 19.

    • To generate an outfile, specify *OUTFILE. Press Enter and continue with the next step.

15. At the File to receive output prompts, specify the file and library to receive the output. (Press F1 (Help) to see the name of the supplied database file.)

16. At the Output member options prompts, do the following:

    1. At the Member to receive output prompt, specify the name of the database file member to receive the output of the command.

    2. At the Replace or add prompt, specify whether new records should replace existing file members or be added to the existing list.

17. At the System to receive output prompt, specify the system on which the output should be created.

    Note: If *YES is specified on the Process while active prompt and *OUTFILE was specified on the Outfile prompt, you must select *SYS2 for the System to receive output prompt.

18. At the Object difference messages prompt, specify whether you want detail messages placed in the job log. The value *INCLUDE places detail messages in the job log, and is the default used outside of shipped rules. When used as part of shipped rules, the default value is *OMIT since the results are already placed in an outfile.

19. At the Submit to batch prompt, do one of the following:

    • If you do not want to submit the job for batch processing, specify *NO and press Enter to start the comparison.

    • To submit the job for batch processing, accept the default. Press Enter continue with the next step.

20. At the Job description and Library prompts, specify the name and library of the job description used to submit the batch request.

21. At the Job name prompt, accept *CMD to use the command name to identify the job or specify a simple name.

22. To start the comparison, press Enter.