How does one get V8 Tablespace Utilization? Control center on V8FP3 DB does not give Size used, Allocated size,percentage used, maximum ever used as was given in V7 DB? Which system table has these values? Does anybody have an equivalent SQL?

If your tablespace is DMS, use this command "list tablespaces show detail", else, view the space in the folder in win.

For explample:
SMS:
------------------------------------------------
db2 => list tablespaces show detail

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 11661
Useable pages = 11661
Used pages = 11661
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 16
Number of containers = 1
--------------------------------

for DMS:
----------------------------------
Tablespace ID = 5
Name = TBATTRIB
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 7680000
Useable pages = 7679920
Used pages = 295248
Free pages = 7384672
High water mark (pages) = 6144016
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 8
Number of containers = 5
-----------------------------


Abel.