Workload Multiuser Driver
From db2mc
Contents |
General Information
The Workload Multiuser Driver (WMD) is a RESTful web service, using an embedded Jetty server. The WMD allows multiple users to run multiple user definable workloads concurrently against a DB2 database and can be controlled through the Technology Explorer (TE). Many settings such as the number of active connections to the database can be increased or decreased on-the-fly.
New Features
(see here for more details on using the features)
- Run report available if run-limiter is used
- Random character generation within statements can use custom characters
- Miscellaneous connection properties can be defined
- Miscellaneous group names in distribution and Task Set
- Client think-time can adjust to previous elapsed think-time intervals
- Workloads can be automatically stopped or unloaded if not being accessed
- Metrics logging to DB now multi-threaded for performance
- Connection Profile and Task Set can be defined inline within the Workload Profile
- Workload memory manager (stop/unload workloads after given time)
- Logging metrics data to a table (options: batch update, log frequency, schema name, table name, connection)
- Simulated client count ramp-up
- Record metrics per statement within blocks
- Reset metrics data after a restart
- Nested blocks in Task Set
- Enhanced randomness (block repeats, reconnection time)
- New parameter datatypes (clob, blob, sqlxml)
- Global parameter variables
- Unique parameter variables
- Multi-column file input for bind parameters
- Customizable metrics smoothing and timestamp formatting
Prerequisites
- DB2
- Minimum install requires the DB2 client libraries
- JRE 1.6 or greater (JRE 1.6 is already included with DB2)
- Java must be set in the classpath or the scripts will need to be changed to explicitly call the target JRE
- TE v4.2
Installation and Set-up
- Download the latest WMD package from https://sourceforge.net/projects/db2mc/files/WMD/4.2
- Unpack appropriate zip/gzip file to a preferred location (such as C:/ or /home/user)
- Place the db2jcc.jar or db2jcc4.jar file (JCC Driver) in the "lib/db_driver" directory of the WMD. The JCC driver can commonly be found from within the /sqllib/java/ of an IBM DB2 installation or you can download it from IBM DB2 jcc driver download site.
- Ensure you are using a JVM of version 1.6 or greater by running java -version from the command line. The output should be similar to this:
C:\> java -version java version "1.6.0" Java(TM) SE Runtime Environment (build pxi3260sr5-20090529_04(SR5)) IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr5-20090519_35743 (JIT enabled, AOT enabled)
- WMD can be run in a console mode or can be installed as Windows service or Linux daemon.
- [Optional] Customize access level for TE and the WMD (by default set to private access only which means that access is restricted to localhost)
For instructions on setting up a build environment, see here.
Upgrading
The easiest and quickest way to upgrade the WMD to the latest version is
- download the latest WMD package from the sourceforge WMD download page and unpack it
- replace your existing .dtd files found in <WMD_HOME>/config_files/xml_definitions/ with the new files from the package
- replace your existing WMDApp.war file found in <WMD_HOME>/lib/ with the new file from the new package
- restart the WMD
Creating New Workloads or Customizing Existing Ones
To create new workloads you will need to create a new set of WMD XML configuration files for the WMD service user.
