Training

Popular Courses

IBM

MICROSOFT

Enterprise Architecture (EA)

SOA

Java/Java EE

Cloud Computing

Agile

Mobile computing

SCHEDULED CLASSES

COURSE
MAP

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

VIRTUAL CLASSROOMS

ROOM RENTALS

Contact Training Sales

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

 

Home > Training > DB2 >

WA1296 DB2 UDB Performance and Tuning for Unix and Windows Training and Courseware

This course is designed to review the concepts and components of DB2 for UNIX and Windows. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops. Performance and tuning issues will be reviewed.
Objectives
  After completing this course the student should be able to:
  • Code SQL to improve performance.
  • Use DB2 EXPLAIN tools to evaluate performance expectations.
  • Design application programs to improve performance and review with EXPLAIN tools.
  • Use the tool DB2BATCH to benchmark applications.
  • Improve performance through parallelism
  • Review data placement to improve performance.
  • Tune registry variables and configuration parameters to effect performance.
  • Use DB2 monitor tools to assist in performance tuning.
  • Use performance improving options for DB2 utilities
Target Audience
  Database administrators, programmers and data designers who are responsible for tuning DB2 for performance
Prerequisites
 
  • Relevant Operating Systems experience (AIX or Windows) along with knowledge of relational database theory, SQL and programming.
  • Previous experience of using DB2 or similar relational databases is required.
Duration
  Three days.

Course Outline

There is no detailed outline for this course at this time.
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
More Details
Outline Course Outline
Buy This Course

Buy on-site and customized class

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.