Hi,

I'm writing scripts to monitor our databases. They should be somewhat
universal, i.e. run on on DB2 versions 8+ (yes, we still have some V8
databases).

Is there a way to get the autoresize flag of a tablespace using a
table function (or any other SQL statement)?

Of course, I could parse GET SNAPSHOT FOR TABLESPACES or db2pd, but I
want to implement everything in SQL.

Thanks in advance,

Willem

On Feb 11, 2:21*pm, Willem Fischer <w.l.fisc... (AT) googlemail (DOT) com> wrote:
Hi Willem,

http://publib.boulder.ibm.com/infoce...n/r0012562.htm

select tbsp_auto_resize_enabled, tbsp_name
from table(snap_get_tbsp('', -1)) t
where tbsp_type=0

Sincerely,
Mark B.