DB2 FOR LUW / DB2FORLUW / B10 - DB2

SQL0551N is received when a call to the EXPLAIN_FROM_DATA 
procedure is made by a user which does not explicitly have 
INSERT privilege on the EXPLAIN TABLES but is part of a group 
which has INSERT privilege for these tables. 
 
If the GROUP has the INSERT Privilege, it should be implicitly 
granted to the USER as it is part of the group. 
 
Following is an example of what may be seen when 
explain_from_data is run: 
db2 -v "call explain_from_data ((select section from 
sysibm.syssection fetch first 1 row only), '', null, 'SYSTOOLS', 
?, ?, ?, ?, ?)" 
 
SQL0551N  The statement failed because the authorization ID does 
not have the required authorization or privilege to perform the 
operation. 
Authorization ID: "DB2USER".  Operation: "INSERT". Object: 
"SYSTOOLS.EXPLAIN_INSTANCE". SQLSTATE=42501

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               * 
****************************************************************

Explicitly grant the INSERT privilege to the USER in question

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in DB2 11.1 Mod 2 Fix Pack 2

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.01.2017
28.06.2017
28.06.2017