#11 behaviour of -q, --quick-run switch should be changed

[Nikita]

-q should accept have many records to generate per table (if nothing is supplied the argument should default to 1). this will allow the user to test more types of schemas using this switch (if DG generates only 1 record per table, chances are, some of the problems [foreign keys] will not manifest themselves].

[Michael]

specifying -q with any value doesn't set the table size. Tables are still generated according to the size specified in row_count in the XML file

db2inst1@ubuntu-school:~/DG-test/DG/dist$ java -jar DG.jar -q 1 -d ./data/schemas/movie-merged.xml
0 [main] INFO com.ibm.dg.DataGenerator - Data Generator started. Version: 0.3 Revision: fd7d1b7d3d38 tip
App config file:
/home/db2inst1/DG-test/DG/dist/config.xml
DB config file:
/home/db2inst1/DG-test/DG/dist/data/schemas/movie-merged.xml
24 [main] FATAL com.ibm.dg.DataGenerator - Can't connect to the database: com.ibm.db2.jcc.DB2Driver. Exiting.
25 [Thread-0] WARN com.ibm.dg.DataGenerator - Shutting down.
db2inst1@ubuntu-school:~/DG-test/DG/dist$ cp /home/db2inst1/myDG/DG_M/lib/db2jcc.jar ./lib/
db2inst1@ubuntu-school:~/DG-test/DG/dist$ java -jar DG.jar -q 1 -d ./data/schemas/movie-merged.xml
0 [main] INFO com.ibm.dg.DataGenerator - Data Generator started. Version: 0.3 Revision: fd7d1b7d3d38 tip
App config file:
/home/db2inst1/DG-test/DG/dist/config.xml
DB config file:
/home/db2inst1/DG-test/DG/dist/data/schemas/movie-merged.xml
4170 [main] INFO com.ibm.dg.DataGenerator - Schema meta information:
Title: Movie Database Schema
Description: This is one part of the movie database.
Schema version: 1
DBMSVersion: DB2 9.7

4170 [main] INFO com.ibm.dg.DataGenerator - Running pre-run commands.
4170 [main] INFO com.ibm.dg.DataGenerator - Running "Create DB"
5230 [main] INFO com.ibm.dg.DataGenerator - Command's output: create database moviesSQL1005N The database alias "movies" already exists in either the local database directory or system database directory.
5601 [main] INFO com.ibm.dg.DataGenerator - No datasources defined, proceeding
5601 [main] INFO com.ibm.dg.DataGenerator - Starting the timer.
5601 [main] INFO com.ibm.dg.DataGenerator - Starting loading data sources.
=======
5602 [main] INFO com.ibm.dg.DataGenerator - Starting to load data source files.
5606 [main] INFO com.ibm.dg.DataGenerator - Completed in: 00:00:00
5606 [main] INFO com.ibm.dg.DataGenerator - Starting loading tables.
=======
7096 [main] INFO com.ibm.dg.DataGenerator - Running pre-generation commands.
7097 [main] INFO com.ibm.dg.DataGenerator - Running pre-generation commands completed in: 00:00:00
7097 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table.
This table will have 10000 row(s).
Threads: 1, with around 10000 row(s) per thread.
Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)
======
398 18.3 KB 79 3.7 KB
770 35.4 KB 77 3.5 KB
1,167 53.6 KB 77 3.6 KB
...
8,823 405.1 KB 80 3.7 KB
9,230 423.8 KB 80 3.7 KB
9,634 442.4 KB 80 3.7 KB
10,000 459.3 KB 80 3.7 KB
10,000 459.3 KB 80 3.7 KB
137410 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table completed in: 00:02:10