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 IT23157 Status: Closed

SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYINGSMS BAD
PAGE.

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
DB2 does page verification of pages read from disk before
putting them into bufferpools, and during this page
verification, if the page verified is bad for some reason, then
DB2 writes "page is bad" errors into db2diag.log.

When page verification fails on a page read from SMS tablespace,
then DB2 may write also a misleading 'out of disk space" error
into db2diag.log when, in fact, there is plenty of space on the
disks where SMS tablespace resides.

db2diag.log entries may look like these:

2017-10-31-18.50.58.474573-240 I2180324A604         LEVEL:
Severe
PID     : 20251380             TID : 299996         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-57030              APPID: local
AUTHID  : db2inst1             HOSTNAME: localhost
EDUID   : 299996               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage,
probe:1151
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
          DIA8312C Disk was full.
DATA #1 : String, 30 bytes
Error verifying SMS temp page.


This defect will remove the misleading error message.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : 
follow-up : IT23197 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.11.2017
27.11.2018
27.11.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)