IBM - IBM Optim Core Technology for Distributed Systems

KURSZIEL
IBM - IBM Optim Core Technology for Distributed Systems: Zielgruppe
This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data growth management solution using the IBM Optim.
From Optim Data Privacy for Distributed Systems (DT211): This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data privacy solution using the IBM Optim Data Privacy Solution.
Kursziele

• How data growth impacts mission critical applications
• How the Optim solution supports a data growth strategy
• How the Optim solution fits into the architectural landscape
• How to install Optim on both a workstation and server
• How the archiving process works and planning considerations
• How to set personal options
• How to define selection criteria
• How to define Optim relationships and primary keys
• How to archive data from a source database
• How to delete data from a source database
• How to restore data to a target database or storage device
• How to create table maps and column maps
• How to search and browse archived data
• How to implement Optim archive actions
• How to use custom exits
• How to retry or restart an Optim process
• How to schedule an Optim process
• How to create collections of archived data
• How to access archived data through the Open Data Manager (ODM)
• Discuss how data privacy concerns impact mission critical applications
• Discuss how the Optim Solution supports a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Describe how the Optim Extract process works and how it differs from Archiving
• Use Optim to create new tables and load those tables with data
• Describe how to 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 to define Optim Relationships and Optim Keys
• Describe how to insert masked data to a target database
• Describe how to compare multiple sets of data
• Transform and mask confidential data including, but not limited to, social security numbers, credit card information, e-mail addresses, and telephone numbers

ZIELGRUPPE
Zielgruppe
This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data growth management solution using the IBM Optim.
From Optim Data Privacy for Distributed Systems (DT211): This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data privacy solution using the IBM Optim Data Privacy Solution.
Kursziele

• How data growth impacts mission critical applications
• How the Optim solution supports a data growth strategy
• How the Optim solution fits into the architectural landscape
• How to install Optim on both a workstation and server
• How the archiving process works and planning considerations
• How to set personal options
• How to define selection criteria
• How to define Optim relationships and primary keys
• How to archive data from a source database
• How to delete data from a source database
• How to restore data to a target database or storage device
• How to create table maps and column maps
• How to search and browse archived data
• How to implement Optim archive actions
• How to use custom exits
• How to retry or restart an Optim process
• How to schedule an Optim process
• How to create collections of archived data
• How to access archived data through the Open Data Manager (ODM)
• Discuss how data privacy concerns impact mission critical applications
• Discuss how the Optim Solution supports a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Describe how the Optim Extract process works and how it differs from Archiving
• Use Optim to create new tables and load those tables with data
• Describe how to 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 to define Optim Relationships and Optim Keys
• Describe how to insert masked data to a target database
• Describe how to compare multiple sets of data
• Transform and mask confidential data including, but not limited to, social security numbers, credit card information, e-mail addresses, and telephone numbers

KURSINHALT
This course replaces Implementing Optim Core Technology Workshop for Distributed Systems (DT291)
This course combines the material of Optim Data Growth for Distributed Systems (DT201) with Optim Data Privacy for Distributed Systems (DT211), and eliminates any material from DT211 taught on Days 4 and 5 that was already covered in DT201 in Days 1 through 3. Thus, anyone taking just DT201 would leave at the end of Day 3. The optional Unit on Data Security (Unit 28) can be taught after Unit 21 on Day 3, or later in the course in the numerical sequence presented in the materials.
IBM Optim Data Growth for Open Systems 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 the Optim solution's capabilities for managing data growth and improving the performance of critical business applications. This course serves as a foundation for the Optim solution's business value, features, and functionality.
Optim Data Growth for Distributed Systems (DT201) focuses on the technical aspects of the Optim solution and is intended for technical audiences. Participants will install and configure Optim and experience a breadth of Optim core functionality. Students will use Optim technology, working through hands-on practice and how to apply the technology to business scenarios.
This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing. During the course, students will participate in both instructor-led, hands-on labs and self-paced labs which apply business scenarios.
This course is designed to introduce the attendee to IBM Optim and to Optim's capabilities in helping clients to manage data growth. Data management basic concepts, functionality and GUI used to implement test data management. Students will use Optim Archive, Optim Delete, Optim Browse, Optim Insert, and ODM to produce archived files and perform management activities. Students will examine scheduling and running processes from the command line. Students will also see how Optim can be used to work with tables in a cross-database environment. Hands-on exercises and checkpoint questions will be used to check the attendee's progress.
From DT211: Optim Data Privacy for Distributed Systems is a three-day course designed to provide technical users with a foundation in the functionality basics of the Optim Solution. This course provides both a conceptual understanding of data privacy as well as the Optim Solution's capabilities for 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.
This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. The focus of the course is hands-on experience building relationally intact subsets of privatized data and creating Optim primary keys and Optim relationships which permit cross database extraction of data. Participants will learn the basics of how the technology works through hands-on practice and how to apply the technology to business scenarios, including installation and configuration.
This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing.
This course is designed to teach the attendee the IBM Optim Data Privacy Solution basic concepts, functionality and GUI used to implement a data privacy solution. Hands-on exercises and checkpoint questions will be used to check the attendee's progress.
Themenübersicht
Day 1

• Unit 1: Introduction to IBM Optim
• Unit 2: Managing Data Growth
• Unit 3: Optim Architecture
• Unit 4: Optim Installation
• Unit 5: The Optim Directory
• Unit 6: The Archive Process
• Unit 7: The Delete Process

Day 2

• Unit 8: Multi-Byte Character Support
• Insert and Load
• Unit 10: The Restore Process
• Archive Lab #1
• Unit 11: The Create Process
• Archive Lab #2
• Unit 12: Defining Optim Primary Keys and Relationships
• Unit 13: Traversing Relationships
• Unit 14: Archive Actions
• Archive Lab #3
• Unit 15: Custom Exits

Day 3

• Unit 16: Restart/Retry
• Unit 17: Archive Directory
• Unit 18: Export/Import
• Unit 19: The Command Line Interface
• Unit 20: Scheduling
• Archive Lab #4
• Unit 21: Archive Collections
• Unit 22: Using ODM

Day 4

• Unit 23: Securing Private Information
• Unit 24: The Extract Process
• Exercise 5: Extract
• Unit 25: The Edit Process
• Exercise 6: Edit
• Exercise 7: Edit (Part 2)

Day 5

• Unit 26: Convert
• Exercise 8: Extract
• Unit 27: Compare
• Exercise 9: Compare
• Exercise 10: Extract
• Unit 28: Optim Security
• Unit 29: Optim Data Privacy Workshop

VORRAUSSETZUNG
You should be able to:

• Use basic Window functionality
• Discuss basic relational database concepts and objects, such as tables, indexes, views, and joins
• Construct and use basic SQL statements