Prev: Installing the visual studio add in for DB2
Next: love with learning and earning of the people
From: Willem Fischer on 11 Feb 2010 06:21
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
From: MarkB on 11 Feb 2010 08:20
On Feb 11, 2:21 pm, Willem Fischer <w.l.fisc...(a)googlemail.com> wrote:
> 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

Hi Willem,

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r0012562.htm

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

Sincerely,
Mark B.
 | 
Pages: 1
Prev: Installing the visual studio add in for DB2
Next: love with learning and earning of the people