Release Notes - 1.0

1.0.2-funcrel

Other Updates

Details
Fixes an issue causing DB2 specific rules to be erroneously triggered on SQL Server object types.

1.0.1-funcrel

Other Updates

Details
Added set_local.sql file to ensure that when the extension is installed the specific SQL SETs are available.

1.0.0-funcrel

Note

Moved to funcrel. No code changes have been made.

1.0.0-beta9

Other Updates

Details
Imaging Advisor - Move Oracle DB to Oracle Cloud shows Mainframe application is using Db2.

Rules

Rule Id New Rule Details
1106084 FALSE Removed false positives for CHAR datatype.
1106074 FALSE Removed false positives for SMALLINT datatype.

1.0.0-beta8

Rules

Rule Id New Rule Details
1106148 TRUE "Ensure VALUES statement is not used". The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL.
1106150 TRUE "Ensure SYSIBM.SYSDUMMY1 table is not used". The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL.
1106152 TRUE "Ensure TIMESTAMP data type is not used". The rule applies to SQL Tables / Views / Procedures / Functions / Triggers, DML script files and Embedded SQL.
1106154 TRUE "Ensure VARCHAR(n) with implicit default values is not used". The rule applies to SQL Tables.
1106156 TRUE "Ensure NUMERIC(p, s) with implicit default values is not used". The rule applies to SQL Tables.
1106158 TRUE "Ensure INTEGER with implicit default values is not used". The rule applies to SQL Tables.
1106160 TRUE "Ensure DECIMAL(p, s) with implicit default values is not used". The rule applies to SQL Tables.
1106162 TRUE "Ensure DATE with implicit default values is not used". The rule applies to SQL Tables.
1106164 TRUE "Ensure CHAR(n) with implicit default values is not used". The rule applies to SQL Tables.
1106166 TRUE "Ensure FOR BIT DATA column clause is not used". The rule applies to SQL Tables.
1106168 TRUE "Ensure FOR SBCS | MIXED DATA column clause is not used". The rule applies to SQL Tables.
1106170 TRUE "Ensure CCSID ASCII | UNICODE | EBCDIC column clause is not used". The rule applies to SQL Tables.
1106172 TRUE "Ensure CCSID num column clause is not used". The rule applies to SQL Tables.
1106174 TRUE "Ensure GENERATED AS IDENTITY is not used". The rule applies to SQL Tables.
1106176 TRUE "Ensure DB2 Built-in Function CURRENT DATE is not used". The rule applies to SQL Tables / Views / Procedures / Functions / Triggers, DML script files and Embedded SQL.

New Support

Summary Details
New advisor: Migrate DB2 to MySQL Added support for "Migrate DB2 to MySQL" advisor rules.

1.0.0-beta7

Rules

Rule Id New Rule Details
1106114 FALSE "Ensure VARBINARY data type is not used" - fixes rule scope.
1106116 FALSE "Ensure TINYINT data type is not used" - fixes rule scope.
1106118 FALSE "Ensure TIMESTAMP data type is not used" - fixes rule scope.
1106120 FALSE "Ensure SMALLMONEY data type is not used" - fixes rule scope.
1106122 FALSE "Ensure ROWVERSION data type is not used" - fixes rule scope.
1106124 FALSE "Ensure NVARCHAR data type is not used" - fixes rule scope.
1106126 FALSE "Ensure NTEXT data type is not used" - fixes rule scope.
1106128 FALSE "Ensure NCHAR data type is not used" - fixes rule scope.
1106130 FALSE "Ensure DATETIMEOFFSET data type is not used" - fixes rule scope.

1.0.0-beta6

Rules

Rule Id New Rule Details
1106102 FALSE Changed title and description.
1106108 FALSE Changed title and description.
1106114 TRUE Ensure VARBINARY data type is not used
1106116 TRUE Ensure TINYINT data type is not used
1106118 TRUE Ensure TIMESTAMP data type is not used
1106120 TRUE Ensure SMALLMONEY data type is not used
1106122 TRUE Ensure ROWVERSION data type is not used
1106126 TRUE Ensure NTEXT data type is not used
1106128 TRUE Ensure NCHAR data type is not used
1106130 TRUE Ensure DATETIMEOFFSET data type is not used
1106132 TRUE Ensure SQL server Scalar Function CONVERT is not used
1106134 TRUE Ensure SQL server Scalar Function DATEADD is not used
1106136 TRUE Ensure SQL server Scalar Function DATEDIFF is not used
1106138 TRUE Ensure SQL server Scalar Function GETDATE is not used
1106140 TRUE Ensure SQL server Scalar Function ISNULL is not used
1106142 TRUE Ensure IDENTITY Columns is not used
1106144 TRUE Ensure SQL Server SET/SELECT variable is not used
1106146 TRUE Ensure SQL Server DECLARE variable is not used

