Planning for and designing DB2 applications

Before you write or run your program, you need to make some planning and design decisions. These decisions need to be made whether you are writing a new DB2® application or migrating an existing application from a previous release of DB2.

About this task

If you are migrating an existing application from a previous release of DB2, read the application and SQL release incompatibilities and make any necessary changes in the application.

If you are writing a new DB2 application, first determine the following items:

  • the value of some of the SQL processing options
  • the binding method
  • the value of some of the bind options

Then make sure that your program implements the appropriate recommendations so that it promotes concurrency, can handle recovery and restart situations, and can efficiently access distributed data.