Kurs informasjon: Using InfoSphere Optim Core Technology on Dist Systems

This course combines the materials of the course, InfoSphere Optim Data Growth for Archiving for Dist Systems (DT203), with the course, Using InfoSphere Optim Test Data Management and Data Privacy for Dist Systems (DT213), and eliminates duplicated material. Thus, anyone taking just the course, InfoSphere Optim Data Growth for Archiving for Dist Systems (DT203), would leave at the end of Day 3. The material on Day 4 extends the knowledge gained with data growth to the additional areas of test data management and data masking/data privacy.

This course is designed to provide technical end-users and DBAs with a foundation in the functionality basics of the Optim solution. This course provides both a conceptual understanding of data growth as well as an understanding of Optim solution's capabilities for managing data growth and improving the performance of critical business applications. It also provides a conceptual understanding of the management of test data and de-identifying data for privacy protection and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim solution's business value, features, and functionality.

The focus of the combined course is hands-on experience building relationally intact subsets of data (both as Archive files and Extract files) and working with them in standard data growth, test data management, and data masking/data privacy scenarios. This course provides technical users with the Optim knowledge and skills necessary to participate in Optim implementation projects and confidently perform Optim tasks that apply the technology to a variety of business scenarios.

Throughout the course, you will participate in both instructor-led, hands-on labs, and self-paced labs which apply business scenarios.

View this course in other countries

Roadmaps:

• Optim Test Data Management Solution (and Data Masking) for Distributed Systems – End User V8.1
• InfoSphere Optim Data Growth for Distributed Systems – End User V8.1

Til top

This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing data growth management, test data management, and data masking/ privacy using IBM Optim.

Til top

You should be able to:

• Access to the internet for download of software
• Use basic Window functionality
• Discuss basic relational database concepts and objects, such as tables, indexes, views, and joins
• Construct and use basic SQL statements

Til top

• Describe how data growth impacts mission critical applications
• Demonstrate how the Optim solution supports a data growth strategy
• Explain how the Optim solution fits into the architectural landscape
• Explain how the archiving process works and planning considerations
• Describe the purpose of the Optim Directory and the objects it contains
• Create access definitions and table specifications
• Define selection criteria
• Archive data from a source database
• Delete data from a source database
• Create tables from an archive file
• Insert and load data from an archive file
• Restore data to a target database or storage device
• Implement Optim archive actions
• Maintain the archive indexes and directory entries
• Define Optim Primary Keys and Optim relationships
• Traverse relationships to access the tables in the order needed to archive the data
• Run an archive process from the Command Line Interface
• Use some of the most frequently-used options in a Command Line Interface
• Retry or restart an Optim process
• Schedule an Optim process
• Import and export objects from the Optim Directory
• Describe the benefits of existing security versus Optim Security
• Define best practices for implementing Optim
• Create collections of archived data
• Access archived data through the Open Data Manager (ODM)
• Discuss how the Optim Solution supports a test data management and data masking strategy
• Describe how the Optim Extract process works
• Transform and mask confidential data including, but not limited to, social security numbers, credit card information, e-mail addresses, and telephone numbers
• Describe how the convert process works
• Discuss how to use Optim Compare to compare Extracts of single and multiple tables of data with other Extracts or existing tables
• Describe how to insert masked data to a target database
• Describe how to compare multiple sets of data
• Use Optim masking techniques to modify a wide variety of personal and confidential data

Til top

• Introduction to IBM Optim
• Optim Architecture
• The Optim Directory
• Access Definitions and Table Specifications
• The Archive Process
• The Delete Process
• The Create Utility
• The Insert and Load Processes
• The Restore Process
• Defining Optim Primary Keys and Relationships
• Traversing Relationships
• The Command Line Interface
• Optim Utilities
• Optim Security
• Optim Implementation Best Practices
• Archive Files Collections and Open Data Manager (ODM
• The Extract Process
• The Convert Process
• The Compare Process
• The Edit Process
• Column Map Procedures and Exit Routines
• InfoSphere Optim Data Masking/ Privacy Workshop

Til top