Salesforce

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

« Go Back

Information

 
TitleTemp-Tables with field of type CLOB causes DBI to grow excessively
URL Name000031426
Article Number000151137
EnvironmentProduct: 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 NumberDefect 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:
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:39 AM

Powered by