Home > Vendors > IBM > dt812g

DT812G - InfoSphere Optim Test Data Management and Data Masking on z/OS


Duration: 4.0 days

The IBM Optim Data Privacy Option course is designed to enable you to successfully develop and execute a data privacy strategy to de-identify sensitive data. This course provides a conceptual understanding of the data privacy issue, as well as the Optim Solutions capabilities for de-identifying data and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim Solutions features, and functionality. 

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. You will learn the basics of how the technology works through hands-on exercises illustrating how the technology applies to business scenarios. This course does not include information on how to install and configure the technology. 

This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim privacy implementation project and confidently perform Optim tasks ongoing.


  • Extract relational subsets of data from a database
  • Choose the appropriate privacy functions to mask sensitive data
  • Use the Compare function to verify your privacy strategy
  • Insert privatized data to a target database
  • Use the Optim relational editor to verify the inserted data
  • Select the correct relationship traversal options for your data model
  • Define Optim Relationships and Primary Keys, if needed
  • Export and Import Optim Directory objects
  • Identify the factors that affect Optim performance


This basic course is for Privacy Project Leaders and project team members who will be responsible for implementing and executing a data privacy strategy for one or more applications. This would include application developers, business analysts, and DBAs who have been assigned to your privacy project.


Unit 1: Introduction to IBM Optim Solutions 

Unit 2: The Optim Directory 

Unit 3: Introduction to Test Data Management

  • Exercise 01: Getting Started

Unit 4: Extract the Data 

  • Exercise 02: Extract the Data to be Privatized

Unit 5: Create Database Objects 

  • Exercise 03: Create Database Objects

Unit 6: Basic Masking Techniques (Convert) 

  • Exercise 04: Use Basic Masking Techniques

Unit 7: Use Compare to Validate Your Changes

  • Exercise 05: Use Compare to Validate Your Changes

Unit 8: Populate the Destination Tables 

  • Exercise 06: Insert and Load the Destination Tables

Unit 9: Retry or Restart an Optim Process 

Unit 10: Edit and Browse Test Data 

  • Exercise 07: Edit and Browse Test Data

Unit 11: Optim Primary Keys and Relationships 

  • Exercise 08: Create Optim Primary Keys and Relationships

Unit 12: Relationship Traversal Concepts 

  • Exercise 09: Traversing Relationships

Unit 13: Export and Import Optim Directory Objects 

  • Exercise 10: Export and Import Optim Directory Objects

Unit 14: Optim and Legacy Data 

  • Exercise 11: Extract Legacy Data

Unit 15: Batch Utilities 

  • Exercise 12: Use Batch Utilities

Unit 16: Optim Security Overview 

Unit 17: Performance Considerations 

Unit 18: Special Masking Functions 

  • Exercise 13: Use the Special Masking Functions


  • DB2 and relational database concepts
  • DB2 SQL basics
  • TSO/ISPF editing commands and job output retrieval functions


This course is not associated with any Certification.


Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy