Consultor Eletrônico

Status: Verified

SYMPTOM(s):

Receive 3896 errors in dbanalys after converting a version 9 database to OpenEdge 10 database.

dbanalys in version 9 prior to convert has no errors.

database has a 1KB database block size.

DBKEY <number> w/free space less than <CREATELIM> found on RM chain. (3896)

dbkey=, free space=, # of free directories=, hold= (3865)

[Warning] DBKEY 21824 w/free space less than 75 found on RM chain. (3896)

Many 3865 errors for different areas in database during the Block Analysis portion of dbanalys.

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

CHANGE:

Converted database to OpenEdge 10 using conv910

CAUSE:

The Database Toss Limit (dbTossLim) is smaller in OpenEdge 10.
For a database with a 1 KB database blocksize in version 9:
dbTossLim is 250 bytes and in OpenEdge 10 dbTossLim is 150 bytes.
dbCreateLim is 150 bytes and in OpenEdge 10 dbCreateLim is 75 bytes.

FIX:

The Database Create Limit (dbCreateLim) and Database Toss Limit (dbTossLim) are two values the database manager uses to determine if a RM block needs to be kept on the RM chain or not.

For example; if the free space in a RMBLK is less than dbCreateLim, we cannot use it to insert any new record at all because it fails the minimum available free space requirement in a database block before a new record can be created in that block.

The 3896 errors occur because the dbTossLim is smaller in OpenEdge 10 (150 bytes in OE 10 and 250 bytes in V9). These are warnings indicating that the dbkey in the error contains free space that is below 250 bytes, the old tosslim. This is correct behavior and is not indicative of a problem.

If the warnings being reported were above 250 bytes for a database with 1 KB blocksize, then this would be perceived as a bug and should be reported to Technical Support for additional analysis.