After you perform the basic downgrade steps, finish the process by handling residual tasks.
Installing system stored procedures over
the old version drops auditing information about system stored procedures. Use
the output of sp_displayaudit recorded during
predowngrade to help determine the system stored procedures for which auditing
was enabled. Reenter the audit options using sp_audit. For example, if sp_addlogin was audited in your server before upgrading, run this
command to reenable auditing on sp_addlogin:
The on-disk structures of stored procedures, triggers, and
views may contain statement identity tokens, datatypes, and object
references that are not understood by the earlier Adaptive Server
versions. You must drop all compiled objects that use features introduced
into Adaptive Server subsequent to the version to which you are
downgrading.
If during the upgrade process you ran update all statistics on syslogins, you must delete
statistics for syslogins and
re-create them.
spt_values are dropped
and re-created when you run installmaster from
the release area you downgraded to. Any new types are eliminated
from this table.
Run instmstr from the release area of the server to which you
downgraded to remove configuration parameters that belong to 15.7 SP100, by
deleting sysconfigures rows for configuration
parameters that do not exist in syscurconfigs.
After running instmstr, the error messages no longer appear when you start the
server.
If you start a downgraded server using the 15.7 SP100
configuration file, the new options generate an Unknown
parameter message. The unknown options are reported the first time
you restart the server. You can ignore these messages; the configuration file is
rewritten without the unknown options.