Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Hyderabad, India
    Posts
    14

    Question Unanswered: Issues with DB2 Restore

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Have you tried "db2 restore database <DB> user <user> using ..."?

  4. #4
    Join Date
    Oct 2003
    Location
    Hyderabad, India
    Posts
    14

    Question

    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

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    What was the original backup command ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •