Hi,
I'm working on DB2 8.2.3 on Windows. I have a databsase which need to be restored on a new database server on different system (Same configuration as mine). I want to create a new database with the back up.

I had taken a complete back up of my database and copied the folder structure to the target system in different drive (D.

The data files on my system are on C:

From the target system when I tried to issue db2 restore command from the command prompt it throws out an error
"SQL3282N The supplied credentials are not valid."

I used the command from the folder in which the back up image is present (There are 3 other images present in that back up folder)

D:\DB2BACKUP\<IMGAGE1>>db2 restore database <DB> FROM D:\DB2BACKUP\<IMGAGE1>

Where <IMAGE1> is the folder that contains the database that I did back up from my system.

I tried to perform the same operation from the Control Center its giving DN error as the above.

Can anyone give me steps to perform a restore to a new database from the back up image of the Source system from another system.

Looking for a quick reply.

Thanks
Krishna Vaddadi

Restore expects what is in the heading of the file. Do a db2ckbkup -h fn where fn is your filename of backup image to get the full path name etc. for restore. Use the resulting time,filename etc in your restore command.

Have you tried "db2 restore database <DB> user <user> using ..."?

Yes.. i tried all the possible options that db2 restore has given when requested for help..

Also I used the db2 back up check command to get the details like the time stamp and others and grabbed the same from that but it did not help me out..

Can someone throw some pointers on this..

Thanks,
Krishna Vaddadi

What was the original backup command ?

Sorry; was way off. Looking at the SQL error
SQL3282N The supplied credentials are not valid.

Explanation:

Either or both the distinguished name (DN) of the user and the
password that were specified were not valid.

This error may occur when a user is running in a Windows 2000
domain environment , which supports LDAP, and logs into a local
account which may not have sufficient authority.

User Response:

Resubmit the command using valid values for both the
distinguished name (DN) of the user and the password.

If you are working in a Windows 2000 domain environment, ensure
that logon with an account that has sufficient authority.
Talk to your admins,ldap admins and ensure you have the rights to do a restore and have access to relevant files.n_i was on the right track.