Flummoxed - Tablespace autoresize

jhehir · #1 (**permalink**) 05-03-06, 11:44

I specified this when creating some tablespaces;

Does anybody know where autoresize, increasesize, and maxsize it is stored, Id' imagine in the catalog but where.

- John H

db2 udb fp11 on aix

dbamota · #2 (**permalink**) 05-04-06, 14:44

Methinks it is in /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLSPCS.1 (and .2)

cchattoraj · #3 (**permalink**) 05-08-06, 22:59

try a db2look for tablespaces ( I think it's the -l option)> Do post and let us know if this worked.

I haven't seen this in the table function snapshot_tbs_cfg.

n_i · #4 (**permalink**) 05-09-06, 10:26

Code:

$ db2 get snapshot for tablespaces on test
...
Tablespace name                            = TEST

...
  Using automatic storage                  = Yes
  Auto-resize enabled                      = Yes
...
  Initial tablespace size (bytes)          = 10485760
  Current tablespace size (bytes)          = 10485760
  Maximum tablespace size (bytes)          = 104857600
  Increase size (percent)                  = 10

Internet Services

Web Development

Digital Marketing

Consumer Tech