[LUW] question about automatic storage and autoresize option

DB2 DBA Jeffrey Benner

[LUW] question about automatic storage and autoresize option
The way it appears to me is, if you created an automatic storage tablespace
which was DMS for some reason with AUTORESIZE NO, and that tablespace were
to become full, your only recourse would be to issue an ALTER TABLESPACE...
AUTORESIZE YES in order to increase the size of the tablespace. Correct?
(since you cannot use DMS container operation against an automatic storage
tablespace)

I'm wondering why you would want to use AUTORESIZE NO on a DMS automatic
storage tablespace. Possibly for a tablespace which you believe should never
need to grow?

Thanks.


Jeffrey Benner
IBM Certified Database Administrator DB2 9 for Linux, UNIX and Windows
eBenner.com Consulting
http://www.ebenner.com
+001 312 520 0090
http://www.linkedin.com/in/ebenner

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L