Full tablespaces; delayed garbage collection?

Troels Arvin

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

Subscribe Post Reply

1582

shenanwei

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

Knut Stolze

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

Troels Arvin

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

Troels Arvin

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

Similar topics

Force garbage collection on a process

by: Ganesh | last post by:

Is there a utility by microsoft (or anyone) to force garbage collection in a process without have access to the process code. regards Ganesh

.NET Framework

Garbage collection?

by: Rick | last post by:

Hi, My question is.. if Lisp, a 40 year old language supports garbage collection, why didn't the authors of C++ choose garbage collection for this language? Are there fundamental reasons behind...

C / C++

Python reliability

by: Ville Voipio | last post by:

I would need to make some high-reliability software running on Linux in an embedded system. Performance (or lack of it) is not an issue, reliability is. The piece of software is rather simple,...

Python

Garbage Collection

by: Bob lazarchik | last post by:

Hello: We are considering developing a time critical system in C#. Our tool used in Semiconductor production and we need to be able to take meaurements at precise 10.0 ms intervals( 1000...

C# / C Sharp

Garbage collection

by: mike2036 | last post by:

For some reason it appears that garbage collection is releasing an object that I'm still using. The object is declared in a module and instantiated within a class that is in turn instantiated by...

Visual Basic .NET

C++0x Garbage Collection

by: Goalie_Ca | last post by:

I have been reading (or at least googling) about the potential addition of optional garbage collection to C++0x. There are numerous myths and whatnot with very little detailed information. Will...

C / C++

Garbage Colletor

by: Johnny E. Jensen | last post by:

Hellow I'am not sure what to think about the Garbage Collector. I have a Class OutlookObject, It have two private variables. Private Microsoft.Office.Interop.Outlook.Application _Application =...

C# / C Sharp

350

Do you use a garbage collector?

by: Lloyd Bonafide | last post by:

I followed a link to James Kanze's web site in another thread and was surprised to read this comment by a link to a GC: "I can't imagine writing C++ without it" How many of you c.l.c++'ers use...

C / C++

158

Garbage collection in C++

by: pushpakulkar | last post by:

Hi all, Is garbage collection possible in C++. It doesn't come as part of language support. Is there any specific reason for the same due to the way the language is designed. Or it is...

C / C++

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA