After Reorg space is not reclaimed

[Lyn Duong]

Hi

Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.
However the tablespace pages used counter is not decreasing at all. In
fact it's increasing.

I've done a reorgchk also. What else could the problem be??

Thanks in advance
Lyn

[Anton Versteeg]

Are you sure you deleted all table data?
Perhaps there are indexes in there from tables that still contain data?

Lyn Duong wrote:

Hi

Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.
However the tablespace pages used counter is not decreasing at all. In
fact it's increasing.

I've done a reorgchk also. What else could the problem be??

Thanks in advance
Lyn

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Ian]

Lyn Duong wrote:

Hi

Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.
However the tablespace pages used counter is not decreasing at all. In
fact it's increasing.

Are you sure you're not looking at the tablespaces' high water mark?

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Lyn Duong]

Hi

No, I've cleaned out absolutely everything.
What I then did was disconnected everyone from the database and
reactivated it. Then the pagesize went down.

Thanks
Lyn

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

Lyn Duong wrote:

Hi

Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.
However the tablespace pages used counter is not decreasing at all. In
fact it's increasing.

Are you sure you're not looking at the tablespaces' high water mark?

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Fan Ruo Xin]

I assumed that you got "used pages" through tablespace snapshot.
There is a trick I just learned. You can use LIST TABLESPACES SHOW DETAIL if
you need to ensure extents that are 'pending delete' are actually freed -:)
"Lyn Duong" <ly**@tablimited.com.au> wrote in message
news:8d**************************@posting.google.c om...

Hi

No, I've cleaned out absolutely everything.
What I then did was disconnected everyone from the database and
reactivated it. Then the pagesize went down.

Thanks
Lyn

Ian <ia*****@mobileaudio.com> wrote in message

news:<40**********@corp.newsgroups.com>...

Lyn Duong wrote:

Hi

Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.
However the tablespace pages used counter is not decreasing at all. In
fact it's increasing.

Are you sure you're not looking at the tablespaces' high water mark?

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----