space utiilization in a DMS tablespace

Rahul B

Hi,

How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespaces, but it doesn't seem to give me that
information.

Thanks

Rahul

Sep 6 '07 #1

Phil Sherman

Rahul B wrote:

Hi,

How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespaces, but it doesn't seem to give me that
information.

Thanks

Rahul

You can try looking at the number of active pages if your statistics are
current.

Phil Sherman

Sep 6 '07 #2

Rahul B

On Sep 6, 7:37 pm, Phil Sherman <psher...@ameritech.netwrote:

Rahul B wrote:

Hi,

How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespaces, but it doesn't seem to give me that
information.

Thanks

Rahul

You can try looking at the number of active pages if your statistics are
current.

Phil Sherman

Can you please elaborate a bit on that?

Rahul

Sep 6 '07 #3

Ian

Rahul B wrote:

Hi,

How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespaces, but it doesn't seem to give me that
information.

Look at a tablespace snapshot.

Either, 'get snapshot for tablespaces on <yourdb>' or you can use the
SYSIBMADM.SNAPCONTAINER administrative view.

Sep 6 '07 #4

Ian

Ian wrote:

Rahul B wrote:

>Hi,

How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespaces, but it doesn't seem to give me that
information.

Look at a tablespace snapshot.

Either, 'get snapshot for tablespaces on <yourdb>' or you can use the
SYSIBMADM.SNAPCONTAINER administrative view.

Oops, SYSIBMADM.SNAPCONTAINER doesn't have this information. You want
SYSIBMADM.SNAPTBSP_PART.
Ian

Sep 6 '07 #5