Hello, I am trying to migrate from MaxDB 7.5.0.8 to MaxDB 7.6.00.16. The first server is Red Hat Linux 9, the other is SUSE 10. I made a migration backup, and then restored it on the other server with 'db_activate RECOVER'. Everything went just fine, but I miss my OPTIMIZERSTATISTICS table. I tried to create it by executing 'sql_execute update stat myuser.mytable', but that failed as well. Are there any additional steps required before/after "db_activate RECOVER" when migrating from one server to another? Should I somehow recreate system tables on the new server?
Thanks, John ./dbmcli on mydatabase>sql_execute update stat myuser.mytable ERR -24988,ERR_SQL: Sql error 0,(no error text available from database kernel) 10,Storing of updated statistics for table 0000000000000b74 failed, error: System error: AK Catalog information not found knldiag complains about: 2006-03-30 19:39:17 24 WNG 8 SQLMan Insert into SYSUPDSTATLOG failed for table 0000000000000b74; ignoring 5 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
