DB2 - Problem description
Problem IT23787 | Status: Closed |
DATABASE MANAGER FAILS TO CREATE A NEW STRIPE SET OF CONTAINERS AND HANGS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Disk full issue on existing storage paths After new storage paths are added to the storage group, if there is no space in the containers on the existing storage paths, A new stripe set of container is not able to be created and hangs. After hitting disk full, the next attempt to alter tablespace to increase space also hangs. Below consecutive messages will be logged while hangs: 2018-01-13-04.37.06.355945+000 I609603569E739 LEVEL: Error PID : 68093 TID : 46916033308416 PROC : db2sysc 8 INSTANCE: NODE : 008 DB : APPHDL : 8-74 APPID: AUTHID : HOSTNAME: EDUID : 691 EDUNAME: FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:865 MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. DATA #1 : Error acquiring container 4 (/SAMPLE/NODE0008/TESTDB/T0000001/C0000002.LRG) for tbsp 5. Rc = 850F000C 2018-01-13-04.37.06.380658+000 E609607441E1441 LEVEL: Error (OS) PID : 68093 TID : 46916033308416 PROC : db2sysc 8 INSTANCE: NODE : 008 DB : APPHDL : 8-74 APPID: AUTHID : HOSTNAME: EDUID : 691 EDUNAME: FUNCTION: DB2 UDB, oper system services, sqloseekwrite64, probe:40 MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. CALLED : OS, -, pwrite OSERR: ENOSPC (28) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 11 or higher * **************************************************************** | |
Local Fix: | |
Perform a tablespace rebalance after new path is added as a workaround,. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.01.2018 25.02.2020 24.03.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |