Consultor Eletrônico

Status: Verified

SYMPTOM(s):

The DBI file size is much bigger after upgrading to OpenEdge

The size of the DBI file is much bigger in OpenEdge 10

In OpenEdge 10.x the DBI file is a few hundred K blocks for the same application code

A temp table in OpenEdge increases the size of the DBI file much more than in Progress version 9

FACT(s) (Environment):

The session DBI file in Progress 9.x is typically a few K blocks in size
All Supported Operating Systems
OpenEdge 10.x

CAUSE:

The cause of this is because the DBI file utilizes Type II Storage Areas in OpenEdge 10.
As such the allocation of the DBI file uses clusters in OpenEdge instead of blocks, and subsequently the DBI file uses much more disk space.


The size of the DBI file can be estimated. It should be about 9 blocks * # of ACTIVE temp tables. (unless any one temp table contains more than 8 blocks of data).

Also, be aware that, the default block size of the temp tables has changed in OpenEdge 10.1B from 1K to 4K.
This is to support the new large index key entries feature. So, if there are no plans to use large index key entries, then request a 1K temp table block size by specifying -tmpbsize 1 on client startup.

FIX:

This is expected behavior.

To reduce the size of the DBI file use the client startup parameter -tmpbsize set to 1.