Limited supportBMC 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 DevOps for Db2 13.1.

Sample Schema Standards report (AS$RSLT)

This BMC AMI DevOps for Db2 report provides information about the schema definitions with violations. When you execute a job with Schema Standards, it generates job output to the AS$RSLT DD, also known as the Schema Standards report. The report displays:

  • Schema Standards parameters
  • Schema object violation list
  • Summary Report

You can use the Schema Standards report to:

  1. View the list of schema objects that encountered violations.
  2. Determine the corrective action and change the schema definition.
  3. Rerun the job, ensure that the violations are removed and then promote the schema definitions.

You can view this report either in the job output on the mainframe or in your workspace directory.

Sample Schema Standards report (AS$RSLT)

**********************************************************************
*                                                                    *
*                       BMC AMI DEVOPS FOR DB2                       *
*                       12.01.00.0008.JENKINS                      *
*                      SCHEMA STANDARDS REPORT                       *
*                                                                    *
*                        08/20/2021 01:18 PM                         *
*                                                                    *
**********************************************************************

**********************************************************************

Schema Standards Parameters:
  Rule set name:    $BMC SAMPLE RULE SET
  SSID/Location:    DEJM
  Schema source:    DDL
  Input DSN:        MVSJCL1.SS.INPUT(AMASAMP2)
  Debug:            TRUE
  Logmode:          FAIL


************************************************************
Database:           DBAMA
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          DB NAME
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    SUBSTR('DBAMA', 1, 3) = 'AMA'
Explanation:        Database name does not start with 'AMA'

************************************************************
Database:           DBAMA
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          DBCCSID AT CREATE
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    'ASCII' NOT IN ('ASCII','UNICODE')
Explanation:        Database is being defined with CCSID ASCII.  It should be  using a CCSID of EBCDIC.

************************************************************
Database:           DBAMA
Tablespace:         BMCIMP02
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          NEW TS MUST BE UNIVERSAL
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    ' ' IN ('G','R')
Explanation:        Tablespaces being created is not a Universal TS

************************************************************
Database:           DBAMA
Tablespace:         BMCIMP01
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          TS MAXPARTS 2 OR LARGER
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    1 >= 2
Explanation:        Partition by Growth Tablespaces need to have a MAXPARTITIONS greater than 1

************************************************************
Database:           DBAMA
Tablespace:         BMCIMP01
Part:               1
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          NEW TS PRI SEC QTY -1
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    12 = -1 AND -1 = -1
Explanation:        PRIQTY or SECQTY not set to -1 for new Tablespace

************************************************************
Table creator:      AMA
Table name:         AMA_RULESET_DEP
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          ONE TB PER TS
Message:            BMCAMA00409E - Failed to satisfy rule expression:
 ((0 = (SELECT COUNT(*) FROM SYSIBM.SYSTABLESPACE
       WHERE ('AMADB' = DBNAME AND 'BMCRDEP' = NAME)))
   OR
 (0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('AMADB' = DBNAME AND 'BMCRDEP' = NAME))))
Explanation:        Tablespaces should only contain a single Table.  Table is being placed in TS that already
                    has a Table.

************************************************************
Table creator:      AMA
Table name:         RULE_CONDITIONS
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          TB NAME RULE
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    SUBSTR('RULE_CONDITIONS', 1, 3) = 'AMA'
Explanation:        New Tables must have their name start with AMA

************************************************************
Table creator:      AMA
Table name:         RULE_CONDITIONS
Column name:        RULESET
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          VARCHAR COLS  MUST BE LEN 2 OR GREATER
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    1 >= 2
Explanation:        Table cannot be created with column defined as a VARCHAR with a length of 1

************************************************************
Index creator:      AMA
Index name:         AMAWIDIMP
Part:               0
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          NEW IX PRI SEC QTY -1
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    -1 = -1 AND 12 = -1
Explanation:        PRIQTY or SECQTY not set to -1 for new Index

************************************************************

                  Summary Report

Objects processed:                      39
  Sub-Objects processed:
    Volumes:                            0
    Columns:                            168
    Tableparts:                         12
    Indexparts:                         14
Violations encountered:                 9
Violations ignored:                     0

************************************************************

This section of the Schema Standards report provides the following information:

Schema Standards parameters

The Schema Standards parameters are inputs used to analyze Db2 schema definitions for violations in DDL, CDL, Migrate Worklist, Catalog with Outbound Migrate Profile as scope, and Catalog with Baseline Profile as scope:

Parameter name

Description

Rule set name

The name of the group of rules used in the Schema Standards analysis.

SSID/Location 

The Db2 subsystem on which the Schema Standards analysis is performed and the rule set resides.

Schema source

The schema option type to be used as input for the Schema Standards analysis:

  • DDL
  • CDL
  • Migrate Worklist
  • Catalog using Migrate Profile as scope
  • Catalog using Baseline Profile as scope 

Input DSN

The partitioned data set (PDS) name and member which contains the DDL, CDL, or Migrate Worklist that Schema Standards analyzes.

Migrate Profile

The migrate profile which contains the scope rules that identify the objects in the Db2 catalog for Schema Standards analysis.

Baseline Profile 

The baseline profile which contains the scope rules that identify the objects in the Db2 catalog for Schema Standards analysis.

Debug

The debug mode used to receive additional diagnostic information in the Schema Standards output. 

Logmode

The violation log result of the rule violation for Schema Standards analysis.

Change rules

The migrate profile which contains the change rules to be applied after the objects are read for Schema Standards analysis. This is an optional parameter.

Schema object violation list

Object violation

Description

Object

The name of the schema object evaluated in Schema Standards which received a violation or error.

Rule set name

The name of the group of rules used in Schema Standards analysis.

Rule name

The name of the rule that generated the violation.

Message

The rule violation message text.

Explanation

The rule violation explanation text.

Rule expression

The rule expression SQL text. This will only display when there is a host-variable mismatch or SQL error.

When condition

The rule’s when condition SQL text. This will only display when there is a host-variable mismatch or SQL error.

Violation ignored

The violation ignored message text. 

Summary Report

The Summary Report provides information about the counts for the Db2 schema definitions.

Type

Description

Objects processed

The total number of parent objects processed in Schema Standards analysis.

Sub-Objects processed (by object type)

The total number of child objects processed in Schema Standards analysis. This will only display with Debug = True.

Violations encountered

The total number of violations.

Violations ignored

The total number of violations that were previously ignored.


Related topic

Command-and-syntax-reference

 

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