By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

space utiilization in a DMS tablespace

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a


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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.