Manual configuration of database tables

The managed Liberty server attempts to create the necessary transaction log tables on the configured database when the server first starts. If it cannot create tables on that database, the server fails to start. If you want to use a database that the server cannot automatically create transaction log tables for, you can create the tables manually by using Data Definition Language (DDL) statements.

Although the server can automatically create tables on a PostgreSQL database, you can adapt DDL structures to create tables on databases that Open Liberty does not automatically support.

The following example DDL structures show how to create the database tables on a PostgreSQL database:

CREATE TABLE OL_TRAN_LOG (
SERVER_NAME VARCHAR(128),
SERVICE_ID SMALLINT,
RU_ID BIGINT,
RUSECTION_ID BIGINT,
RUSECTION_DATA_INDEX SMALLINT,
DATA BYTEA)

CREATE TABLE OL_PARTNER_LOG (SERVER_NAME VARCHAR(128),
SERVICE_ID SMALLINT,
RU_ID BIGINT,
RUSECTION_ID BIGINT,
RUSECTION_DATA_INDEX SMALLINT,
DATA BYTEA)

The following DDL structures show how to create indexes for these tables:

CREATE INDEX IXOLTRAN_LOG ON OL_TRAN_LOG ( RU_ID ASC, SERVICE_ID ASC, SERVER_NAME ASC)

CREATE INDEX IXOLPARTNER_LOG ON OL_PARTNER_LOG ( RU_ID ASC, SERVICE_ID ASC, SERVER_NAME ASC)

For more information, consult the documentation for your chosen database.