|
Problem IT17555
|
Status: Closed |
TBSP_INCREASE_SIZE RETURNED BY MON_GET_TABLESPACE HAS INVALID VALUE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
The MON_GET_TABLESPACE table function returns invalid minus
values for for TBSP_INCREASE_SIZE if the table space's
INCREASESIZE is 2GB or larger.
example:
$ db2 "CREATE TABLESPACE DMS1 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS1' 10M) AUTORESIZE
YES"
$ db2 "CREATE TABLESPACE DMS2 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS2' 10M) AUTORESIZE YES
INCREASESIZE 2560M"
$ db2 "CREATE TABLESPACE DMS3 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS3' 10M) AUTORESIZE YES
INCREASESIZE 1024M"
$ db2 "CREATE TABLESPACE DMS4 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS4' 10M) AUTORESIZE YES
INCREASESIZE 1025M"
$ db2 "CREATE TABLESPACE DMS5 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS5' 10M) AUTORESIZE YES
INCREASESIZE 2048M"
$ db2 "CREATE TABLESPACE DMS6 MANAGED BY DATABASE USING (FILE
'//work/db2users/e105q7a/82113.693.760/DMS6' 10M) AUTORESIZE YES
INCREASESIZE 2047M"
$ db2 "SELECT varchar(tbsp_name, 30) as tbsp_name, tbsp_type,
TBSP_MAX_SIZE, TBSP_INCREASE_SIZE FROM
TABLE(MON_GET_TABLESPACE('',-2)) AS t ORDER BY tbsp_name DESC"
TBSP_NAME TBSP_TYPE TBSP_MAX_SIZE
TBSP_INCREASE_SIZE
------------------------------ ---------- --------------------
--------------------
USERSPACE1 DMS -1
-1
TEMPSPACE1 SMS -
-
SYSTOOLSPACE DMS -1
-1
SYSCATSPACE DMS -1
-1
DMS6 DMS -1
2146435072
DMS5 DMS -1
-2147483648
DMS4 DMS -1
1074790400
DMS3 DMS -1
1073741824
DMS2 DMS -1
-1610612736
DMS1 DMS -1
-1
In this example, the tablespace DNS2 and DMS5 were created with
INCREASESIZE parameter more than 2GB. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* User using MON_GET_TABLESPACE function *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to FP9. *
**************************************************************** |
| Local Fix: |
|
| Solution |
This problem is first fixed in DB2 V10.5 Fix Pack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.10.2016
27.09.2017
27.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
