Tab navigation
- Overview
- Objectives- selected tab,
- Test preparation
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to plan, install, configure, troubleshoot, administer and maintain an IBM InfoSphere Optim Data Growth, Optim Decommissioning, Test Data Management, or Test Data Management with Data Privacy option on a Distributed System.
Section 1 - Installation and Configuration (25%)
- Optim Architecture
- Operating Systems/Hardware support
- Database Support
- Establishing Environments
- Optim Directories (location, numbers, owners)
- Confirming installation pre-reqs
- Physical installations
- Security
- Initializing
- Enabling
- Configuring
- Archive / Extract Maintenance
- File locations/sub-systems
- File naming / sizing
Section 2 - Optim Core Functionality (35%)
- Data Growth
- Archive
- Delete
- Restore
- Decommissioning
- Test Data Management
- Extract / Insert
- Edit
- Compare
- Data Privacy Functions (when to use which ones)
- Convert
- Privacy Functions
- Access Definitions
- Relationships
Section 3 - Advanced Topics (34%)
- Enterprise Integration
- Security
- Storage
- Automation (i.e. Command Line)
- Import/Export OPTIM DDL
- Archive Files (i.e., location, collections, moving, registering, creating, managing index files)
- Optim Connect
- Archive Collections
- Archive Indexes
- Archive File Maintenance
- Complex Data Model Traversals
- Extended Data Sources
- InfoSphere Federation Server
- Optim Connect
- Non-Enforced Referential Integrity
- Column Maps and Exits
Section 4 - Performance and Troubleshooting (6%)
- Log Files, Trace Files and Statistical Reports
- Relationships (i.e., delete strategy, OPTIM relationships, Forced Key/Scan Lookups, Scans, Threads)
- Relationship Index Analysis

