|
Problem IT19610
|
Status: Closed |
AUTOMAINT_GET_POLICY returns incorrect output |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
With this APAR applied, when there is no SELECT privilege on
SYSTOOLS.POLICY the call to the stored procedures below
SYSPROC.AUTOMAINT_GET_POLICY
SYSPROC.AUTOMAINT_GET_POLICYFILE
SYSPROC.AUTOMAINT_SET_POLICY
SYSPROC.AUTOMAINT_SET_POLICYFILE
will return SQL0551N like the example below:
call sysproc.automaint_set_policyfile('AUTO_REORG','reorg.xml')
SQL0551N The statement failed because the authorization ID does
not have the required authorization or privilege to perform the
operation. Authorization ID: "DB2INST1". Operation: "UPDATE".
Object: "SYSTOOLS.POLICY". SQLSTATE=42501
Without this fix, a misleading error or invalid output is
returned. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply v11.1 Mod 2 Fix Pack 2 to the DB2 database server. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem first fixed in v11.1 Mod 2 Fix Pack 2 |
| Workaround |
See LOCAL FIX. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.03.2017
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
