I have a problem.
I'm a beginner in db2 and urgently need to restore a backup made in the 8.2 version when I have the version 9.5.

I need your help because I have little experience and not what is the proper procedure, I have thought to uninstall 9.5 to install 8.2 and then make the restoration

Thanks for your help

Check this article to start with:
Performing a Database Backup, Restore, and Rollforward


You have to use an offline database backup

The backup on V8.2 has to be an offline backup to be able to be restore onto V9.5. If the backup is an online backup it will not work.

Andy

Thanks, I have a online backup ....
I have been advised to uninstall the version 9.5 and install version 8.2 but not exactly how to do and do not want to risk it.

You need to ask for an offline db backup if you want to restore to v9.5.

Or install v8.2 and restore your online image. With Unix/Linux, you can install multiple db2 versions on the same server. Not sure about Windows (I think this is possible starting with v9.1)

I have AIX ...
Not that such is to install two versions, as just start with db2.

I advise installing the two versions? or uninstall 9.5 and then install 8.2?
Could help me with the correct procedure?

Help !!!!!!!!

It's easier to ask for an offline image and go directly to v9.5.

If online is the only option, then you can install v8.2 and then restore. You don't need to uninstall v9.5

Thank you very much for your help,
Yes online is the only option,
I Will Seek the installation guide.
I have further questions, I think I have to create the database again right? the restoration is created exactly like I have in production? what happend with bufferpool?

You need to install v8.2 code, create an instance (if it was not created during the installation), start the instance and then do the restore.

Thanks!!!!!!!!!!!!!!!!!!!!

If I have a backup with name
MYDB.0.db2inst1.NODE0000.CATN0000.20080515213133.0 01

and I start instance db2inst8 for example, is correct this commando to restore?
db2 "restore database mydb from /data1/bkup taken at 20080515213133 to /data"

The command looks ok. You might have to do a redirected restore if the filesystems used by tablespace containers are not the same on the source and target servers.

Are you really going to use an image from 2008. You have to make sure you have the transaction logs in order to perform the rollforward.

The restoration is in process, I am not understood what to "restore the filesystems if Used by Not the tablespace containers are on the same source and target servers"

I have no logs at this time but I can restore them from tape, I think the rollfordwar can wait while we retrieve the logs?

Rollfordware is required?

Don't worry about redirected restore unless a regular restore fails.

Rollforward can wait until you retrieve the logs, but you won't be able to connect to the db until rollforward completes successfully.

db2girl, I had other problem, because I run restore and I went to get my lunch. When I saw the restore is failed!!!, I dont have folders, I don't have database. When I run db2 "LIST UTILITIES SHOW DETAIL" say me that nothing run.

and I have this errors:


2010-08-19-13.39.36.097778-360 E5470411A416 LEVEL: Error (OS)
PID : 540754 TID : 1 PROC : db2agent (instance)
INSTANCE: db2inst8 NODE : 000
APPHDL : 0-29 APPID: *LOCAL.db2inst8.100819172333
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EEXIST (17) "Do not specify an existing file."

2010-08-19-13.39.36.213112-360 E5470828A431 LEVEL: Error (OS)
PID : 540754 TID : 1 PROC : db2agent (instance)
INSTANCE: db2inst8 NODE : 000
APPHDL : 0-29 APPID: *LOCAL.db2inst8.100819172333
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "A file descriptor does not refer to an open file."



Could you help me please!!!!

What was the exact error message?


I think you really need to get help from a more senior DBA.