467,189 Members | 1,308 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

space utiilization in a DMS tablespace

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
  • viewed: 1785
Share:
4 Replies


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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Oliver Stratmann | last post: by
5 posts views Thread by N | last post: by
5 posts views Thread by Yasaswi Pulavarti | last post: by
3 posts views Thread by randi_clausen@ins.state.il.us | last post: by
1 post views Thread by Raja Shekar | last post: by
9 posts views Thread by mike_dba | last post: by
3 posts views Thread by James | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.