Configuring the OpenEdge 11.3.0 database

Migrating to OpenEdge 11.7

Migrating OpenEdge Business Process Management : Savvion 7.6.X/8.0 to Progress OpenEdge 11.3.0 Migration Process : Migrating to OpenEdge 11.3.0 : Database migration : Configuring the OpenEdge 11.3.0 database

After converting your OpenEdge Release 10 database to an OpenEdge 11 database, you must configure your OpenEdge 11 for the OpenEdge Developer Studio 11.3.0 installation.

To configure the OpenEdge 11 database:

1. Go to the database directory. Open a text file and insert the following content in it:

-db oebps
-s 8910
-n 150
-Mn 5
-Mi 1
-bibufs 25
-L 32000
-B 10000
-schlockwg
-SQLStmtCache 200

Name the text file oebps.pf and then save it.

Note: From Savvion 7.6.x/8.0 releases, the default database name is sbmdb.

2. Open a text file and insert the following content in it:

PROSQL_LOCKWAIT_TIMEOUT=302
sql_env
proserve -pf oebps.pf

Name the text file db.cmd (for Windows) or db.sh (for UNIX) and then save it.

3. Start the OpenEdge 11.3.0 database by executing the following command:

startdb.sh

Note: In UNIX, you must change the mode and then execute the startdb.sh command.

4. Configure the database using the Database Configuration Tool wizard:

In Windows, select Start > All Programs > Progress > OpenEdge 11.3 > BP Server > Tool > Database Configuration Tool.

In UNIX, execute the following script available at $DLC/oebpm/server/bin:

DBConfigTool.sh

5. Follow the Database Configuration Tool wizard to complete configuring the OpenEdge 11.3.0 database.

Ensure that the Database name is the same as what you chose earlier, that is, oebps.

For more information about the options in the wizard, see the Database Configuration Tool section in Progress OpenEdge Business Process Server: Server Administrator's Guide.