Data Express for z/OS Tutorials

These tutorials show you how to prepare your Data Express working environment in z/OS and introduce the Data Express Windows client, which consists of three Data Express modules: Data Builder, Data Masking, and Data Subset Extraction. Follow the tutorials in this guide in order after you have completed your product installation.

The easiest way to learn about Data Express is to complete a few simple tasks. This guide takes you through configuring Data Builder, loading metadata into the Data Express Knowledge Base, using Data Masking to implement masking rules on a small amount of data, using Data Subset Extraction to create a simple subset of data, and finally using Data Subset Extraction twice more to create subsets of data using referential integrity. Please note that some of the data reduction examples also mask data, showing that Data Express can do both functions in one method invocation.

The three modules, Data Builder, Data Masking, and Data Subset Extraction, and tutorial files contain all the tools you need to perform these tasks.

This tutorial describes the process of configuring your z/OS environment so that you can use the Data Express Windows client (as demonstrated in subsequent tutorials) for data masking and data reduction.

Machine IDs and Company Codes

A Machine ID and Company code pair is essentially an identifier for your Data Express working environment or workspace. The Machine ID is the higher-level identifier, while the Company code must be identified by a Machine ID. You can create a new Machine ID and a new Company code for each test environment, or you can create new Company codes under a single Machine ID as needed for each test environment you want to create.

Note: A single machine ID can correspond to numerous company codes. A new company code can be created only if an existing machine ID is first selected.

Sample Data

Data Express includes the files that create the sample DB2 tables and sequential files that are used throughout the exercises in this tutorial . The database and its sample tables must be created and populated after product installation.

Note: The JCL job streams, files, and scripts needed to create your tutorial environment are located in the tutorial folder of your installation directory.

In this session, you load data needed for this tutorial into your mainframe environment and you use Data Builder to define your workspace. This involves editing several files, executing programs, creating a machine ID and company code pair for your workspace, and submitting jobs that will load information into your mainframe environment from external files.

You can follow the tutorials for either DB2 data stores, sequential files or both DB2 data stores and sequential files.