Whether Automatic Storage is enabled for the DB2 tablespace (1)

How can I determine whether automatic storage is enabled for a created DB2 database tablespace? This article describes three common Check Methods for your reference.

Method 1:

Use the snapshot tool of DB2 to take snapshots of the table space, for example:
$ Db2 get snapshot for tablespaces on sample
......
Tablespace name = SYSCATSPACE
Tablespace ID = 0
Tablespace Type = Database managed space
Tablespace Content Type = All permanent data. Regular table space.
Tablespace Page size (bytes) = 4096
Tablespace Extent size (pages) = 4
Automatic Prefetch size enabled = Yes
Buffer pool ID currently in use = 1
Buffer pool ID next startup = 1
Using automatic storage = Yes
......
You can confirm that automatic storage is enabled for the tablespace by setting "Using automatic storage" to "Yes" output from the snapshot.

Method 2:

Use the following snapshot table functions provided by DB2:
$ Db2 "select char (TBSP_NAME), 30)
TBSP_NAME, TBSP_ID, TBSP_USING_AUTO_STORAGE from
Table (snap_get_tbsp ('sample',-1) as tbsp"

The Automatic Storage is enabled for the tablespace where TBSP_USING_AUTO_STORAGE is "1". If there is "0", it is not enabled.