IBM Support What's New?

How to determine whether or not a table space is using automatic storage.

Technote (FAQ)


A table space uses automatic storage in an automatic storage enabled database if the MANAGED BY AUTOMATIC STORAGE clause was specified when the table space was created .


To determine whether a table space is using automatic storage, use one of the following methods:

  • Using tablespace snapshot:
 $ db2 get snapshot for tablespaces on sample

The element " Using automatic storage" will indicate whether a table space is using automatic storage. For example:

Using automatic storage                  = Yes

  • Using the following snapshot table function:
db2 "select TBSP_NAME,TBSP_ID,TBSP_USING_AUTO_STORAGE from table(snap_get_tbsp('sample',-1)) as tbsp"

TBSP_USING_AUTO_STORAGE is 1 if automatic storage is enabled or 0 if it is not enabled.
  • Alternatively, for Version 8.1 FixPak 10 (also known as Version 8.2 FixPak 3) or later, you can also use the db2pd -tablespaces command:
    Note: In the following output, the "AS" column shows whether or not the tablespace is using automatic storage.

 $ db2pd -db sample -tablespaces

Tablespace Autoresize Statistics:
Address    Id AS  AR  InitSize  IncSize IIP MaxSize LastResize LRF
0x05267580 0  Yes Yes 33554432  -1      No  None    None       No
0x05267D50 1  Yes No  0          0      No  0       None       No
0x0526C510 2  Yes Yes 33554432  -1      No  None    None       No
0x0526CCE0 3  Yes Yes 33554432  -1      No  None    None       No
0x05C73EE0 4  Yes Yes 33554432  -1      No  None    None       No
0x05C98360 5  Yes No  0          0      No  0       None       No
  • Use the db2ckbkp - T command. A tablespace is enabled for automatic storage if the bit AND value of "flags" and "0x1000" is not zero. For example,
  db2ckbkp -T <backup_image>

The above command output has the following snippet:

  flags:  3122

  0x3122 AND
  0x1000 =

This tablespace is enabled for automatic storage because 0x3122 AND 0x1000 is not zero.

Related information

Automatic storage

Document information

More support for: DB2 for Linux, UNIX and Windows
DB2 Storage - Table Spaces

Software version: 9.1, 9.5, 9.7

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1251622

Modified date: 2006-12-12