Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI SQL Explorer for Db2 13.1.

Comparing DBRMLIBs and load libraries

The DBRM and load library comparison process searches for matching members and reports whether timestamp mismatches exist.

Before rolling an application out to a user community, you must ensure that your DBRMLIBs and load libraries are synchronized.

You can compare different configurations of DBRMLIBs and load libraries. This function supports composite members, which are load library members containing more than one DBRM or load library members with a different name than the DBRM.

For each DBRM data set member, the report returns one of the following possible statuses:

  • MATCH—indicates that the DBRM member is referenced in the load module and that the contokens match.
  • NO MATCH—indicates that the DBRM member is referenced in the load module, but that the contokens do not match.
  • NO REF—indicates that the DBRM member is not referenced in the load module at all.

To compare DBRMLIBs and load libraries

  1. On the SQL Explorer main menu, type 6 (for DBRM / Load Compare ) and press Enter.The DBRM / Load Compare panel is displayed (see the following figure).

    PSSPD010 -------------- DBRM / Load Compare Specification --------------------
    Command ===>                                                                  
                                                                                 
     Process Mode  . . B  (O=Online, B=Batch)                                      
                                                                                  
     DBRM Name . . . . PSS%
     Load Name . . . . PSS*
                                                                                  
     _ DBRM / Load Libraries
  2. In the Process Mode field, select the processing option for the comparison:
    • Online runs the comparison job online.
    • Batch creates JCL and runs the comparison job in batch. (default)
  3. In the DBRM Name field, specify the name of the member to be used for the DBRM.You can use wildcard characters.
  4. In the Load Name field, enter the load module name that contains the DBRM.You can use wildcard characters.

  5. Type any character in the space beside DBRM / Load Libraries to specify DBRMLIB and load library data set names for the comparison and press Enter.The DBRM / Load Compare Libraries panel is displayed (see the following figure).

    PSSPD020 ---------------- DBRM / Load Compare Libraries -----------------------
    Command ===>                                                                   
                                                                                  
    Specify libraries and press ENTER to continue.                                 
                                                                                 
    DBRM Library Data Set Name                                                     
     DBRMLIB DSN 1 . . 'AFDQA.TEST.DBRM'
     DBRMLIB DSN 2 . .                                                            
     DBRMLIB DSN 3 . .                                                            
     DBRMLIB DSN 4 . .                                                            
     DBRMLIB DSN 5 . .                                                            
     DBRMLIB DSN 6 . .                                                            
     DBRMLIB DSN 7 . .                                                            
                                                                                 
    Load Library Data Set Name                                                     
     LOADLIB DSN 1 . . 'AFDQA.TEST.LOAD'
     LOADLIB DSN 2 . .                                                            
     LOADLIB DSN 3 . .                                                            
     LOADLIB DSN 4 . .                                                            
     LOADLIB DSN 5 . .                                                            
     LOADLIB DSN 6 . .                                                            
     LOADLIB DSN 7 . .

  6. On the DBRM / Load Compare Libraries panel, complete the following fields. You can enter up to seven data sets of each type.

    Warning

    Note

    Enclose the data set name with single quotation marks. If you use double quotation marks, DBRM/Load Compare uses the exact data set name that you specify. Otherwise, DBRM/Load Compare attempts to append the data set name with the TSO prefix (if you have a prefix set) as the first node.

    1. In the DBRMLIB DSN fields, type the name of each DBRMLIB data set that you want to include.
    2. In the LOADLIB DSN fields, type the name of each load library data set that you want to include.

  7. Press Enter.Depending on the Process Mode you selected, one of the following events occurs:

    Process mode

    Event

    O (online)

    The Compare job runs in the foreground and the online report is displayed.

    B (batch)

    The Batch Job panel is displayed. For instructions, see Specifying-JCL-options-in-batch-mode.

    Warning

    Note

    If any of the data sets do not exist, the Allocate Data Set panel is displayed. For instructions, see Allocating-a-data-set-for-a-specific-job.

Related topic

Preventing-timestamp-mismatches



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI SQL Explorer for Db2 12.1