Re: database current size used.

Get my package, utils_ak, which contains dbsavail.ec and dbsavail.sh either/both of which report totals by dbspace. Dbsavail.ec is an executable and so can be faster and can run on monitoring machines which do not have onstat installed, however, it installs a stored procedure the first time it runs on a new server. Dbsavail.sh is a ksh & perl implementation that post processes onstat -d output to achieve the same report as dbsavail.ec, but, it has to run on the server on which it is reporting. Utils_ak is available for download from the IIUP Software Repository. Art S. Kagel ----- Original Message ----- From: Silvana Meza <smeza@fheg.follett.com> At: 2/10 17:47 > IDS 7.31uc7 > AIX 4.3.3 > > I know that onstat -d gives the current size allocated and free in > pages....but > it doesn't give any totals. > > Is there an easy way to get the total size that is actually being used? > > Silvana

Thanks to ALL! I now have more then one way to get this information. Silvana :) ----Original Message----- From: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] Sent: Tuesday, February 11, 2003 8:20 AM To: ids@iiug.org Subject: Re: database current size used. [330] Get my package, utils_ak, which contains dbsavail.ec and dbsavail.sh either/both of which report totals by dbspace. Dbsavail.ec is an executable and so can be faster and can run on monitoring machines which do not have onstat installed, however, it installs a stored procedure the first time it runs on a new server. Dbsavail.sh is a ksh & perl implementation that post processes onstat -d output to achieve the same report as dbsavail.ec, but, it has to run on the server on which it is reporting. Utils_ak is available for download from the IIUP Software Repository. Art S. Kagel ----- Original Message ----- From: Silvana Meza <smeza@fheg.follett.com> At: 2/10 17:47 > IDS 7.31uc7 > AIX 4.3.3 > > I know that onstat -d gives the current size allocated and free in > pages....but > it doesn't give any totals. > > Is there an easy way to get the total size that is actually being used? > > Silvana

Hi, You can use "set session authorization" in ids 7.3X. Example: ptab1.owner=user_owner set session authorization to "user_owner"; revoke select on ptab1 from user1 Vagner On Wed, 12 Feb 2003 11:38:23 -0500 (EST), "Meza, Silvana" <smeza@fheg.follett.com> wrote : > Thanks to ALL! > I now have more then one way to get this information. > > Silvana :) > > > > ----Original Message----- > From: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] > Sent: Tuesday, February 11, 2003 8:20 AM > To: ids@iiug.org > Subject: Re: database current size used. [330] > > > > Get my package, utils_ak, which contains dbsavail.ec and dbsavail.sh > either/both > of which report totals by dbspace. Dbsavail.ec is an executable and so can > be > faster and can run on monitoring machines which do not have onstat > installed, > however, it installs a stored procedure the first time it runs on a new > server. > Dbsavail.sh is a ksh & perl implementation that post processes onstat -d > output > to achieve the same report as dbsavail.ec, but, it has to run on the server > on > which it is reporting. Utils_ak is available for download from the IIUP > Software Repository. > > Art S. Kagel > > ----- Original Message ----- > From: Silvana Meza <smeza@fheg.follett.com> > At: 2/10 17:47 > > > IDS 7.31uc7 > > AIX 4.3.3 > > > > I know that onstat -d gives the current size allocated and free in > > pages....but > > it doesn't give any totals. > > > > Is there an easy way to get the total size that is actually being used? > > > > Silvana > > > > > > -- *IBM Solution Expert - Informix/Db2 Database Administrator* Yoshitec Informática Ltda We do the intelligent choice São Paulo: Rua Luis Coelho, 308 6o. andar cjs. 63/64 Telefones: (55-11) 3255-7601 - Fax: (55-11) 3255-3541 Jundiaí: Rua Pitangueiras, 18 5o. andar conj. 52 - Fone/Fax: (55-11) 4587-0505