DB2 – How to check if autoresize is enabled

Creating a tablespace with Autoresize enabled is straightforward. An example: CREATE TABLESPACE TBLDMS4 MANAGED BY DATABASE USING (FILE '/db2db/TBLDMS4' 10 M) AUTORESIZE YES If the tablespace is already created how can you identify if autoresize is enabled? Use the tablespace monitor snapshot output monitor output. db2 get snapshot for tablespaces on MYDB For Automatic Storage check “Using automatic storage” – if it’s “1” than it’s enabled for Automatic Storage.For automatic resize check “Auto-resize enabled” and if it’s “Yes” Read More SQL0286N A default table space could not be found - DBA DB2 How to check for DB2 Direct IO and... Read more →