467,885 Members | 1,292 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Create v8 FP4 DB from v7.2 FP4 bkup

I am wanting to create a database in UDB (WIN) v8 FP4 using a backup
from UDB (WIN) v7.2 FP4. When the restore is complete, I get a DB2
Message 'The command completed successfully.', however, when I try to
view a table in the Control Center I get a DB2 Message 'IBM CLI Driver
SQL5035N The database requires migration to the current release.'.
This migration message occurs when I restore the database into a newly
created instance in v8 or into the DB2 instance. When I issue the DB2
migrate database command, I get an error 'SQL0456N In the definition
of routine "SYSPROC.SNAPSHOT_DBM", the SPECIFIC name "SNAPSHOT_DBM"
already exists in the schema.' I have created several databases
previous to this one from a v7.2 FP4 backup on this v8 FP4 server with
no problem. I need to know how to resolve this and why this is
occurring on this database and not on the others. Thank you for any
insight and suggestions!
Nov 12 '05 #1
  • viewed: 1636
Share:
2 Replies
You could try running db2updv8 - it's a utility that adds any new
functions added in a fixpak (the functions must be recorded in the
catalogs).

R. Clausen wrote:
I am wanting to create a database in UDB (WIN) v8 FP4 using a backup
from UDB (WIN) v7.2 FP4. When the restore is complete, I get a DB2
Message 'The command completed successfully.', however, when I try to
view a table in the Control Center I get a DB2 Message 'IBM CLI Driver
SQL5035N The database requires migration to the current release.'.
This migration message occurs when I restore the database into a newly
created instance in v8 or into the DB2 instance. When I issue the DB2
migrate database command, I get an error 'SQL0456N In the definition
of routine "SYSPROC.SNAPSHOT_DBM", the SPECIFIC name "SNAPSHOT_DBM"
already exists in the schema.' I have created several databases
previous to this one from a v7.2 FP4 backup on this v8 FP4 server with
no problem. I need to know how to resolve this and why this is
occurring on this database and not on the others. Thank you for any
insight and suggestions!


Nov 12 '05 #2
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<bt**********@hanover.torolab.ibm.com>...
You could try running db2updv8 - it's a utility that adds any new
functions added in a fixpak (the functions must be recorded in the
catalogs).

R. Clausen wrote:
I am wanting to create a database in UDB (WIN) v8 FP4 using a backup
from UDB (WIN) v7.2 FP4. When the restore is complete, I get a DB2
Message 'The command completed successfully.', however, when I try to
view a table in the Control Center I get a DB2 Message 'IBM CLI Driver
SQL5035N The database requires migration to the current release.'.
This migration message occurs when I restore the database into a newly
created instance in v8 or into the DB2 instance. When I issue the DB2
migrate database command, I get an error 'SQL0456N In the definition
of routine "SYSPROC.SNAPSHOT_DBM", the SPECIFIC name "SNAPSHOT_DBM"
already exists in the schema.' I have created several databases
previous to this one from a v7.2 FP4 backup on this v8 FP4 server with
no problem. I need to know how to resolve this and why this is
occurring on this database and not on the others. Thank you for any
insight and suggestions!


Unfortunately, the db2updv8 utility did not work. First, the
deactivate command failed with the SQL5035N The database requires
migration to the current release. Second, I tried to run db2updv8
with the database in the DB2 instance and using the command--db2updv8
-d legalja, I got the error SQL1024N A database connection does not
exist. (I thought it was odd to get this error since the
documentation said that a database connection will be automatically
established.) Then when I tried to connect to the database with the
command--connect to legalja, and got SQL5035N The database requires
migration to the current release.

We are using Workgroup Server Edition. Help and suggestions welcomed!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by I_AM_DON_AND_YOU? | last post: by
10 posts views Thread by Zack Sessions | last post: by
37 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by Steven Bethard | last post: by
5 posts views Thread by Michael | last post: by
2 posts views Thread by masri999 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.