469,645 Members | 1,634 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

SQL1088W - V7 to V8 database migration failure.


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?

Nov 12 '05 #1
0 2664

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by democratix | last post: by
1 post views Thread by Henry Reardon | last post: by
1 post views Thread by greg.scharlemann | last post: by
reply views Thread by Rodolfo | last post: by
21 posts views Thread by nihad.nasim | last post: by
2 posts views Thread by Alex | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.