Tablespace space problem

chansteve1234 · #1 (**permalink**) 03-03-04, 05:52

If there are any view or tools to check how many space(MB) left at the tablespace???
thx very much

sathyaram_s · #2 (**permalink**) 03-03-04, 07:43

Depends on what platform you are on ...

On Unix and Windows,

db2 list tablespaces show detail

will give you the result

Quote:

Originally posted by chansteve1234
If there are any view or tools to check how many space(MB) left at the tablespace???
thx very much

archm · #3 (**permalink**) 03-03-04, 08:34

Quote:

Originally posted by sathyaram_s
Depends on what platform you are on ...

On Unix and Windows,

db2 list tablespaces show detail

will give you the result

On a host under OS/390 check the VSAM-dataset the tablespace is stored in.

Under ISPF 3.4 look for the dataset and write a lct before it.
thean you see the extents.

Alternative you can do a query on sysibm.systablepart, there you got the information.

Internet Services

Web Development

Digital Marketing

Consumer Tech