By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

Redirected Restore From one server to another Issue, db2advis error.

P: n/a
When a backup is taken from server a and then redirected restore is
done on server b, the tables and data is fine however db2advis says
"explain & advise tables not created for user x properly". However user
x has access read, insert, delete rights to the advise & explain tables
as well the tablespace where tables exist. I am perplexed and for some
reason think it has something to do with the redirected restore am I
correct. Any replys much appreciated!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Explain tables need to be created under schema X - your error has
nothing to do with redirected restore. Having all privileges is not
sufficient. You can either re-create explain tables with schema X or
you can simply create aliases to existing explain tables with new
schema X.
HTH

Keith Ponnapalli
adv_dba at yahoo dot com
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator

Ke*********@gmail.com wrote:
When a backup is taken from server a and then redirected restore is
done on server b, the tables and data is fine however db2advis says
"explain & advise tables not created for user x properly". However user
x has access read, insert, delete rights to the advise & explain tables
as well the tablespace where tables exist. I am perplexed and for some
reason think it has something to do with the redirected restore am I
correct. Any replys much appreciated!


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.