Hello, We have a non-root installed 9.7.6 on Red hat 6.4. The second instance is root installed on the same box but at 9.7.8.
Redirected restore of db backup from non-root to root install was successful.
The database has some tablespaces set to automatic storage.
The restored database connects fine. I can do binds using the instance id.
With the instance ID, get dbsize fails:
When I attempt to grant select on catalog tables using instance id, it throws SQL0551N saying id does not have authorization or privilege to perform GRANT on the object.
Any ideas ?
"you need to transfer ownership..."
not because this resolved another problem, that this will resolve all your problems.
this problem has todo with authorities..
check in doc how to assign sysadm and getting authorities for user...
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be