Home | Previous Page | Next Page   Migration to a Later Version of a Database Server > Reverting from Dynamic Server 10.0 > Reverting from Dynamic Server 10.0 to Versions 9.40, 9.30, 9.2x, 7.3x, or 7.24 >

Update Statistics

After a successful reversion, you need to run UPDATE STATISTICS on some of the system catalog tables in your databases when the database server starts.

For reversion to a 7.3x or 7.24 database server from Dynamic Server 10.0 run UPDATE STATISTICS on the following system catalog tables in the 7.3x or 7.24 database server:

SYSBLOBS
SYSCOLAUTH
SYSCOLUMNS
SYSCONSTRAINTS
SYSDEFAULTS
SYSDISTRIB
SYSFRAGAUTH

SYSFRAGMENTS
SYSINDEXES
SYSOBJSTATE
SYSOPCLSTR
SYSPROCAUTH
SYSPROCEDURES
SYSROLEAUTH

SYSSYNONYMS
SYSSYNTABLE
SYSTABAUTH
SYSTABLES
SYSTRIGGERS
SYSUSERS
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]