DB2 - Problem description
Problem IT23016 | Status: Closed |
DB2 AUTHORITIES ARE IGNORED WITH CHANGE DATABASE CONFIGURATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
DB2 authorities are ignored with change database configuration. In a partition database instance. OUTPUT: db2host ~ # su - db2test Last login: Thu Oct 19 02:36:11 PDT 2017 on pts/0 db2test@db2host ~ $ export DB2NODE=1 db2test@db2host ~ $ db2 connect to sample Database Connection Information Database server = DB2/LINUXX8664 11.1.2.2 SQL authorization ID = DB2TEST Local database alias = SAMPLE db2test@db2host ~ $ db2 "values (current dbpartitionnum)" 1 ----------- 1 1 record(s) selected. db2test@db2host ~ $ db2 update db cfg for sample member 0 using logsecond 12 DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. db2test@db2host ~ $ db2 connect reset DB20000I The SQL command completed successfully. db2test@db2host ~ $ db2 terminate DB20000I The TERMINATE command completed successfully. db2test@db2host ~ $ export DB2NODE=0 db2test@db2host ~ $ db2 connect to sample Database Connection Information Database server = DB2/LINUXX8664 11.1.2.2 SQL authorization ID = DB2TEST Local database alias = SAMPLE db2test@db2host ~ $ db2 update db cfg for sample member 0 using logsecond 12 SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "DB2TEST". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.11.2017 16.03.2018 16.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |