10.3.2.0 RC - Additional tests

Large Data Volume

We have used the DOTS^* ATCJ4(a variant of the ATCJ2 auction simulation) schema and a database
filled to ~184 GB raw disk space.
The three DOTS tables used by ATCJ4 contain  ~300 million(ITEM), ~232 million(REGISTRY) and ~8 million(BID) tuples. See test info.
Tests on this volume includes 

The ATCJ4 test is run for 48 hrs.

• backup/recovery tests: 

  • SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE() backup on this volume, with concurrent load(ATCJ4) on the database. 

  • "rollForwardRecovery" of the database after having run the DOTS ATCJ4 for ~20 hrs. after backup.

• table consistency check(SYSCS_UTIL.SYSCS_CHECK_TABLE()).

• aggregate queries on the tables.

DOTS graphical presentation.

Longrunning Test

See LTT 10.3.2.0

* DOTS: see http://ltp.sourceforge.net/dotshowto.php ,
http://db.apache.org/derby/integrate/DOTS_Derby.htm ,
http://db.apache.org/derby/binaries/UsingDotsDerbySystemTest.pdf .
We have adapted DOTS to also run on other OS's than Linux.

** JDBC 3.0 CTS is part of the J2EE Technology Compatibility Kit (TCK).