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!