Re: dbspace stat

Posted in 1998

Pons Roca, Isidre — Thu, 12 Nov 1998 18:45:16 +0100 — source: Informix-list mailing list archive (1991-1998)

En Yan Zhu va escriure el dia 12 Nov 98, a les 10:18: > hi: > I need a command to give me a list of dbspaces and their total size > and > their used size, how do I accomplish that? > soalris 2.6 with onlinke 7.3 > thanks > > Hi. You can do it with: a) run dbaccess and select sysmaster database b) run the next sql-statment: select name, count(*) chunks, sum(chksize) space_allocated, sum(nfree) space_free from syschunks,sysdbspaces wheresyschunks.dbsnum=sysdbspaces.dbsnum group by 1 --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------