DB2 v8.2-to-v9.1 data migration problems 1

[SantaMufasa]

We currently have a running DB2 v8.2 database instance. We have successfully installed (on the same machine, different path) the DB2 v9.1 software.

I have successfully run the "db2icrt" command.

We have database backup files from the v8.2 db instance. We want to restore them onto the new instance.

I infer from the DB2 on-line documentation that:

1) we can use the "db2 restore database..." command to populate the new instance with data from the old-instance database backup files:

This utility can also overwrite a database with a different image or restore the backup copy to a new database.

2) if the database does not exist on the target instance, the "...restore database..." command can create it:

"INTO target-database-alias"...If the target database does not exist, it is created. When you restore a database backup to a nonexistent database, the new database is created with the alias and database name that you specify.

Here is my invocation and the accompanying error message that results:

$ db2 restore db TFPTDEV from /dbsrv/dumpfiles/db2/backup/db2v82/20070529/db2v82.TFPTDEV.backup taken at 20070529021729 into TFPTDEV without rolling forward

SQL2036N  The path for the file or device
"/dbsrv/dumpfiles/db2/backup/db2v82/20070529/db2v82.TFPTDEV.backup" is not valid.

Is this error saying that their is something wrong with the specification of the source backup file? If so, following is an "ls -l" of the file (showing permissions) and an "id" that shows that I (logged in as db2v91) own the file:

ls -l /dbsrv/dumpfiles/db2/backup/db2v82/20070529/db2v82.TFPTDEV.backup
-rw-rw-r--   1 db2v91   dbadm    27164672 May 29 02:17 /dbsrv/dumpfiles/db2/backup/db2v82/20070529/db2v82.TFPTDEV.backup
$ id uid=10133(db2v91) gid=237(dbadm)

I am really spinning my wheels on this problem. The db customer wanted his old data available on the new installation by CoB today.

Can anyone help me? If not, do you have any suggestions of someone DB2-proficient (no matter where they are located) whom I could contact for some help to get me past this problem? (Our IBM DB2 tech support is via e-mail only and their turnaround for help is way too long.)



Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[blom0344]

This is probably a long shot, but I recall a test where we tried to take a version 7 backup to create a version 8 database. This is some years ago, but I think that the backup file was not recognized as a valid one untill we created the exact same path on the new server as the path on the old server. But I guess you got that covered?

Ties Blom

 

[Truusvlugindewind]

You want to keep the 'old' V8 database right? Why else should you restore when you can re-catalog the existing database.

read those:

http://www.ibm.com/developerworks/db2/library/techarticle/0211melnyk/0211melnyk.html

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0006254.htm

which describes a restore with "redirect" option.

 

[SantaMufasa]

Truusvlugindewind,

Your suggestions and links are excellent! They resulted in successful migration of my databases from 8.2 to 9.1.

Have a

for your very helpful post!

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]