Hello everyone,

I try to increase the tablespace with the following to 8K:

alter tablespace USERSPACE1 RESIZE ( ALL 8192 )

...but I then get this error message:

SQL20170N There is not enough space in the table space "USERSPACE1" for the
specified action. SQLSTATE=57059

Thats confusing to me, because having not enough space is what I know, therefore I try to increase it. So what do I have to do for getting more space?

What does the command "list tablespaces show detail" show for this tablespace?

USERSPACE1 may be a SMS tabkepace (espcially if created in version 8), in which case you cannot specify the size. An SMS tablespace increases and shrinks automatically up to the amount of space on the path where the container(s) is located.

db2 "? SQL20170N"


SQL20170N There is not enough space in the table space
"<tablespace-name>" for the specified action. Reason
code = "<reason-code>".

Explanation:

Space is being removed from a tablespace using one or more of
the DROP, REDUCE, and RESIZE container actions resulting in one
of the following scenarios:


1 The amount of space being removed is greater than the amount
of space above the high-water mark.

2 The amount of space being removed would result in the
tablespace having less then the required 5 extents.



User Response:


1 Use the snapshot monitor to find the number of useable pages
in the tablespace and the tablespace high-water mark. The
difference between these values is the maximum number of pages
that can be removed.

2 Use the snapshot monitor to find the number of useable pages
in the tablespace and the tablespace extentsize. The number of
useable extents in the tablespace is equal to the useable pages
divided by the extentsize. There must be at least 5 extents worth
of useable pages in the tablespace.



sqlcode : -20170

sqlstate : 57059