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 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)