iSeries Database Load Description

A simple script (createdb.sh) is used to call a Java program (CreateSPECDB.class) which sets up the database using the default schema supplied in the SPECjAppServer2001 kit.  This program executes a series of statements through JDBC. First it executes “create collection spec” to create the database and to start journalling.  Then the program reads and executes the SQL statements included with the SPECjAppServer2001 kit.  The default schema files as well as the script and Java program are included in the Full Disclosure Archive /schema and /schema/sql directories.

Any additional indexes not included in the default schema are added manually after the load program completes.  These indexes are listed the submission file's "Schema Modifications" section.
