Unanswered: How to enable reclaimable_space_enabled for automatic storage tablespace
Informational tokens are "DB2 v188.8.131.52", "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
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-01.20.51.000000
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
Most likely the database (and tablespace) was originally created with an older version of DB2 than v9.7.
See this link: http://www-01.ibm.com/support/knowle.../c0055392.html
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.