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 IT04599 Status: Geschlossen

MON_GET_TABLESPACE TABLE FUNCTION CAN RETURN NEGATIVE VALUES FOR
TBSP_INITIAL_SIZE & TBSP_MAX_SIZE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
The MON_GET_TABLESPACE table function can return negative values 
for TBSP_INITIAL_SIZE & TBSP_MAX_SIZE. 
 
db2sampl -xml -sql 
db2 connect to sample 
db2 "create LARGE tablespace MDL_LOB" 
db2 "SELECT TBSP_NAME, TBSP_INITIAL_SIZE, TBSP_MAX_SIZE FROM 
TABLE(MON_GET_TABLESPACE('',-2)) AS t" 
 
TBSP_NAME        TBSP_INITIAL_SIZE TBSP_MAX_SIZE 
---------------- ----------------- -------------------- 
SYSCATSPACE               33554432            -1 
TEMPSPACE1                       -             - 
USERSPACE1                33554432            -1 
IBMDB2SAMPLEREL           33554432            -1 
IBMDB2SAMPLEXML           33554432            -1 
SYSTOOLSPACE              33554432            -1 
MDL_LOB                   33554432            -1 
 
db2 "ALTER TABLESPACE MDL_LOB AUTORESIZE YES MAXSIZE 2G" 
 
db2 "SELECT TBSP_NAME, TBSP_INITIAL_SIZE, TBSP_MAX_SIZE FROM 
TABLE(MON_GET_TABLESPACE('',-2)) AS t" 
 
TBSP_NAME        TBSP_INITIAL_SIZE TBSP_MAX_SIZE 
---------------- ----------------- ------------- 
SYSCATSPACE               33554432            -1 
TEMPSPACE1                       -             - 
USERSPACE1                33554432            -1 
IBMDB2SAMPLEREL           33554432            -1 
IBMDB2SAMPLEXML           33554432            -1 
SYSTOOLSPACE              33554432            -1 
MDL_LOB                   33554432   -2147483648 
 
db2 "ALTER TABLESPACE MDL_LOB AUTORESIZE YES MAXSIZE 1G" 
 
 
db2 "SELECT TBSP_NAME, TBSP_INITIAL_SIZE, TBSP_MAX_SIZE FROM 
TABLE(MON_GET_TABLESPACE('',-2)) AS t" 
 
TBSP_NAME        TBSP_INITIAL_SIZE    TBSP_MAX_SIZE 
---------------- ----------------- ---------------- 
SYSCATSPACE               33554432               -1 
TEMPSPACE1                       -                - 
USERSPACE1                33554432               -1 
IBMDB2SAMPLEREL           33554432               -1 
IBMDB2SAMPLEXML           33554432               -1 
SYSTOOLSPACE              33554432               -1 
MDL_LOB                   33554432       1073741824
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 LUW v10.5 Fixpack 5 or Later.                * 
****************************************************************
Local-Fix:
Lösung
First Fixed in DB2 LUW v10.5 Fixpack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.09.2014
13.03.2015
13.03.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList