This course is intended to instruct you on the installation and use of IBM InfoSphere Optim Performance Manager Extended Edition and includes hands-on labs. You should be able to describe the features and key components of IBM InfoSphere Optim Performance Manager Extended Edition. Preliminary steps, including sizing for hardware and software are also taught. Detailed use of the various dashboards are covered, using several problem scenarios. Maintenance and troubleshooting techniques will be addressed, as well as the method to work with technical support.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

• Describe the uses of federation technology
• Use the DB2 Control Center to define wrappers, servers, user mappings, and nicknames
• Recognize key factors that influence query performance
• Explain key concepts of SQL support including compensation, passThru, and datatype and functional mappings
• Explain the major security issues for protecting the federated environment

This basic course is developed for Federation Server Version 9.5. Learn Federation concepts and describes how to configure a federated database for accessing relational and non-relational data sources. Configuration involves defining wrappers, servers, and nicknames for linking to remote data sources. This course discusses access to both relational and non-relational data sources.

You should have:

• Basic knowledge of relational database administration for an RDBMS such as DB2, Oracle, or SQL Server
• Knowledge of SQL
• Knowledge of how relational databases are used within a business

• What is Federation
• How it works
• Usage scenarios
• Architecture
• Wrapper
• Server
• Nicknames
• User mappings
• Security issues
• Relational data source access
• SQL support
• Compensation
• PassThru
• Datatype, function mappings
• Non-relational data source access
• Performance and optimization