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!