You should consider modifying your application to use some of these features, 

which are different to MySQL:

Concurrency

Locking

Isolation level

Transactions

Logging

National language support

2.4.5  Basic administration

There are regular maintenance works the database administrator performs. 

These administration issues should be considered during migration planning. 

Every database has its own way for backup and recovery, as these are vital 

tasks in database administration. The database should be backed up regularly, 

and the data retention period should be defined based on the business 

requirements.

If you have backup and recovery tasks defined on the source system, you 

probably want to migrate these tasks as well. Be sure to port any existing scripts 

for backup tasks to support DB2 UDB.

Both the database backup and recovery functions should be tested to ensure a 

safe environment to your application.

Log files

DB2 UDB logs differently than MySQL, so database administrators should be 

aware of the logging level that can be set, where log information is stored, and 

how to read these logs.

Find more information in Chapter 8,  Database administration  on page 235.

2.4.6  Testing and tuning

Once your new system is up and running, you have to verify that data and 

application functionality have been ported completely, and that system behavior 

has not changed in a way you do not want.

If you succeed with this step, you might tune your database in order to speed up 

your application.

60 

MySQL to DB2 UDB Conversion Guide