Concurrent invocation of the SDB creator tool fails when the output
database files are not specified at the command-line.
|
This error occurs because the tool tries to write concurrently in a
single database file. It is due to the limitation of the DBMS database engine.
The DBMS database engine runs each SQL statement in a single transaction, which
occupies the entire cluster of the database. Hence, large SQL files can create
huge database files before compaction and the tool fails because of file size
restrictions imposed by file system. The tool should use -o switch
to specify output database name.
To resolve this error, use transactions in the .sql
schema file. The following is an example for the .sql schema file:
example schema --------------- BEGIN; create table test (T1 INTEGER, T2 CHAR(10), T3 FLOAT, T4 LONG VARBINARY);
insert into test (T1, T2, T3, T4) VALUES (17, '1s', 1.1, X'CAFEBABE' );
insert into test (T1, T2, T3, T4) values (20, 'ooo', 5.5, X'CAFEBSAA' ); . . . update test set T1=18 where T3=5.5; COMMIT;
|