Establishing a Test Environment

This section describes how to design a test data structure and how to fill tables with test data.

Designing a Test Data Structure

When you test an application that accesses DB2 data, you should have DB2 data available for testing. To do this, you can create test tables and views. For information on the DDL to create tables and views, refer to Chapter 2.

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. To create a test table, you need a database and tablespace. Normally, a database administrator (DBA) can make sure that a database and tablespaces are available for your ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.