SQL ERROR: -0551 after upgrade to DB2 V11

Document ID : KB000116620
Last Modified Date : 03/10/2018
Show Technical Document Details
Issue:
What needs to be rebound after an upgrade to DB2 V11, we are getting authorization failures after upgrading to DB2 V11.
Environment:
z/os DB2
Cause:
the error is caused by a lack of temporary space.
Resolution:
From the DB2® Messages and Codes, sqlcode -904 and reason code 00C90084 shows that the error is caused by a lack of temporary space. Because the query is returning a lot of results, the 4 KB temporary space was insufficient. Answer Ask your DB2 system administrator to give enough space on the temporary table. Your database administrator or the DB2 manuals will have suggestions about the appropriate size of the temporary table. After the temporary database table size has been increased by the database administrator, and DB2 has been restarted, you can run the query again.