Hi,

Working on v8.1.0.36 on Windows 2000 Advanced Server Version 5.0.2195 Service Pack 2.

Had installed v7.2 earlier and wanted to migrate to v8.1. Ran the 8.1 installation and during the installation ran the DB2CKMIG unitlity which I believed would take care of migration prodecures.

After installing the new version am not able to connect to or open database. Gives the following error:

[IBM][CLI Driver] SQL5035N The database requires migration to
the current release. SQLSTATE=55001

Also tried to restore the backup which was taken before the new version installation. Get the error as follows:

SQL0104N An unexpected token "PROMPTING;" was found following
"WITHOUT". Expected tokens may include: "ROLLING".

Any ideas on how I can start using my DB?

Thanks.

Hi,

DB2CKMIG only checks if a "db2 migrate db" command would presumably be successfull. You should read up on this command first.

Johann

Hi,

Thanx Johann. Any ideas on how I can start my DB? Desperate now.

See if the following infomration helps :

C:\Documents and Settings\Sathyaram>db2 ? sql5035n


SQL5035N The database requires migration to the current
release.

Explanation:

The database was created on a lower level system release. The
Migrate Database command must be used to convert the database to
the current release level.

The command cannot be processed.

User Response:

Perform the Migrate Database command before attempting to use the
database with the current system release.

If this message is received during a restore, drop the existing
database before proceeding.

sqlcode : -5035

sqlstate : 55001


C:\Documents and Settings\Sathyaram>db2 ? migrate
MIGRATE DATABASE database-alias [USER username [USING password]]

NOTE: From the operating system prompt, prefix commands with 'db2'.
Special characters MAY require an escape sequence (\), for example:
db2 \? change database
db2 ? change database xxx comment with \"text\"