Unanswered: restoring database from a different schema
i have been given backup image of a database which was created using username/password user1/pass1. now my database username is different (user2/pass2) and i cant seem to be able to restore the database image sent to me because i keep on getting the error that the supplied username and password is incorrect.
my assumption is that the supplied password in the statement
restore database testdata user user2 using pass2 from c:\temp\testdata with 3 buffers buffer 1024 without prompting
is being used to 1) open the image, and 2 ) used for logging to the current instance (my system username and schema name are different).
we have a big problem!
From a DB does'n exist any backup. We have only the DAT.*, NAM.*, INX.*, *.LB and *.LBA files without their right paths for the data structure (only SMS tablespaces , OS=Win2000 Server).
How can I restore the tables from the DAT tables? Do you know a tool which can read DAT files?
Certainly, the second and third statements have invalid credentials.
For the first command, unless you supply the full command, there is no way for anyone to know what the invalud credentials are.
BTW, IBM has compiled information about DB2 and published them. They are popularly known as manuals ... These pages may tell you what the valid credentials are ... Refer 'Useful DB2 Stuff' thread for the link to the manuals
Visit the new-look IDUG Website , register to gain access to the excellent content.