suche 36x36
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 IT18133 Status: Closed

FLUSH BUFFERPOOL ALL ON STANDBY MAY CAUSE FORCEDBSHUTDOWN

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Running of "flush bufferpool all" on a standby database, or 
"db2pdcfg -flushbp" on a non-ROS standby database, may cause 
database shutdown. 
 
db2diag.log: 
 
2016-10-18-06.51.27.226228+480 I237766A624          LEVEL: 
Severe 
PID     : 11468858             TID : 33669          PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
HOSTNAME: myhost1 
EDUID   : 33669                EDUNAME: db2hadrs.0.0 (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgWriteToDisk, 
probe:909 
MESSAGE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File 
cannot be used" 
          DIA8414C Logging can not continue due to an error. 
DATA #1 : <preformatted> 
TailPage 6094 does not match pagePso 13182633760404 and firstLso 
0. 
lowLso: 24839144, highLso: 24843220 
 
2016-10-18-06.51.27.227007+480 I238759A603          LEVEL: 
Warning 
PID     : 11468858             TID : 19277          PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
HOSTNAME: myhost1 
EDUID   : 19277                EDUNAME: db2loggw (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220 
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
DATA #1 : <preformatted> 
Error opening: 
/db/ccp/actlog/db2inst1/SAMPLE/NODE0000/LOGSTREAM0000/S0127868.L 
OG. 
 
2016-10-18-06.51.27.961310+480 I269541A568          LEVEL: 
Severe 
PID     : 11468858             TID : 152413         PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-33067              APPID: *LOCAL.DB2.161017225127 
HOSTNAME: myhost1 
EDUID   : 152413               EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqeApplication::AppStopUsing, probe:6876 
MESSAGE : ZRC=0xFFFFFBF6=-1034 
          SQL1034C  The database was damaged, so all 
applications processing 
          the database were stopped.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 6                               * 
****************************************************************
Local Fix:
Prevent running of "flush bufferpool all" and "db2pdcfg 
-flushbp" on a standby database.
Solution
First fixed in DB2 10.1 Fix Pack 6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.11.2016
02.03.2017
02.03.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)