SQL ERROR: -0551 after upgrade to DB2 V11

Products

• RC Compare for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.