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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved