Kursbeskrivning: Using Optim Data Growth for Archiving on Dist Systems

This course is designed to provide technical end-users and DBAs with a foundation in the functionality basics of the InfoSphere Optim Data Growth solution. This course focuses on the technical aspects of the Optim solution and is intended for technical audiences. Students will use Optim technology working through hands-on practice on 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.

This course is designed to introduce the attendee to IBM Optim and to Optim's capabilities in helping clients to manage data growth. Students will use Optim processes to archive, delete, browse, restore, load, and insert data. They will also learn to use Open Data Manager (ODM) to access archived files and perform management activities.

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, hands-on exercises will be used to check the attendee's progress.

This course uses IBM InfoSphere Optim Data Growth Solution V9.1 on distributed systems.

Visa den här kursen i andra länder

Roadmaps:

• InfoSphere Optim Data Growth for Distributed Systems - End User V9.1
• InfoSphere Optim Data Growth for Distributed Systems – End User V8.1

Tillbaka till toppen

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.

Tillbaka till toppen

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

Tillbaka till toppen

• Discuss how the Optim Solution supports a test data management and a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Discuss how to define selection criteria
• Describe how the Optim archive process works
• Set personal and product options
• Define selection criteria
• Describe to define Optim relationships and Optim keys
• Archive data from a source database
• Delete data from a source database
• Restore data to a target database or storage device
• Create table maps and column maps
• Search and browse archived data
• Describe how to implement Optim archive actions
• Use the File Maintenance Facility to split, hold, and expire archive files
• Describe how to define Optim relationships and Optim primary keys
• Use the command line interface to run Optim processes
• Use the Optim utilities to backup and reload the Optim Directory
• Use the Optim utilities to schedule Optim jobs
• Discuss the security options available with Optim
• List best practices for Optim implementation
• Describe how to create collections of archived data
• Describe how to access archived data through the Open Data Manager (ODM)

Tillbaka till toppen

• Introduction to IBM Optim
• Optim Architecture
• Optim Common Elements
• Access Definitions and Table Specifications
• The Archive Process
• The Delete Process
• The Create Utility
• The Insert and Load Processes
• The Restore Process
• More Archive Functions
• Optim Primary Keys and Optim Relationships
• Traversing Relationships
• The Command Line Interface
• Optim Utilities
• Optim Security
• Optim Implementation Best Practices
• Archive Collections and Open Data Manager (ODM)

Tillbaka till toppen