Table space % used

John Breidenstine

Table space % used
Hello,

I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2 notify
me if a DMS table space reaches 90% capacity. Does anyone out there already
do this? If so, how?

Regards,

John L. Breidenstine
Computer Programmer 1
Legislative Data Processing Center



Helen Johnson

Re: Table space % used
(in response to John Breidenstine)
We have a C program that we run daily that tells us which tablespaces are over a certain percent use. We typically use 90%. I'm sorry I don't have access to the C program. It predates
me. But another way you can easily tell what percent is used is to use the Control Center. I run Control Center on Windows 95 and connect it to DB2 on AIX. Both are version 6.1. When
you list the tablespaces, you get the values for percentage used, size allocated and size used. You can sort on those columns ascending or descending. That way you know not only the 90%+
full, but if one of your critical tables is approaching 90%. This is especially usefull right before vacations and holidays when I'm not planning on being here.

Helen Johnson
Raytheon Aircraft

John Breidenstine wrote:

> Hello,
>
> I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2 notify
> me if a DMS table space reaches 90% capacity. Does anyone out there already
> do this? If so, how?
>
> Regards,
>
> John L. Breidenstine
> Computer Programmer 1
> Legislative Data Processing Center
>
>
>



Peter J Krawetzky

Re: Table space % used
(in response to Helen Johnson)
Watch out for this number. My experience is that the percent used will not
decrease until you reorg the tables in the tablespace. I know this happens
on the Solaris environment but I'm not sure about AIX. Just an FYI!

-----Original Message-----
From: Helen Johnson [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 9:52 AM
To: [login to unmask email]
Subject: Re: Table space % used


We have a C program that we run daily that tells us which tablespaces are
over a certain percent use. We typically use 90%. I'm sorry I don't have
access to the C program. It predates
me. But another way you can easily tell what percent is used is to use the
Control Center. I run Control Center on Windows 95 and connect it to DB2 on
AIX. Both are version 6.1. When
you list the tablespaces, you get the values for percentage used, size
allocated and size used. You can sort on those columns ascending or
descending. That way you know not only the 90%+
full, but if one of your critical tables is approaching 90%. This is
especially usefull right before vacations and holidays when I'm not planning
on being here.

Helen Johnson
Raytheon Aircraft

John Breidenstine wrote:

> Hello,
>
> I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2
notify
> me if a DMS table space reaches 90% capacity. Does anyone out there
already
> do this? If so, how?
>
> Regards,
>
> John L. Breidenstine
> Computer Programmer 1
> Legislative Data Processing Center
>
>
>










Helen Johnson

Re: Table space % used
(in response to Peter J Krawetzky)
I was somewhat confused by your message because I was sure that when I connected to Control Center this morning that the change I had made earlier had been reflected in Control Center. So
I did some testing. I picked a tablespace that was 89% full. Altered it to add an extent. Then I went back to Control Center - no change. I disconnected and reconnected to the database
- still no change. I closed Control Center and opened it again - the change was now visible. Thanks for the heads up Peter.

Helen

"Krawetzky, Peter J" wrote:

> Watch out for this number. My experience is that the percent used will not
> decrease until you reorg the tables in the tablespace. I know this happens
> on the Solaris environment but I'm not sure about AIX. Just an FYI!
>
> -----Original Message-----
> From: Helen Johnson [mailto:[login to unmask email]
> Sent: Thursday, December 21, 2000 9:52 AM
> To: [login to unmask email]
> Subject: Re: Table space % used
>
> We have a C program that we run daily that tells us which tablespaces are
> over a certain percent use. We typically use 90%. I'm sorry I don't have
> access to the C program. It predates
> me. But another way you can easily tell what percent is used is to use the
> Control Center. I run Control Center on Windows 95 and connect it to DB2 on
> AIX. Both are version 6.1. When
> you list the tablespaces, you get the values for percentage used, size
> allocated and size used. You can sort on those columns ascending or
> descending. That way you know not only the 90%+
> full, but if one of your critical tables is approaching 90%. This is
> especially usefull right before vacations and holidays when I'm not planning
> on being here.
>
> Helen Johnson
> Raytheon Aircraft
>
> John Breidenstine wrote:
>
> > Hello,
> >
> > I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2
> notify
> > me if a DMS table space reaches 90% capacity. Does anyone out there
> already
> > do this? If so, how?
> >
> > Regards,
> >
> > John L. Breidenstine
> > Computer Programmer 1
> > Legislative Data Processing Center
> >
> >
> >
>
>
>
>
>
>
>
>
>
>



Jeremy Dodd

Re: Table space % used
(in response to Helen Johnson)
John,

Another option for this is to look at the Space-GUY tool from Database Guys. This can be set up to fire off an alaram when the file systems get to a certain percent full (or file systems
if you were interested in SMS). It can also estimate (if you keep history) when the file system can become full.

have a look at their web site.

Cheers,

Jeremy


John Breidenstine wrote:

> Hello,
>
> I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2 notify
> me if a DMS table space reaches 90% capacity. Does anyone out there already
> do this? If so, how?
>
> Regards,
>
> John L. Breidenstine
> Computer Programmer 1
> Legislative Data Processing Center
>
>
>



Larry Cable

Re: Table space % used
(in response to Jeremy Dodd)
I'm currently doing it now with a Korn shell script on AIX UDB 6.1. I send
out mail when the tablespace is 85% full. A "page" when the tablespace is
95% full.

LarryC

----- Original Message -----
From: "John Breidenstine" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Wednesday, December 20, 2000 3:01 PM
Subject: Table space % used


> Hello,
>
> I am working with DB2 V6.1 on AIX. I am looking for a way to have DB2
notify
> me if a DMS table space reaches 90% capacity. Does anyone out there
already
> do this? If so, how?
>
> Regards,
>
> John L. Breidenstine
> Computer Programmer 1
> Legislative Data Processing Center
>
>
>


>