Update statistics on some system catalog tables after migrating

After migrating successfully to HCL OneDB™ Version 2.0.0.0, run UPDATE STATISTICS on some of the system catalog tables in your databases.

If you are migration from a Version 7.31 or 7.24 database server or moving data from that version to the current version, be sure to run UPDATE STATISTICS on the following system catalog tables in HCL OneDB Version 2.0.0.0:

sysblobs system catalog table
syscolauth system catalog table
syscolumns system catalog table
sysconstraints system catalog table
sysdefaults system catalog table
sysdistrib system catalog table
sysfragauth system catalog table
sysfragments system catalog table
sysindices system catalog table
sysobjstate system catalog table
sysopclstr system catalog table
sysprocauth system catalog table
sysproceduressysroleauth system catalog table
syssynonyms system catalog table
syssyntable system catalog table
systabauth system catalog table
systables system catalog table
systriggers system catalog table
sysusers system catalog table

Because you cannot migrate directly from a Version 7.31 or 7.24 database server to Version 2.0.0.0, use the dbexport and dbimport utilities or distributed SQL to move your data into the new database server.