Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
DB2 Connect to DB2 for OS/390: Problem Determination and Performance
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CF632   length. 4 days
type. Instructor-Led   partner. IBM
price.
$2,600  
 
 
Learn about problem and performance issues that can occur within a distributed database environment. Learn how to start, use, and interpret output results from monitoring and problem determination tools available on the various platforms. Work with Windows clients, Windows and UNIX DB2 Connect servers, and DB2 for OS/390 servers. Both TCP/IP and Systems Network Architecture (SNA) network configurations are provided and addressed.
 
course schedule  
 
Phoenix, AZ mar.9.2009 - mar.12.2009 register register
Santa Clara, CA mar.9.2009 - mar.12.2009 register register
El Segundo/Los Angeles, CA mar.9.2009 - mar.12.2009 register register
Englewood/Denver, CO mar.9.2009 - mar.12.2009 register register
     
   
Request another training Date Request onsite training
 
who can benefit
  
 
This is an advance course for DB2 database administrators, system administrators, systems engineers or system implementers, or communications specialists responsible for distributed database configuration and implementation, problem determination and performance in a DB2 Connect to DB2 for z/OS environment.
 
prerequisites
  
 
Before taking this course, you should have:

Completed the DB2 Connect DRDA Implementation with TCP/IP course
A working knowledge of DB2 Connect
A working knowledge of DB2 for z/OS
Experience with Windows or UNIX operating systems
Basic knowledge of TCP/IP networking concepts
 
skills gained
  
 
After completing this course, you should be able to:

Design a DB2 Connect DRDA environment and describe the data flow
Use the problem determination and monitoring tools available on the various platforms
Analyze problem information in a distributed database environment, identify the location of the problem, and determine the cause of the problem
Analyze the output of problem determination and monitoring tools, and determine where performance bottlenecks exist
 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Pack - online account
 
course materials
  
 
The course materials cover DB2 9 Connect, DB2 9 for Linux, UNIX, and Windows and DB2 for z/OS Version 8.
 
hands-on labs
  
 
Eight labs are included to address using DB2 9 Connect.





 
course content details  
 


  Architecture

Design multitier configurations
Explain the difference between DB2 Connect and DB2 ESE
List TCP/IP Networking options
Describe supported Host Attachment options
Perform initial sizing of components




  Problem Determination Overview

Describe the data flow within a DB2 Connect environment
Develop a problem determination methodology




  Client Monitoring and Problem Determination

List monitoring and problem determination tools available on a DB2 Client
Interpret the db2 diagnostic log with the db2diag tool
Capture SQLCA information in the db2diag.log
Benchmark queries with the db2batch tool
Configure the db2cli.ini file
Start and format a db2trc, a CLI trace, or a Java trace
Parse a CLI trace or a Java trace
Enable the Java application monitor
Examine the contents of a bind file
Interpret Visual Explain output
Explain UNICODE and CCSID conversions




  DB2 Connect Monitoring and Problem Determination

Configure DBM CFG and DB2 Connect Registry variables
List DCS applications
SNAPSHOT DCS data
View error logs
Trace DB2 Connect internal processing and DRDA flow
View performance data
Use the db2pd tool to monitor and troubleshoot DB2 Connect
Explain the DB2 Connect Process Model




  Network Monitoring and Problem Determination

Run and interpret the TCP/IP PING command
Run and interpret the PATHPING command
Run and interpret the DB2 PING command
Run and interpret the TCP/IP TRACEROUTE command
Run and interpret the TCP/IP NETSTAT command
Locate TCP/IP network configuration settings
Capture a TCP/IP trace




  DB2 for z/OS Monitoring and Problem Determination

Minimize TCP/IP network failures
Configure DB2 for z/OS configuration parameters
Use and interpret the DISPLAY DDF command
Use and interpret the DISPLAY THREAD command
Use and interpret the DISPLAY LOCATION command
Use and interpret the DISPLAY DATABASE command
Start Accounting, Statistics, and Performance traces




  Problem Determination Analysis

Identify and resolve connection problems
Use trace data to capture performance information
Identify performance bottlenecks
Identify and resolve hung thread problems
Identify and resolve security problems




  Performance Tuning

List application programming and client performance recommendations
Identify DB2 Connect performance recommendations
Specify DB2 for z/OS performance recommendations
List TCP/IP performance recommendations
Examine local versus remote access times
Determine how block size affects performance
Describe the benefits of HiperSocket technology
Tune agents' parameters to work with connection concentrator
Enable automatic client reroute configuration
Improve detection of client failures using TCP/IP keepalive settings




  Problem Reporting

Collect environment related information
Collect problem related information
Package information to transmit to the Support Center




  Agenda - Day 1

Welcome
Unit 1 - Architecture
Lab 1 - Capacity Planning and DB2 Connect Connectivity
Unit 2 - Problem Determination Overview
Lab 2 - Problem Determination Overview and Setup
Unit 3 - Client Monitoring and Problem Determination




  Day 2

Lab 3 - Client Monitoring and Problem Determination
Unit 4 - DB2 Connect Monitoring and Problem Determination
Lab 4 - DB2 Connect Monitoring and Problem Determination
Unit 5 - Network Monitoring and Problem Determination




  Day 3

Lab 5 - Network Monitoring and Problem Determination
Unit 6 - DB2 for z/OS Monitoring and Problem Determination
Lab 6 - DB2 for z/OS Monitoring and Problem Determination
Unit 7 - Problem Determination Analysis
Lab 7 - Problem Determination Analysis




  Day 4

Lab 7 - Problem Determination Analysis
Unit 8 - Performance Tuning
Unit 9 - Problem Reporting
Lab 8 - Problem Reporting



 
Free Chumby with IBM Training

Save on IBM Training



find a course
 
phone us
 
view course schedule





Organize your IT training. Contact an expert training consultant to put together the best training package for your organization.

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware