To collect deprecated rules
Before you begin, confirm that the required migration scripts are installed in the
/tools/migration/ddl
directory in your
Optimize
installation.
1.
Locate the migration script files in the
/tools/migration/ddl
directory in your
Optimize
installation.
2.
Run the following script on your database to create a list of deprecated rules.
aco_show_invalid_rules.sql
This script creates a row for every deprecated rule. After you complete the list, for each rule in the obsolete version of
Optimize
, record all pertinent information that you will need to recreate the rule in the new version of
Optimize
.
Copyright IBM Corporation 2012. All Rights Reserved.