1.0.0-beta5

Rules

Rule Id New Rule Details
1106096 TRUE Ensure PARTITION is not used in ALTER TABLE statements.
1106098 TRUE Ensure CASE Expression is not used.
1106100 TRUE Ensure DECLARE cursor is not used.
1106102 TRUE Ensure DECLARE variable is not used.
1106104 TRUE Ensure SYSIBM.SYSDUMMY1 table is not used.
1106106 TRUE Ensure VALUES statement is not used.
1106108 TRUE Ensure SET variable Statement is not used.
1106110 TRUE Ensure MERGE statement is not used.
1106112 TRUE Ensure FROM keyword is used in DELETE Statement.

1.0.0-beta4

Rules

Rule Id New Rule Details
1106044 TRUE Ensure PL/SQL packages UTL_MAIL and UTL_SMTP are not used
1106046 TRUE Ensure CREATE FUNCTION is not used
1106048 TRUE Ensure CREATE PROCEDURE is not used
1106050 TRUE Ensure CREATE TRIGGER is not used
1106052 TRUE Ensure BLOB data type is not used
1106054 TRUE Ensure CLOB data type is not used
1106056 TRUE Ensure DBCLOB data type is not used
1106058 TRUE Ensure VARCHAR(n) FOR BIT DATA data type is not used
1106060 TRUE Ensure NVARCHAR data type is not used
1106062 TRUE Ensure NCHAR data type is not used
1106064 TRUE Ensure NCHAR VARYING data type is not used
1106066 TRUE Ensure GRAPHIC data type is not used
1106068 TRUE Ensure FLOAT data type is not used
1106070 TRUE Ensure DECFLOAT data type is not used
1106072 TRUE Ensure DB2 Scalar Function DATE is not used
1106074 TRUE Ensure DB2 Scalar Function SMALLINT is not used
1106076 TRUE Ensure DB2 Scalar Function LCASE is not used
1106078 TRUE Ensure DB2 Scalar Function POSSTR is not used
1106080 TRUE Ensure DB2 Scalar Function RAND is not used
1106082 TRUE Ensure DB2 Scalar Function TIMESTAMP is not used
1106084 TRUE Ensure DB2 Scalar Function CHAR is not used
1106086 TRUE Ensure DB2 Scalar Function CONCAT is not used
1106088 TRUE Ensure DB2 Scalar Function YEAR is not used
1106090 TRUE Ensure DB2 Scalar Function MONTH is not used
1106092 TRUE Ensure DB2 Scalar Functions DAY/DAYS are not used
1106094 TRUE Ensure DB2 Scalar Functions DECIMAL/DEC are not used
1106002 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106006 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106008 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106010 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106012 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106014 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106020 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106022 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106034 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106036 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106038 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106040 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106042 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"
1106044 FALSE Changed technical criteria from "Cloud Migration - Oracle Database to Amazon Aurora" to "Database Migration - Oracle Database to PostgreSQL"

1.0.0-beta3

Rules

Rule Id New Rule Details
1106038 TRUE New rule added: "Ensure Unused Column is not used".
1106040 TRUE New rule added: "Ensure READ ONLY Table is not used".
1106042 TRUE New rule added: "Ensure Invisible Index is not used".

1.0.0-beta2

Other Updates

Details
Fixed violation bookmark for objects with multiple bookmarks.

Rules

Rule Id New Rule Details
1106036 FALSE Title updated from "Ensure you don't have unsupported Database Links" to "Ensure Database Links are not used".
1106032 FALSE Title updated from "Ensure you don't have unsupported ROWID data type and pseudocolumn" to "Ensure ROWID data type is not used".
1106028 FALSE Title updated from "Ensure you don't have unsupported clause CLUSTER in CREATE TABLE statements" to "Ensure CLUSTER clause in CREATE TABLE statements is not used".
1106026 FALSE Title updated from "Ensure you don't have unsupported XMLType columns in tables" to "Ensure XMLType columns are not used".
1106022 FALSE Title updated from "Ensure you don't have unsupported option GENERATED BY DEFAULT for identity columns" to "Ensure GENERATED BY DEFAULT option for identity columns is not used".
1106018 FALSE Title updated from "Ensure you don't have unsupported PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE" to "Ensure PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE are not used".
1106016 FALSE Title updated from "Ensure you don't have unsupported PL/SQL packages UTL_HTTP and UTL_SMTP" to "Ensure PL/SQL packages UTL_HTTP and UTL_SMTP are not used".
1106014 FALSE Title updated from "Ensure you don't have unsupported PL/SQL package DBMS_AUTO_INDEX" to "Ensure PL/SQL package DBMS_AUTO_INDEX is not used".
1106012 FALSE Title updated from "Ensure you don't have unsupported PL/SQL package DBMS_OUTPUT" to "Ensure PL/SQL package DBMS_OUTPUT is not used".
1106010 FALSE Title updated from "Ensure you don't have unsupported PL/SQL package DBMS_RANDOM" to "Ensure PL/SQL package DBMS_RANDOM is not used".
1106008 FALSE Title updated from "Ensure you don't have unsupported PL/SQL package DBMS_SCHEDULER" to "Ensure PL/SQL package DBMS_SCHEDULER is not used".
1106006 FALSE Title updated from "Ensure you don't have unsupported PL/SQL package UTL_FILE" to "Ensure PL/SQL package UTL_FILE is not used".
1106002 FALSE Title updated from "Ensure you replace Oracle Merge" to "Ensure MERGE statement is not used".
1106000 FALSE Title updated from "Ensure you don't have unsupported PL/SQL packages" to "Ensure unsupported PL/SQL packages are not used".

