Before installing a new business process application, use this to add an additional index or row locking to the database.
For example, if your Table.ddl file contains the following definition:
create table ORDERPROCESS20030101T0000001 (CORRELATIONSETTHEONEANDONLY2 VARCHAR(100) null, ID1 NUMERIC(19, 0) not null, ID2 NUMERIC(19, 0) not null) GOYou must change it to look like the following:
create table ORDERPROCESS20030101T0000001 (CORRELATIONSETTHEONEANDONLY2 VARCHAR(100) null, ID1 NUMERIC(19, 0) not null, ID2 NUMERIC(19, 0) not null) LOCK DATAROWS GO
For example, if your correlation set is represented by two columns (C1 and C2) and the generated Table.ddl file looks like the following:
CREATE TABLE MYPROCESS20040801T0000001 (C1 INTEGER NULL, C2 VARCHAR(100) NULL, ID1 INTEGER NOT NULL, ID2 INTEGER NOT NULL);you must add an index for columns C1 and C2, by adding the following line to the file: CREATE INDEX MYPROCESS_C1C2 ON MYPROCESS20040801T0000001 (C1, C2);