Maintaining and Using a Subset › Check Object Consistency Before Transformation or Code Generation › Subset Consistency Check Procedure

Subset Consistency Check Procedure

1. From the main menu, select Host Encyclopedia Functions, Subset Management, Check Subset for Consistency or enter 1.4.8.

                       Check Subset for Consistency                               
                                                                                  
                 Model Name      ___________________ +                            
                 Subset Name     ___________________ +                            
                                                                                  
                 Report scope All objects / Selected objects                      
                 Execution mode Online / Batch                                    
   
   

2. Enter the Host Encyclopedia name of the model.

   To use the model name selection list instead, tab to the model name and press F4.

   Note: You can scroll or use F (Find) or L (Locate) commands on all selection lists. Enter any character except period (.) by the item you want and press Enter.

3. Enter the subset name and press Enter, or tab to the subset name and press F4 to use the subset selection list.
4. Select a scope for your report:
   • All objects
   • Selected objects
5. Use a slash ( / ) to select execution mode:
   • Online
   • Batch

   Press Enter. Other report options appear:

                       Consistency Check Report Options                           
                                                                                  
                       Diagnostic report type                                     
                       Diagnostic severity                                        
                       Diagnostic threshold                                       
                       Diagnostic rule level                                      
                       DBMS specific rules                                        
   
   

6. Specify the type of report (amount of detail):
   • N (Normal)
   • D (Detailed)
   • S (Summary)
7. Specify severity.
   • W (Warnings and errors)
   • S (Severity of warnings)
   • E (Errors only)
   • F (Fatal errors)
8. Specify diagnostic threshold, the number of messages at which to stop checking. Valid range is 1-9999. The default value is 100.

   If the consistency check produces the number of messages you specify, it stops and the Consistency Check Threshold Processing screen appears and asks you whether to continue.

9. Specify the diagnostic rule level.
   • ALL (All rules)
   • ISP (Rules for Planning stage only)
   • BAA (Rules for Analysis stage only)
   • BSD (Rules for Design stage only)
   • TD (Rules for database design only)
   • CG (Rules for code generation only)
10. Specify the DBMS-specific rule level.
    • ALL (All DBMS rules)
    • NONE (No DBMS-specific rules)
    • DB2UDB (DBMS rules specific to DB2 UDB only)
    • DB2ZOS (DBMS rules specific to DB2 for zOS only)
    • JDBC (DBMS rules specific to JDBC only)
    • MSSQL (DBMS rules specific to SQL Server only)
    • ODBC (DBMS rules specific to ODBC only)
    • ORACLE (DBMS rules specific to Oracle only)
11. Press Enter.
    • If generating online report and checking all objects, the Consistency Check Diagnostic Report appears.
    • If generating online report and checking selected objects, the Confirm Consistency Check List screen appears. It contains a list of all the objects in the subset.
12. Enter a forward slash ( / ) next to objects to remove them from the consistency check. Press Enter. A confirmation screen appears.
13. Press Enter to process, or enter CANCEL and press Enter to cancel.

    If generating batch report and checking all objects, an editable stream of JCL appears.

14. Edit JCL as needed.
15. Enter SUBMIT or SUB and press Enter.

    The batch job is submitted for execution.

    If generating a batch report and checking selected objects, the Confirm Consistency Check List screen appears. It contains a list of all the objects in the subset.

16. Enter a forward slash ( / ) next to objects to remove them from the consistency check. Press Enter. A confirmation screen appears.
17. Press Enter to process, or enter CANCEL and press Enter to cancel. An editable stream of JCL appears.
18. Edit JCL as needed.
19. Enter SUBMIT or SUB and press Enter. The batch job is submitted for execution.