dbtutraffic

This is a test driver, which can be used to generate different kinds of (unusual) traffic within a DB2 database.

>>--- dbtutraffic --- --database ALIAS -------------->

 >---+-----------------------+--- --testcase NAME ---><
     |                       |
     +--- --schema SCHEMA ---+

Syntax diagram

Before you can do the first run of dbtutraffic, you need to create the database objects. The DbtuTools package contains a script (please check the defaults section within the dbtutraffic.ddl file first):

db2 connect to <ALIAS>
db2 -tf dbtutraffic.ddl

Sample commands

The alias of the database (ALIAS) - to connect to - is a must. The table schema (SCHEMA) is optional. If not applied, the tool will do unqualified table accesses. The testcase (NAME) parameter specifies the test case, which should be run:

• "DEADLOCK" = Update sequence against five single records. At the beginning of every sequence a randomizer is used to define the processing order (ascending or descending). Running multiple instances of this test case will case a lot of deadlocks.
• "OVERFLOW" = Within one sequence the randomizer chooses one of 10000 records and checks if it already exists (if not, the record will be created). The records VARCHAR field (with a max. of 3000 characters, starting with 10 characters) will be read and extended by 10 characters. That way, the table will fragment very fast due to the large amount of overflow records.

Once the tool is started, it runs in a loop till an unexpected error occurs, or the user ends it by pressing Ctrl+C.