Sample Schema Standards report (AS$RSLT)
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.
Sample Schema Standards report (AS$RSLT)
* *
* BMC AMI DEVOPS FOR DB2 *
* 13.01.00.0001.JENKINS *
* SCHEMA STANDARDS REPORT *
* *
* 02/20/2022 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:
|
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. |