DB2 Connect DRDA Implementation with TCP/IP

start > courses and registration > training feature sheet

code.

CF601

length.

3.5 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

IACET credits 2.8

Learn to implement, administer, and tune DB2 Connect to DB2 UDB for z/OS Client/Server distributed relational database connections using the Distributed Relational Database Architecture (DRDA). Extensive lab exercises using DB2 Connect with TCP/IP connections to DB2 for UDB for z/OS are either on a Windows 2000 or AIX system.

Configure TCP/IP connectivity, DB2 UDB for Windows/UNIX, DB2 Connect, and DB2 UDB for z/OS to enable DRDA connections. Also, create a database manager instance, precompile and bind applications, and identify security, performance, and problem determination issues and solutions.

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 intermediate course for database and system administrators, system engineers and implementors, and communications specialists, who plan, configure, implement, and maintain Distributed Database connectivity or maintain a DB2 Connect to DB2 UDB for z/OS environment.

prerequisites

You should have working knowledge of Window 32-bit or UNIX operating systems and relational database systems.

skills gained

	Configure DB2 Connect as a DRDA application requester
	Configure DB2 UDB for Windows/UNIX as a DRDA Application Server (DRDA AS)
	Configure DB2 UDB for z/OS as a DRDA application requester and server
	Establish a TCP/IP connection between DB2 Connect and DB2 UDB for z/OS
	List application development considerations in a distributed database environment
	Precompile and bind an application that accesses distributed relational data on a DRDA server
	Implement a Distributed Unit Of Work (DUOW) application using two-phase commit processing
	Configure DB2 Connect for federated database support
	Implement security between a DRDA requester and server
	Perform basic problem determination in a distributed environment
	Perform basic performance tuning in a distributed environment

course materials

The course materials cover DB2 Connect Version 8.2 and DB2 UDB for z/OS Version 8.

hands-on labs

Seven labs are included to address planning for, implementing, and customizing a DB2 Connect server environment.

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

Intermediate

related courses, exams and materials

	after related training and products

CF632 DB2 Connect to DB2 for OS/390: Problem Determination and Performance

course content details

	DB2 Connect client/server environment

	position DB2 Connect in a DRDA environment
	list DB2 Connect packaging options
	describe DB2 Connect functions and supported configurations
	explain the DB2 Connect distributed flow

	Host TCP/IP connectivity

	describe TCP/IP concepts
	configure a DB2 UDB for z/OS system for TCP/IP communications
	describe the structure and function of the Communications Database (CDB)
	identify when changes to the CDB take effect
	list the requirements for remote Control Center administration of DB2 UDB for z/OS

	DB2 Connect customization

	create a DB2 Connect instance
	define DB2 Connect profile registry variables and system environment variables
	catalog DB2 Connect directories
	identify relationships between DB2 Connect definitions and z/OS and DB2 UDB for z/OS definitions
	establish TCP/IP connectivity between DB2 Connect and DB2 UDB for z/OS
	bind DB2 Connect utility programs to DB2 UDB for z/OS

	DB2 Connect enterprise client connectivity

	configure a DB2 Connect server to support remote client connections
	describe the DB2 UDB Administration Server (DAS)
	configure a client system to connect to a DB2 Connect server
	connect a client to DB2 UDB for z/OS through a DB2 Connect server

	Distributed application development and bind considerations

	discuss issues of developing applications that access relational database systems using DRDA's Remote Unit Of Work (RUOW)
	use remote bind error handling options
	create a remote package with appropriate precompile and bind options
	identify DB2 UDB for Windows/UNIX utilities for transporting data between platforms

	Multidatabase access

	describe the difference between RUOW and DUOW
	implement components involved in a two-phase commit
	explain type 1 versus type 2 connects
	explain one-phase versus two-phase syncpoint requirements
	configure DB2 Connect for federated database support

	Distributed security

	specify where authentication will occur
	implement DB2 client security options
	implement DB2 UDB for z/OS security options
	implement conversation level security
	specify bind privileges

	Distributed problem determination

	identify major distributed relational database problem types
	explain causes of each problem type
	describe the recommended problem determination techniques for each problem type
	identify major problem determination tools
	trace the DRDA flow through DB2 Connect

	Distributed performance considerations

	identify TCP/IP performance considerations
	configure DB2 Connect and DB2 UDB for z/OS parameters and options that affect performance
	describe application options that affect performance
	list ways to improve distributed performance

	DB2 UDB for Windows/UNIX DRDA AS using TCP/IP

	describe the DRDA AS function of DB2 UDB for Windows/UNIX
	configure DB2 UDB for Windows/UNIX as a DRDA AS supporting TCP/IP clients
	configure Distributed Data Facility (DDF) as a DRDA AR connecting to a DRDA AS using TCP/IP
	bind DB2 UDB for z/OS packages at a DB2 UDB for Windows/UNIX database