documenting part can become overwhelming, so usually specialized software is 

used for those cases. As mentioned earlier, by definition, the new application 

cannot be fully tested. In the migration project, the application testing is an 

iterative process of planning, designing the test cases, executing the test cases, 

and finally evaluating and analyzing the results.

Together with various functional testing, the application should be checked also 

against performance. Since there are many architectural differences between 

MySQL and DB2 UDB, some SQL operations might require further optimization. 

Observing the performance differences on early testing stages increases the 

chance to prepare more optimal code for the new environment. 

Before going into production, the migrated database should be verified under 

high volume and loads. These tests should emulate the production environment, 

and can determine if further application or database tuning is necessary. The 

stress load can also reveal other hidden problems, like locking issues, which can 

be observed only in a production environment. 

9.3.2  Security testing

Before going into production, security must be checked in detail. MySQL handles 

security quite differently than DB2, so it is not trivial to compare the user rights 

between the two systems.

MySQL users and privileges are resolved in DB2 with operating system users 

and groups

. 

A list of MySQL users should be compared to the equivalent DB2 

operating system users. All of DB2's authorities should be verified to allow proper 

persons to connect to the database. Privileges for all database objects also 

should be verified.

9.3.3  Tools for testing and problem tracking

The software testing process can be a very complex task. All the tests should be 

synchronized with the development life cycle, and be well documented. For large 

projects, it might be necessary to use supportive software to improve testing 

productivity. IBM Rational Suite  TestStudio  can be used for that purpose.

IBM Rational Suite TestStudio is a set of tools for testers and developers. It 

automates regression, functionality, and performance testing, and provides 

background runtime analysis for increased product reliability. IBM Rational Suite 

TestStudio also includes tools for control, management, and reporting of all test 

activities, defect, and change tracking, software configuration management, and 

requirements management. IBM Rational Suite TestStudio addresses everything 

from test process standardization to results analysis, requirement determination 

to impact analysis, and test automation to defect tracking and reporting. 

276 

MySQL to DB2 UDB Conversion Guide