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
Lansing, MI
Los Angeles, CA
Minneapolis, MN
Oakbrook, IL
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 Operations
Summary:
This course introduces students to the concepts of relational databases and the strengths of DB2. It covers the major components of DB2 and their fit into the OS/390 environment.
Duration:
2 Days/Lecture & Lab
Audience:
The course is designed for operation personnel who need to gain a better understanding of DB2 and its environment.
Topics:
- Constructs and Concepts
- How DB2 fits into the MVS environment
- Batch and On-line Execution
- Application SQL
- DB2 Catalog, Indexes, Optimizer and Security
- Batch and On-line Utilities
- Reliability in the Production Environment
- Performance Monitoring, Reporting and Tuning
Prerequisites:
Students should have a basic understanding of DB2 terminology and concepts.
Last Update: May 23, 2013
