Home
Rational® Integration Tester
Tester Guide
This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
Technical Tester Guide
Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
Creating and running performance tests
This topic describes how to create, configure, and run performance tests.
Troubleshooting: Running a performance test with a MySQL database
You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

Rational® Integration Tester
- Release Notes
  This document contains information about What's new, installation, known issues, and contact information of IBM Support.
- System Requirements
  This document includes information about hardware and software requirements for IBM® Rational® Integration Tester.
- Getting Started
  This guide provides an overview and describes the tasks to get you started with Rational® Integration Tester.
- Administrator Guide
  This guide describes how to install Rational® Integration Tester. After you install the software, you can perform administration tasks such as configuration and integration of the product. This guide is intended for administrators.
- Tester Guide
  This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
  - Integration Tester Guide
    This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing. This guide is intended for Integration testers.
  - Technical Tester Guide
    Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
    - Creating and running performance tests
      This topic describes how to create, configure, and run performance tests.
      - Before creating performance tests
        Agents (Rational® Integration Tester Agent) are required on the computers that will run IBM® Rational Integration Tester tests and the probes that monitor the systems.
      - Creating performance tests
        A performance test is created within a Rational® Integration Tester project.
      - Performance tests
        Performance tests are executed in Rational® Integration Tester in the same way and from the same perspectives as any other test resource.
      - Troubleshooting: Running a performance test with a MySQL database
        You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.
    - View test results
      This topic describes how to work with IBM® Rational® Performance Test Server charts in the Results Gallery perspective.
    - Deploying probes
      A Rational® Integration Tester probe measures variables from a particular component in the system and reports back its findings for processing and storage.
  - Tester Guide - Service Virtualization
    This guide describes the tasks that you can perform for using virtual services or stubs to simulate parts of an environment if the real services are not yet available or because they are difficult or expensive to use. This guide is intended for Integration Testers.
- Test Manager Guide
  This guide describes the tasks that you can perform for tracking the quality of the application. This guide is intended for Test Managers.
- Troubleshooting
  While working with Rational® Integration Tester, you might encounter some problems that you can easily troubleshoot.
- Reference Guide
  This guide provides the topics to help the Integration tester use the product by using the user interface, commands or scripts. This guide is intended for Integration testers.
- Security Considerations
  You can take certain actions to ensure that your installation is secure, customize your security settings, and set up user access controls.
- Notices
  This document provides information about copyright, trademarks, terms and conditions for product documentation.

Troubleshooting: Running a performance test with a MySQL database

You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

About this task

If you are using MySQL version 5.7 or later, the SQL mode ONLY_FULL_GROUP_BY is enabled by default. This mode must be removed, otherwise, when you run a performance test from Rational® Integration Tester with a MySQL database, an error is reported for the GROUP BY clause.

To remove this mode, follow these steps:

Procedure

For Windows or Linux follow these steps:
1. Edit the MySQL configuration file my.ini on Windows or my.cnf on Linux. Set the sql_mode parameter from a command line in one of two ways:
```
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  
```
```
sql_mode=""
```
2. Restart the MySQL server.

For Ubuntu follow these steps:

Create the following file:

/etc/mysql/conf.d/disable_strict_mode.cnf

Edit the file. Copy and paste the following command into the disable_strict_mode.cnf file to set the sql_mode parameter:

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart the MySQL server.
```
sudo service mysql restart
```

Check that the mode was removed:

<mysql> select @@sql_mode

The result shows you the following:

STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION