DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop

start > courses and registration > training feature sheet

This course has been upgraded to:

»	U5789 WebSphere Information Integrator Federated Workshop

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

DW490

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$1,250

IACET credits 1.6

Continue developing your management skills by 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, further optimize a four-way join between these data sources while exploring tuning and problem determination options.

This course is appropriate for professionals working with DB2 UDB, DB2 Information Integrator and DiscoveryLink DB2 Federated Technology applications.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an advanced course for database administrators, application programmers, Data Warehouse (DW) administrators, system architects, and consultants. Business Intelligence (BI), e-business, application integration, and system integration professionals. It is also for other professionals with an interest in architecting, planning, and constructing an Integrated DW or Online Transaction Processing (OLTP) solution.

prerequisites

You should complete:

	DB2 Federated Database with DB2 Information Integrator: Up and Running (DW480)
	OR have implementation experience with either DB2 UDB or DB2 Information Integrator Federated databases

skills gained

	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 Distributed Relational Database Architecture (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

this course has been combined

Note: This course has been combined with:

? Federated Database with DB2 Information Integrator: Up and Running (DW480)

into a single five day course:

? DB2 Information Integrator Federated Workshop (U5789)

Please refer to U5789 for additional details and to check the course schedule.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Advanced

course content details

	Course Content Outline

	Introduction and review
	Security: federated server
	Server, nickname, and column options
	Federated catalog tables
	The federated DRDA application server
	Tuning the federated environment