Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Migration SapDB 7.3 to MaxDB 7.6 doubts and problems

Migration SapDB 7.3 to MaxDB 7.6 doubts and problems

2007-07-17       - By Cl?vis Wichoski

 Back
Reply:     1     2     3  

Hi,

I migrated from SapDB 7.3 version to MaxDB 7.6.2.10 using the follow
process:

commands on dbmcli for version SapDB 7.3:

db_offline
db_cold
util_execute migrate
util_connect
backup_start completeF
db_offline

after copy the compleF media to MaxDB 7.6.2.10 directory and run the follow
commands on dbmcli in this new version:

db_admin
util_execute migrate database
db_connect
db_activate RECOVER completeF
db_online
load_systab -u dba,pwd
sql_recreateindex
util_connect
backup_start completeF
db_offline
db_warm

with these commands i can migrate from 7.3 to 7.6.2.10 all data are in the
new database, but some problems occurs like:

[-9205]: System error: AK Catalog information not
found:000000000000000000690001

that occurs when i update one table that uses triggers on old versions, in
mail lists i found the solution for this problem on the message
http://lists.mysql.com/maxdb/28223 that in resume says:

RENAME T TO SUSPENDED
CREATE TABLE T LIKE SUSPENDED
INSERT INTO T SELECT * FROM SUSPENDED
DELETE SUSPENDED (if possible)
recreate all views, synonyms, triggers etc. based on T


but, this is a uggly solution and dont a better approach i like to migrate
without get any errors of that kind, then the doubt is, there is a another
way to migrate without getting this errors? exists any sample using repmcli
(SapDB 7.3) and loadercli (MaxDB 7.6) ?

thanks for any help.

Cl?vis