Re: Database Size
"Carlson@WHSmith" wrote:
>
> If you're in IDS 7.x, you could
>
> database sysmaster;
> select tabname, nptotal*2 size_K
> from sysptprof p, sysptnhdr h
> where dbsname = <database name>
> and p.partnum = h.partnum
or this one:
SELECT SUM ( ( nptotal * sh_pagesize) / 1024) kBytes
FROM sysptprof p, sysptnhdr h, sysshmvals
WHERE dbsname = <database name>
AND p.partnum = h.partnum;
Markus
>
snip