home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC84452 Status: Geschlossen

ALTER TABLESPACE SIZE TO A LARGE VALUE ON RAW DEVICE MAY CAUSE DB2 TRAP

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
In some cases, altering tablespace size to a large value on raw 
device will cause the integer overflow error. Sometimes, when 
doing resize tablespace container operation,  if the total size 
of the extended tablespace in KB is larger than 4294967295(4TB) 
which is the max value of 32bit integer, db2 may trap during the 
undo phase. 
 
Some similar entries could be wriiten in db2diag.log. A record 
with totalPages less than contSize, e.g (totalPages = 512000000) 
< (contSize = 1342242816) may indicate the overflow occurs. 
 
 
2012-02-27-15.40.17.930364+480 I30756777E570       LEVEL: Error 
PID     : 14453                TID  : 47246594795840PROC : 
db2sysc 0 
INSTANCE: db2inst             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-25844              APPID: 
*LOCAL.db2inst2.121025001347 
AUTHID  : DB2INST2 
EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbResizeDMSContainer, 
probe:30 
MESSAGE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad 
container size" 
DATA #1 : String, 45 bytes 
totalPages = 512000000, contSize = 1342242816 
 
2012-02-27-15.40.17.930502+480 I30757348E482       LEVEL: Error 
PID     : 14453                TID  : 47246594795840PROC : 
db2sysc 0 
INSTANCE: db2inst             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-25844              APPID: 
*LOCAL.db2inst2.121025001347 
AUTHID  : DB2INST 
EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbUndo, probe:0 
MESSAGE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad 
container size" 
 
 
2012-02-27-15.40.17.930587+480 I30757831E480       LEVEL: Severe 
PID     : 14453                TID  : 47246594795840PROC : 
db2sysc 0 
INSTANCE: db2inst             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-25844              APPID: 
*LOCAL.db2inst2.121025001347 
AUTHID  : DB2INST 
EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, data management, sqldmund, probe:764 
RETCODE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad 
container size" 
 
2012-02-27-15.40.17.947179+480 I30759963E502       LEVEL: Severe 
PID     : 14453                TID  : 47246594795840PROC : 
db2sysc 0 
INSTANCE: db2inst             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-25844              APPID: 
*LOCAL.db2inst2.121025001347 
AUTHID  : DB2INST 
EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, 
probe:10 
MESSAGE : DIA0505I Execution of a component signal handling 
function has begun.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In some cases, altering tablespace size to a large value on  * 
* raw                                                          * 
* device will cause the integer overflow error. Sometimes,     * 
* when                                                         * 
* doing resize tablespace container operation,  if the total   * 
* size                                                         * 
* of the extended tablespace in KB is larger than              * 
* 4294967295(4TB)                                              * 
* which is the max value of 32bit integer, db2 may trap during * 
* the                                                          * 
* undo phase.                                                  * 
*                                                              * 
* Some similar entries could be wriiten in db2diag.log. A      * 
* record                                                       * 
* with totalPages less than contSize, e.g (totalPages =        * 
* 512000000)                                                   * 
* < (contSize = 1342242816) may indicate the overflow occurs.  * 
*                                                              * 
*                                                              * 
* 2012-02-27-15.40.17.930364+480 I30756777E570       LEVEL:    * 
* Error                                                        * 
* PID     : 14453                TID  : 47246594795840PROC :   * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst             NODE : 000          DB   :     * 
* SAMPLE                                                       * 
* APPHDL  : 0-25844              APPID:                        * 
* *LOCAL.db2inst2.121025001347                                 * 
* AUTHID  : DB2INST2                                           * 
* EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0  * 
* FUNCTION: DB2 UDB, buffer pool services,                     * 
* sqlbResizeDMSContainer,                                      * 
* probe:30                                                     * 
* MESSAGE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad   * 
* container size"                                              * 
* DATA #1 : String, 45 bytes                                   * 
* totalPages = 512000000, contSize = 1342242816                * 
*                                                              * 
* 2012-02-27-15.40.17.930502+480 I30757348E482       LEVEL:    * 
* Error                                                        * 
* PID     : 14453                TID  : 47246594795840PROC :   * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst             NODE : 000          DB   :     * 
* SAMPLE                                                       * 
* APPHDL  : 0-25844              APPID:                        * 
* *LOCAL.db2inst2.121025001347                                 * 
* AUTHID  : DB2INST                                            * 
* EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0  * 
* FUNCTION: DB2 UDB, buffer pool services, sqlbUndo, probe:0   * 
* MESSAGE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad   * 
* container size"                                              * 
*                                                              * 
*                                                              * 
* 2012-02-27-15.40.17.930587+480 I30757831E480       LEVEL:    * 
* Severe                                                       * 
* PID     : 14453                TID  : 47246594795840PROC :   * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst             NODE : 000          DB   :     * 
* SAMPLE                                                       * 
* APPHDL  : 0-25844              APPID:                        * 
* *LOCAL.db2inst2.121025001347                                 * 
* AUTHID  : DB2INST                                            * 
* EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0  * 
* FUNCTION: DB2 UDB, data management, sqldmund, probe:764      * 
* RETCODE : ZRC=0x80020046=-2147352506=SQLB_BAD_CONT_SZ "bad   * 
* container size"                                              * 
*                                                              * 
* 2012-02-27-15.40.17.947179+480 I30759963E502       LEVEL:    * 
* Severe                                                       * 
* PID     : 14453                TID  : 47246594795840PROC :   * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst             NODE : 000          DB   :     * 
* SAMPLE                                                       * 
* APPHDL  : 0-25844              APPID:                        * 
* *LOCAL.db2inst2.121025001347                                 * 
* AUTHID  : DB2INST                                            * 
* EDUID   : 62566                EDUNAME: db2agent (SAMPLE) 0  * 
* FUNCTION: DB2 UDB, DRDA Application Server,                  * 
* sqljsSignalHandler,                                          * 
* probe:10                                                     * 
* MESSAGE : DIA0505I Execution of a component signal handling  * 
* function has begun.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v01fp1.                                       * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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

Lösung
This fix will be includeding DB2 Version 10 Fixpack1.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2012
29.01.2013
29.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList