Consultor Eletrônico



Kbase P63060: How to add transaction log areas to a version 9 database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   1/16/2004
Status: Unverified

GOAL:

How to add transaction log areas to a version 9 database.

FIX:

To enable 2phase commit, transaction log extents must be added to the database structure.

To add transaction log areas create an add.st with extents of the proper size to handle the activity expected.

The add.st file should contain lines similar to those shown below.
Format is <extent type> <path-dbname.extent#> <fixed> <size>
#
t ./db-name.t1 f 1280
t ./db-name.t2 f 1280

With the database down run the following to add the 2phase transaction log areas:

prostrct add <db-name> add.st