DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop - Seminare

Seminar-Ziel

Continue developing your Federated Database management skills with this challenging hands-on experience that includes monitoring, tuning, and troubleshooting a Federated Database environment. Learn the configuration options for all supported DB2 UDB and DB2 Information Integrator data sources and how to tune the Federated Server for maximum Federated Database performance.

Complete hands-on exercises between DB2 UDB for Windows, DB2 UDB for z/OS and OS/390, DB2 UDB for AIX, Microsoft SQL Server, and Oracle databases are included. Using a preconfigured server, you will further optimize a five-way join between these data sources while exploring your tuning and problem determination options.

Teilnehmer Zielgruppe

This course is appropriate for database administrators; application programmers; data warehouse administrators; systems architects; consultants; -Business, business intelligence, application integration, systems integration professionals, and all other professionals with an interest in architecting, planning, administering, monitoring, tuning and constructing an Integrated Data Warehouse and/or OLTP solution.

Kurs Voraussetzungen

Knowledge about DB2 Federated Database with DB2 Information Integrator: Up and Running

Seminar-Inhalt

• Secure a Federated operational environment for your individual systems and application integration project needs
• Describe the tuning, operational and security related options for Federated Servers, nicknames and individual mapped columns
• Use the Federated Server from a DRDA requester (z/OS, OS/390 or iSeries applications) 
• Recognize key factors that influence query performance in a integrated federated database environment 
• Use DB2 Explain and DB2 monitoring tools to expose federated database performance problems

Literatur

nach Absprache

[ Zurück ]