|
Problem IC96385
|
Status: Closed |
DB2 CREATE TABLESPACE COMMAND CAN FAIL WITH SQL0289N WHEN FILE SYSTEM SIZE EXCEEDS 16 TB |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Create tablespace command in an SMS tablespace may fail with
SQL0289N error in storage system with very large file system
sizes exceeding 16 TB. However os commands such as dd will be
able to create files in that file system with no errors.
db2diag.log snippet:
-------------------
2012-12-13-14.01.40.137432-480 E6548E842 LEVEL: Error
PID : 11409 TID : 47352953956672PROC :
db2sysc 0
INSTANCE: resdb2 NODE : 000 DB : SAMPLE
APPHDL : 0-1988 APPID: *LOCAL.resdb2.121213213340
AUTHID : RESDB2
EDUID : 21 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite,
probe:99
MESSAGE : ADM6017E The table space "IP8KTS" (ID "7") is full.
Detected on
container "/db2_db/respatp2/sample/tablespaces/ip8kts"
(ID "0"). The
underlying file system is full or the maximum allowed
space usage for
the file system has been reached. It is also possible
that there are
user limits in place with respect to maximum file size
and these
limits have been reached.
2012-12-13-14.01.40.146232-480 I7391E501 LEVEL: Error
PID : 11409 TID : 47352953956672PROC :
db2sysc 0
INSTANCE: resdb2 NODE : 000 DB : SAMPLE
APPHDL : 0-1988 APPID: *LOCAL.resdb2.121213213340
AUTHID : RESDB2
EDUID : 21 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite,
probe:99
MESSAGE : container page this was encountered on =
DATA #1 : unsigned integer, 8 bytes
0
db2trc info shows:
0604 errtrans DB2 UDB global services sqlzeMapZrc cei
(13.3.26.46.2.40)
pid 11409 tid 47352953956672 cpid 28141 node 0 probe 40
Error Translation
Original Error ZRC = 0x85020021 = -2063466463 =
SQLB_END_OF_CONTAINER
New Error SQL0289
40605 error DB2 UDB global services sqlzeMapZrc cei
(4.3.26.46.2.50)
pid 11409 tid 47352953956672 cpid 28141 node 0 probe 50
Error ZRC = 0x85020021 = -2063466463 = SQLB_END_OF_CONTAINER
bytes 144
This can occur where the file system is larger than 16 TB (2^32
4k pages). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users with tablepaces exceeding 16 TB. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 10.1 Fix Pack 3 or Later. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in db2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.09.2013
24.10.2013
24.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
