Running UDB V7 FP10a and 8.1 .4 on Windows 2000.
Did full offline backups of three V7 databases. Restored two databases
to V8 instance successfully.
Third restore ended with:
SQL2517W The restored database was migrated to the current release.
Migration
returned sqlcode "1088" and tokens "C:\IBM\SQLLIB\bnd\db2schema.bnd".
SQL1088W The database was created, but an error occurred while
binding the utilities. The utilities are not bound to
the database.
Cannot connect to database so cannot bind utilities. Connect fails with;
SQL5035N The database requires migration to the current release.
Tried manual migration. Ended with:
SQL0456N In the definition of routine "SYSPROC.SNAPSHOT_DBM", the SPECIFIC
name "SNAPSHOT_DBM" already exists in the schema. LINE NUMBER=1.
SQLSTATE=42710
SQL0456N In the definition of routine "<routine-name>", the
SPECIFIC name "<specific-name>" already exists in the
schema.
Explanation:
The user has supplied an explicit SPECIFIC name
"<specific-name>" in the definition of routine
"<routine-name>", but this name already exists as the SPECIFIC
name for a function, method, or procedure in the schema.
User Response:
Choose a new SPECIFIC name and try again.
sqlcode : -456
sqlstate : 42710
Should I drop the event monitors in the V7 database before offline backup?
