I inherited a DB2 database, v9.5 fixpack 6. The tablespaces used by the application are set up to use DMS with automatic storage.
The problem, it doesn't look like the tablespace is auto-extending. We have monitoring in place to alert us if it gets 90% or more used. I got an alert about it saw that it was indeed over 90% used. I issued an alter command "ALTER TABLESPACE TBTS_RESULTS EXTEND (ALL 50M) " and it completed successfully.
From what i've read, this ALTER command should not have worked and I should have gotten an error. From IBM,
Container operations (ADD, EXTEND, RESIZE, DROP, or BEGIN NEW STRIPE SET) cannot be performed on automatic storage table spaces, because the database manager is controlling the space management of such table spaces (SQLSTATE 42858)
Why isn't AUTOMATIC storage working for this tablespace?
Here is the DDL for it:
CREATE LARGE TABLESPACE TBTS_RESULTS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
USING (FILE '/data1/tbts_results' 5360,
FILE '/data2/tbts_results' 5360,
FILE '/data3/tbts_results' 5360,
FILE '/data4/tbts_results' 5360)
INCREASESIZE 16 M
NO FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;