It's all about the answers!

Ask a question

Upgrade script fails at "CREATE SCHEMA DIAGNOSTICTESTS&


Brian Reynolds (1689) | asked Nov 07 '11, 2:31 p.m.
Both the db2diag and the upgrade log indicate that the user in question doesn't have the correct access rights. That seems odd to me as why would all the SQL up until that statement execute correctly if the user wasn't authorized? Prior to executing I ran the appropriate grant dbmadm to the user.

One answer



permanent link
Brian Reynolds (1689) | answered Nov 08 '11, 1:01 p.m.
Interesting. I had upgraded DB2 from 9.5 to 9.7 on the target system before doing the upgrade. When I used 9.5 on both, the error doesn't appear. I'll try upgrading to 9.7 after the 3.0 migration.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.