Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Los Angeles, CA
Minneapolis, MN
Oakbrook, IL
Oklahoma City, OK
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
Course Schedule: | |
DB2 V9 Performance and Tuning for Programmers
Summary:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables. This course covers differences between versions 7 & 8 of DB2 UDB.
Duration:
3 Days/Lecture & Lab
Audience:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables.
Topics:
- Application Tuning
- SQL Statements That Can Affect Performance
- EXPLAIN Function
- Simple and Complex Access Paths
- Index Structure, Design and Usage
- DB2 Buffer Pools and Their Impact on Performance
Prerequisites:
Students must have experience coding in one of the programming languages listed: COBOL, PL/I or C. Students must also have experience in TSO/ISPF and DB2 file structures.
Last Update: May 21, 2013
