←
→

DB2 transport schemas with DB2_RESTORE_GRANT_ADMIN_AUTHORITIES

Posted: October 5, 2014 | Author: | Filed under: DB2 10, DB2 10.5, DB2 LUW |Leave a comment

When transporting schemas via a restore if the instance owner does not have permission to bind then no objects are transfered.

Since DB2 V9.7, the user who restores the database by default is not granted with SYSADM and DBA authority after the database is restored. If the user happens to be different from the instance user in the source database, this will cause an issue like this.

The solution is db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES then run the restore again.

http://www-01.ibm.com/support/docview.wss?uid=swg21685941&myns=swgimgmt&mynp=OCSSEPGG&mync=E

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

←
→