Sample Schema Standards report (AS$RSLT)

Related topics

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:

View the list of schema objects that encountered violations.
Determine the corrective action and change the schema definition.
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.

Click here to view Sample Schema Standards report (AS$RSLT)

**********************************************************************
*                                                                    *
*                       BMC AMI DEVOPS FOR DB2                       *
*                      13.01.00.0005.05.JENKINS                      *
*                      SCHEMA STANDARDS REPORT                       *
*                                                                    *
*                        07/08/2025 02:21 PM                         *
*                                                                    *
**********************************************************************

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

Schema Standards Parameters:
  Rule set name:    $BMC SAMPLE RULE SET
  SSID/Location:    DEJM
  Schema source:    DDL
  Input DSN:        DB2QA.INST1310.BMCCNTL(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 DBAMA 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.

************************************************************
LOB Database:       DBAMA
LOB Tablespace:     LUXICHKR
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          LOB TS NAME
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    SUBSTR('LUXICHKR', 1, 3) = SUBSTR('AMA_VIOLATIONS_SQLTEXT', 1, 3)
Explanation:        First 3 bytes of LOB TS Name must match the first 3 bytes of the Base Table name

************************************************************
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_VIOLATIONS_TO_IGNORE
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 ('DBAMA' = DBNAME AND 'BMCVTI' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCVTI' = NAME))))
Explanation:        Tablespaces should only contain a single Table. Table is being placed in TS that already
                    has a Table.

************************************************************
Aux Table creator: AMA
Aux Table name:     AMAVISQLTEUXIC8QUC
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          AUX TABLE NAME
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    SUBSTR('AMAVISQLTEUXIC8QUC', 1, 5) = SUBSTR('SQLTEXT', 1, 5)
Explanation:        First 5 bytes of Aux Table must contain first 5 bytes of LOB Column

************************************************************
Table creator:      AMA
Table name:         AMA_VIOLATIONS_SQLTEXT
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 ('DBAMA' = DBNAME AND 'BMCVST' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCVST' = 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:         AMA_VIOLATIONS_LOG
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 ('DBAMA' = DBNAME AND 'BMCVL' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCVL' = 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:         AMA_RULESET_VARS
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 ('DBAMA' = DBNAME AND 'BMCRVARS' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRVARS' = 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:         AMA_RULES
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 ('DBAMA' = DBNAME AND 'BMCRULES' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRULES' = 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:         AMA_RULESETS
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 ('DBAMA' = DBNAME AND 'BMCRSET' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRSET' = 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:         AMA_RULE_PICK_VAL
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 ('DBAMA' = DBNAME AND 'BMCRPVAL' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRPVAL' = 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:         AMA_RULE_PICK_LIST
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 ('DBAMA' = DBNAME AND 'BMCRPLST' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRPLST' = 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:         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:          ONE TB PER TS
Message:            BMCAMA00409E - Failed to satisfy rule expression:
((0 = (SELECT COUNT(*) FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRCOND' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCRCOND' = 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

************************************************************
Table creator:      AMA
Table name:         AMA_WORKID_IMPACT_OBJ
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 ('DBAMA' = DBNAME AND 'BMCIMP02' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCIMP02' = 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:         AMA_WORKID_IMPACT
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 ('DBAMA' = DBNAME AND 'BMCIMP01' = NAME)))
   OR
(0 = (SELECT NTABLES FROM SYSIBM.SYSTABLESPACE
       WHERE ('DBAMA' = DBNAME AND 'BMCIMP01' = NAME))))
Explanation:        Tablespaces should only contain a single Table. Table is being placed in TS that already
                    has a Table.

************************************************************
Aux Index creator: AMA
Aux Index name:     IAMAVISQLTEUXICAH1
Rule set name:      $BMC SAMPLE RULE SET
Rule name:          AUX INDEX BP
Message:            BMCAMA00409E - Failed to satisfy rule expression:
                    'BP0' = 'BP4'
Explanation:        The Index must use BP4

************************************************************
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:                      42
  Sub-Objects processed:
    Volumes:                            0
    Columns:                            168
    View Columns:                       0
    Tableparts:                         12
    LOB Tableparts:                     1
    Indexparts:                         14
    Auxiliary Indexparts:               1
    Impact Utilities:                   0
Violations encountered:                 23
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 (BMC.DB2.SPE2510)Impact Report using Work ID
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.
Work ID	(BMC.DB2.SPE2510) The alter-type Work ID, from BMC AMI Change Manager, that contains impact report information 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. Warning Important Change rules are not applicable with Impact Report using Work ID.

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.

Sample Schema Standards report (AS$RSLT)

Schema Standards parameters

Schema object violation list

Summary Report

BMC AMI DevOps for Db2 13.1

On this page