Troubleshooting

The following table contains possible solutions to the common problems that you may encounter while using the SDB creator tool:

Error

Action

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;