Information

Title	Temp-Tables with field of type CLOB causes DBI to grow excessively

URL Name	000031426

Article Number	000151137

Environment	Product: OpenEdge Version: 11.0x OS: All supported platforms

Question/Problem Description

Temp-Tables with field of type CLOB causes DBI to grow excessively

In OpenEdge 11.0 Temp-Tables with field of type CLOB causes DBI file to grow excessively (sometimes over 10Gb) exhausting disc space.

The behavior is not observed under OpenEdge 10.2B.

Steps to Reproduce

Clarifying Information

Delayed temp-table instantiation feature was introduced in version 11.0

Error Message

Defect Number	Defect OE00220533 / PSC00243992

Enhancement Number

Cause

The instantiation of a CLOB's storage object is done in a separate routine from temp-table.
While the temp-table's instantiation is marked as delayed, the LOB storage object is still instantiated.
As a result, the temp-table`s CLOB storage object is not being deleted when the temp-table instantiation is marked delayed, causing DBI file size to increase.

Resolution

Upgrade to OpenEdge 11.1.0. Where instantiating temp-table's LOB objects is skipped when the temp-table is marked as delayed, then the LOB object is instantiated along with the instantiation of the delayed temp-table

Workaround

Disabling the delayed temp-table instantiation feature alleviates the symptoms.
Start the session with parameter -nottdelay For further information refer to Article:

What is the -nottdelay startup parameter ?

Notes

Keyword Phrase

Last Modified Date	11/20/2020 7:39 AM