Looking for DB2 Command

[TSch]

Hi folks,

I'm looking for a db2 command to determine the current space allocation (in percent) of a certain tablespace ...

Any ideas ?

Thanks in advance !

Regards
Thomas

 

[gregsimpson]

Thomas,

do either of these help, altjough I have ignored the percent part of your request.

db2 list tablespace containers for 0 show detail

Tablespace Containers for Tablespace 0

Container ID = 0
Name = /db2dat/db2insxx/NODE0000/SQL00007/SQLT0000.0
Type = Path
Total pages = 498
Useable pages = 498
Accessible = Yes
Container ID = 1
Name = /db2dat/db2insxx/NODE0000/SQL00007/SQLT0000.1
Type = Path
Total pages = 433
Useable pages = 433
Accessible = Yes
Container ID = 2
Name = /db2dat/db2insxx/NODE0000/SQL00007/SQLT0000.2
Type = Path
Total pages = 500
Useable pages = 500
Accessible = Yes


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 = 5393
Useable pages = 5393
Used pages = 5393
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 10