Release Notes - 1.0
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). |