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

Full tablespaces; delayed garbage collection?

P: n/a
Hello,

I had a tablespace which ran out of space. Most of the tables contained in
the tablespace where then empitied, but the tablespaces kept being full
when viewed with "LIST TABLESPACES SHOW DETAIL", and users couldn't put
data in the (now empty) tables. Then, after some hours, LIST TABLESPACES
SHOW DETAIL showed lots of free pages, and users could use the tables
again.

Is this delay expected? If so: What triggers "garbage collection"? Is
there a way to manualle stimulate garbage collection?

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jan 24 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
try a reorg.

On Jan 24, 1:08 pm, Troels Arvin <tro...@arvin.dkwrote:
Hello,

I had a tablespace which ran out of space. Most of the tables contained in
the tablespace where then empitied, but the tablespaces kept being full
when viewed with "LIST TABLESPACES SHOW DETAIL", and users couldn't put
data in the (now empty) tables. Then, after some hours, LIST TABLESPACES
SHOW DETAIL showed lots of free pages, and users could use the tables
again.

Is this delay expected? If so: What triggers "garbage collection"? Is
there a way to manualle stimulate garbage collection?

--
Regards,
Troels Arvin <tro...@arvin.dk>http://troels.arvin.dk/
Jan 24 '07 #2

P: n/a
Troels Arvin wrote:
Hello,

I had a tablespace which ran out of space. Most of the tables contained in
the tablespace where then empitied, but the tablespaces kept being full
when viewed with "LIST TABLESPACES SHOW DETAIL", and users couldn't put
data in the (now empty) tables. Then, after some hours, LIST TABLESPACES
SHOW DETAIL showed lots of free pages, and users could use the tables
again.

Is this delay expected? If so: What triggers "garbage collection"? Is
there a way to manualle stimulate garbage collection?
Have you turned on automatic maintenance by any chance?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 25 '07 #3

P: n/a
On Wed, 24 Jan 2007 12:01:27 -0800, shenanwei wrote:
try a reorg.
OK, thanks; I'll try that next time.

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jan 25 '07 #4

P: n/a
On Thu, 25 Jan 2007 08:28:57 +0100, Knut Stolze wrote:
>Is this delay expected? If so: What triggers "garbage collection"? Is
there a way to manualle stimulate garbage collection?

Have you turned on automatic maintenance by any chance?
No, unfortunately, we don't use any automatic maintenance features,
currently. (Partly because DB2 DAS seems to clash with a system called
Centrify DirectControl.)

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jan 25 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.