Which table gives me Tablesize or tablespace size.

brainstorms · #1 (**permalink**) 01-01-05, 06:16

Hi,
Can somebody tell me which system table gives me the actual Size of the tablespace? I need it for programmatically allocating spaces...
thanks
Vijay S

przytula · #2 (**permalink**) 01-02-05, 08:37

for dms : db2 list tablespaces show detail --> size of ts
for sms : same command will show the current size
in sysibm.systables wil give an idea of active pages if runstats up-to-date
best regards, Guy Przytula

brainstorms · #3 (**permalink**) 01-04-05, 00:59

I ran this command in db2 command line window.. (Db2 for OS/390 Ver 7.1)

It says "SQL1651N The request cannot be executed because the DB2 server version does not support this functionality."
when I say C:\> db2 list tablespaces show detail

Any clue?
Thanks ...

przytula · #4 (**permalink**) 01-04-05, 01:13

It was not indicated which target platform..
this command was for db2 udb ...
have a look at npages in sysibm.systables that gives nbr of pages allocated for this table .. do sum(npages) group by tbspace
Hope this will help
Best Regards, Guy Przytula

Internet Services

Web Development

Digital Marketing

Consumer Tech