1.0.0-beta1

Note

Initial release of the extension providing a dedicated set of quality rules that have been designed to help plan a modernization project for taking an on premise RDBMS to the Cloud (Oracle Cloud / Amazon Aurora). These quality rules are in addition to the SQL quality rules provided by the SQL Analyzer and AIP Core.

Rules

Rule Id New Rule Details
1106000 TRUE "Ensure you don't have unsupported PL/SQL packages". This rule checks if UTL_TCP, UTL_INADDR, DBMS_LDAP, DBMS_DEBUG, DBMS_DEBUG_JDWP, DBMS_DEBUG_JDWP_CUSTOM PL/SQL packages are used in Oracle Database(s).
1106002 TRUE "Ensure you replace Oracle Merge". This rule checks if the Oracle MERGE Statement is used.
1106004 TRUE "Ensure CLOB data type is not used". This rule checks the usage of CLOB Storage and the explicit conversion function TO_CLOB which converts other data types to CLOB.
1106006 TRUE "Ensure you don't have unsupported PL/SQL package UTL_FILE". This rule checks the usage of the UTL_FILE package in the Oracle Database(s).
1106008 TRUE "Ensure you don't have unsupported PL/SQL package DBMS_SCHEDULER." This rule checks the usage of the DBMS_SCHEDULER package in the Oracle Database(s).
1106010 TRUE "Ensure you don't have unsupported PL/SQL package DBMS_RANDOM". This rule checks the usage of the DBMS_RANDOM package in the Oracle Database(s).
1106012 TRUE "Ensure you don't have unsupported PL/SQL package DBMS_OUTPUT". This rule checks the usage of the DBMS_OUTPUT package in Oracle Database(s).
1106014 TRUE "Ensure you don't have unsupported PL/SQL package DBMS_AUTO_INDEX". This rule checks the usage of the DBMS_AUTO_INDEX package in Oracle Database(s).
1106016 TRUE "Ensure you don't have unsupported PL/SQL packages UTL_HTTP and UTL_SMTP". This rule checks if the UTL_HTTP or UTL_SMTP PL/SQL packages are used in Oracle Database(s).
1106018 TRUE "Ensure you don't have unsupported PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE". This rule checks if the DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE procedures are used in Oracle Database(s).
1106020 TRUE "Ensure LOB data types are not used". This rule checks the usage of LOB Storage in Oracle Database(s) and the explicit conversion functions TO_CLOB and TO_NCLOB which convert other data types to LOB data types.
1106022 TRUE "Ensure you don't have unsupported option GENERATED BY DEFAULT for identity columns". This rule checks if tables with identity columns have the GENERATED BY DEFAULT option in Oracle Database(s).
1106024 TRUE "Ensure you don't have unsupported clause SHARDED in CREATE TABLE statements". This rule checks the usage of SHARDED clause in CREATE TABLE statements for Oracle Database(s).
1106026 TRUE "Ensure you don't have unsupported XMLType columns in tables". This rule checks if any table contains XMLType columns in Oracle Database(s).
1106028 TRUE "Ensure you don't have unsupported clause CLUSTER in CREATE TABLE statements". This rule checks the usage of CLUSTER clause in the CREATE TABLE statement in Oracle Database(s).
1106030 TRUE "Ensure INDEX-ORGANIZED TABLEs (IOT) are not used". This rule checks the usage of ORGANIZATION INDEX clause in the CREATE TABLE statement in Oracle Database(s).
1106032 TRUE "Ensure you don't have unsupported ROWID data type and pseudocolumn". This rule checks the usage of ROWID data type and ROWID pseudocolumn in Oracle Database(s).
1106034 TRUE "Ensure EXTERNAL TABLEs are not used". This rule checks the usage of EXTERNAL TABLEs in Oracle Database(s).
1106036 TRUE "Ensure you don't have unsupported Database Links". This rule checks if database link objects exist or are referenced in Oracle Database(s).