Consultor Eletrônico

Before-image size limit 2GB

INTRODUCTION
============
This Technical Support Notebook entry describes a design limit
in Progress database versions 6, 7 and 8.

WHY YOU NEED TO KNOW THIS
=========================
Customers get errors and may corrupt the before-image of database
if they hit this limit. An error that might indicate hitting the
limit is
SYSTEM ERROR: rlbird called with invalid address=<number>. (866)

This error causes the database to shutdown abnormally. The
before-image file might be unusable and other recovery procedures
must be used.

One possible cause is doing a schema change to a very big database
table. The schema changes done with dictionary tools are done
in single transaction. In this case, you need to split the changes
to multiple smaller ones. If you are adding an index to a large
table, add the index deactivated and activate it with index
rebuild utility (Idxbuild does not use before-image). The same 2GB
limit is for temporary sort files also, so turn off index sorting
in index rebuild.

References to written documentation
===================================
V6 System Administration II
V7 and V8 System Administration Guide and Reference

--
1996-06-19

Progress Software Technical Support Note # 15846