Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Unanswered: Increase tablespace

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What does the command "list tablespaces show detail" show for this tablespace?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Sep 2008
    Posts
    6

    Smile This may help

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •