DB2 Tuning and Performance

King Training Resources
Littleton, Colorado, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Recommended Duration:
5 Days
Version
DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also. CICS TS Version 2.4. Class is suitable for earlier versions fo CICS.
Benefits
The student will learn how to tune applications that use the DB2 environment, as well as design data bases to minimize the use of system resources
Audience
Technical personnel who need to optimize the performance of a DB2 application system.
Prerequisites
Students should have 6 months recent experience in designing and coding application programs using SQL in DB2, in one or more application environments (CICS, IMS/DB/DC, TSO, or batch) in which DB2 is used and recent experience using ISPF/PDF, especially the text editor and should be able to code JCL to run simple batch jobs or completed the "DB2 Application Programming" course within the last 12 months. Major Topics
DB2 architecture
Application program tuning
Access Strategies
EXPLAIN and PLAN_TABLEs
Indexable, Stage 1, and Stage 2 predicates
Catalog tables and filter factors
Join and subquery access strategies
BIND parameter considerations
Concurrency and locking
Batch and Utility issues
Security issues and strategies
Sequential and list prefetch
Attachment facility issues
RCT parameters and Thread reuse
Data base design considerations
DB2 traces and Instrumentation Facility
DB2 system parameters
MVS, OS/390 issues
...''

Phone:800-252-0652 or 303-798-5727

School Address:

Peggy King
King Training Resources
6341 South Williams Street
Littleton, Colorado 80121-2627 USA


Jobs & Resumes: Littleton
Houses & Roommates: Littleton

Search other schools for DB2 Tuning and Performance training resources.

Developer 10g/9i Forms
Developer 10g/9i Reports
DB2 UDB Programming
DB2 UDB Database Administration
DB2 UDB SQL Coding
SQL Coding Workshop
DB2 Application Programming
QMF for Programmers
DB2 Database Administration
DB2/CICS Interface
Oracle for Experienced SQL Developers
C on z/OS
Object-Oriented Concepts
C++ on z/OS
Data Modeling
UML
Structured COBOL Workshop for Enterprise COBOL
VSAM for COBOL Programmers
Structured COBOL Workshop

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.