Creating Test Data with Data Manager

We highly recommend that you review the sample sessions and perform the tutorials contained in the Getting Started with z/OS Data Stores section of the Data Manager documentation available within Enterprise Test Server. These help you to quickly gain a concise understanding of how you can use Data Manager to mask and/or reduce mainframe data.

The following is based on the exercises presented in the Getting Started with z/OS Data Stores section. It gives specific guidance on how to mask and subset four mainframe DB2 tables, and then generate transformed sequential files that can be moved into SQL Option for DB2.

For the purposes of this discussion, assume that preliminary tasks of importing JCL job streams and creating DB2 tablespace and tables have already been done, and that the tables exist and are populated in the z/OS environment.

Note: For detailed information on how to perform these tasks, review the subsections Importing JCL Job Streams Into Your Mainframe Environment and Creating the DB2 Tablespace and Tables in the Getting Started with z/OS Data Stores section of your Data Manager documentation.

The table names are based on a small banking application:

Table Name	Description
CUSTOMER	Customer information
ACCOUNT	Account information
CCARD	Credit card information
OPERAT	Credit card operations information

The table definitions are:

CREATE TABLE DELGT.CUSTOMER
(COD_CUS                CHAR(10)            NOT NULL WITH DEFAULT,
 NAME                   CHAR(40)            NOT NULL WITH DEFAULT,
 SURNAME                CHAR(40)            NOT NULL WITH DEFAULT,
 DATE_OF_BIRTH          CHAR(08)            NOT NULL WITH DEFAULT,
 PLACE_OF_BIRTH         CHAR(50)            NOT NULL WITH DEFAULT)

CREATE TABLE DELGT.ACCOUNT
(COD_CUS                CHAR(10)            NOT NULL WITH DEFAULT,
 OFF_NUM                DECIMAL(5)          NOT NULL WITH DEFAULT,
 ACC_NUM                DECIMAL(10)         NOT NULL WITH DEFAULT,
 AMOUNT                 DECIMAL(12)         NOT NULL WITH DEFAULT)

CREATE,TABLE DELGT.CCARD
(OFF_NUM                DECIMAL(5)          NOT NULL WITH DEFAULT,
 ACC_NUM                DECIMAL(10)         NOT NULL WITH DEFAULT,
 CARD_TYPE              CHAR(1)             NOT NULL WITH DEFAULT,
 CARD_NUM               CHAR(16)            NOT NULL WITH DEFAULT,
 AVAILABILITY           DECIMAL(25)         NOT NULL WITH DEFAULT,
 EXP_DATE               CHAR(8)             NOT NULL WITH DEFAULT)

CREATE,TABLE DELGT.OPERAT
(CARD_TYPE              CHAR(1)             NOT NULL WITH DEFAULT,
 CARD_NUM               CHAR(16)            NOT NULL WITH DEFAULT,
 ACCOUNT_OPER           DECIMAL(25)         NOT NULL WITH DEFAULT,
 DATE_OPRT              CHAR(8)             NOT NULL WITH DEFAULT)

The following topics guide you through the procedure: