Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC64509 Status: Closed

IN DPF, CONNECTING TO A QUIESCED DATABASE BY A USER WHO HAS
QUIESCE_CONNECT AUTHORITY MAY STILL THROW A SQL20157N ERROR

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
In DPF environments, After granting quiesce_connect on the 
database to the user and even to its group, if the instance is 
quiesced as follows "db2 quiesce instance <instancename> group 
cmodprod immediate", connect to the database by setting DB2NODE 
to another partition would  fail with SQL20157N error though 
theuser has quiesce_connect authority. 
 
 For example: 
db2 "grant quiesce_connect on database to user usr1" 
db2 "grant quiesce_connect on database to group grp1" 
db2 quiesce instance <instancename> group grp1 immediate 
 
As usr1: 
export DB2NODE=1 
db2 terminate 
db2 connect to <dbname> 
SQL20157N  User "usr1 " does not have the QUIESCE_CONNECT 
privilege. SQLSTATE=08004
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users in a DPF Environment                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* IN DPF, CONNECTING TO A QUIESCED DATABASE BY A USER WHO HAS  * 
* QUIESCE_CONNECT AUTHORITY MAY STILL THROW A SQL20157N ERROR  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.1 Fixpak 9                              * 
* or                                                           * 
* Use the workaround listed                                    * 
****************************************************************
Local Fix:
Invoke the quiesce command using the user option instead for 
every user belonging to the group. 
db2 quiesce instance <inst_name> user usr1 immediate
available fix packs:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Problem was first first fixed in Version 9.1 Fixpak 9
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC65138 IC65139 IZ66828 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.11.2009
19.04.2010
19.04.2010
Problem solved at the following versions (IBM BugInfos)
9.0.,
9.1.
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.