Designing a test data structure

• Test views of existing tables: If your application does not change a set of DB2 data and the data exists in one or more production-level tables, you might consider using a view of existing tables.
• Test tables: To create a test table, you need a database and table space. Talk with your DBA to make sure that a database and table spaces are available for your use.

  If the data that you want to change already exists in a table, consider using the LIKE clause of CREATE TABLE. If you want others besides yourself to have ownership of a table for test purposes, you can specify a secondary ID as the owner of the table. You can do this with the SET CURRENT SQLID statement.

If your location has a separate DB2 system for testing, you can create the test tables and views on the test system and then test your program thoroughly on that system. This information assumes that you do all testing on a separate system, and that the person who created the test tables and views has an authorization ID of TEST. The table names are TEST.EMP, TEST.PROJ and TEST.DEPT.