Fixes are available
APAR status
Closed as program error.
Error 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.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 4 Fixpack 4
Temporary fix
Comments
APAR Information
APAR number
IT23157
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-14
Closed date
2018-11-27
Last modified date
2018-11-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022