ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

DB2 Connect 9 for DB2 for z/OS Problem Determination and Performance  (CF632)

Format: Formation en classe avec formateur
Autres formats:
 
 

This course is the classroom version of Instructor Led Online course (ILO) 3F632

This course is designed for the experienced DB2 system or database administrator, or network administrator responsible for the administration of a DB2 Connect to DB2 for z/OS environment. This course addresses problem and performance issues that can occur within a distributed database environment. Through lectures and labs, students will practice how to start, use, and interpret output results from monitoring and problem determination tools available on the various platforms.

Students will work with Windows clients, Windows DB2 Connect servers, and DB2 for z/OS servers. TCP/IP network configurations will be provided and addressed.

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.

Certification

Prepare for IBM Certification Test 734: DB2 9 Advanced Database Administrator for Linux, UNIX, and Windows.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 

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

Qui peut en profiter
 

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.

Préalables
 

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

Abstract
 

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.
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: CF632
Format: Formation en classe avec formateur
Durée: 4 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

DB2 Connect 9 for DB2 for z/OS Problem Determination and Performance  (CF632) Contenu détaillé
 
 
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


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI