Re: Size of Database [363]
----- Original Message -----
From: Nestor Gomez <nestor@rtn.uson.mx>
At: 6/23 15:32
> This is an old question, but I have tried some suggestions from people
> without success.
select dbsname, tabname, dbinfo('dbspace',partnum) dbspacename
from sysmaster:systabnames
where dbsname = "somedatabasename";
> ''how can I get --using sql commands-- which dbspace is consuming an
> specific database?
>
> and more important
select dbsname, tabname, sum(size) total_pages
from sysmaster:sysextents
where dbsname = "somedatabasename"
group by 1,2;
> ''how can I get the amount of disk on that dbspace which is consuming
> that database? including data, index, store procedures and so on.
>
> Thanks in advance for your guide.
No problem.
> --Nestor Gomez
>
sending to informix-list