Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: How to enable reclaimable_space_enabled for automatic storage tablespace


    Informational tokens are "DB2 v9.7.0.8", "s130316", "IP23426", and Fix Pack
    Product is installed at "/opt/IBM/db2e/V9.7".


    Have automatic storage tablespace which is have 4 G free space,

    Tablespace ID = 03
    Name = USERSPACE3
    Type = Database managed space
    Contents = All permanent data. Regular table space.
    State = 0x0000
    Detailed explanation:
    Total pages = 5062656
    Useable pages = 5062528
    Used pages = 3839328
    Free pages = 1223200
    High water mark (pages) = 3839456
    Page size (bytes) = 4096
    Extent size (pages) = 32
    Prefetch size (pages) = 96
    Number of containers = 4
    Minimum recovery time = 2014-04-04-

    Alter tablespace userspace3 reduce max

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1763N Invalid ALTER TABLESPACE statement for table space "SSP#PDTT" due to
    reason "11" SQLSTATE=429BC

    Its not possible to enable this tablspace for reclaimable_space_enabled = 1

    checked with query its not enabled to reclaimable_space

    please suggest


  2. #2
    Join Date
    Apr 2012
    Provided Answers: 27
    Most likely the database (and tablespace) was originally created with an older version of DB2 than v9.7.
    See this link:
    in particular this advice:
    For table spaces created in an earlier version, you must first replace the table space with a new one created using DB2 V9.7. You can either unload and reload the data or move the data with an online table move operation using the SYSPROC.ADMIN_MOVE_TABLE procedure. Such a migration is not required, however. Table spaces for which reclaimable storage is enabled can coexist in the same database as table spaces without reclaimable storage.

Posting Permissions

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