DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using NAS storage for Tablespaces.                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 LUW V9.7 FixPack 9                            * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 LUW V9.7 FixPack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC96385 IC96423 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

01.03.2013
30.07.2014
30.07.2014

9.7.FP9