Setting up a Testing Environment-IBM

DB2 Universal Database Version 8 is going out of support as of April 30, 2009. More details are available here: http://www.ibm.com/support/docview.wss?rs=71&uid=swg21370360

Setting up a Testing Environment

To validate your application, you should set up a test environment. For example, you need a database to test your application's SQL code.

Procedure To set up the test environment, do the following:

1. Create a test database. To create a test database, write a small server application that calls the CREATE DATABASE API, or use the command line processor.
   
2. Create test tables and views. If your application updates, inserts, or deletes data from tables and views, use test data to verify its execution. If the application only retrieves data from tables and views, consider using production-level data when testing it.
   
3. Generate test data for the tables. The input data used to test an application should be valid data that represents all possible input conditions. If the application verifies that input data is valid, include both valid and invalid data to verify that the valid data is processed and the invalid data is flagged.
   
4. Debug and optimize the application.

Related reference

• sqlecrea - Create database
• CREATE DATABASE Command

This topic can be found in: Application Development Guide: Programming Client Applications.