Home   |   Instructor-led Training   |   Self-Paced Learning                Email Us   Phone :
Contact Us   -   About Us          
 
Courses
A+ training
ADA training
Adobe training
AJAX training
AutoCAD training
Business Skills and Technology training
C++ programming training
Cisco training
Citrix training
Cognos training
ColdFusion training
COM/COM+ training
CORBA training
Corel training
Crystal Reports training
Data Mining training
DB2 training
Desktop Application Software training
Enterprise Architecture training
ITIL training
Java training
JBoss training
Legato training
Lotus training
Macintosh training
Mainframe programming training
Microsoft / MCT training
MS Access training
MultiMedia and design training
.NET training
Network+ training
Object oriented analysis and design training
Oracle training
Perl training
PHP training
PowerBuilder training
Professional Development training
Professional Soft Skills Workshops training
Project Management training
Rational training
SAS training
Security training
SharePoint training
SOA training
SQL Server training
Telecommunications training
Tivoli training
Unix/Linux/Solaris/AIX training
Visual Basic training training
Visual Foxpro training
VMware training
Web 2.0 training
Web Development training
WebLogic training
WebSphere training
Websphere MQ (MQSeries) training
Windows programming training
XML training
XML Web Services training
DB2 for OS/390 and z/OS Database Administration
Overview

This course begins with a review the concepts and components of DB2 for OS/390.

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, and triggers are covered in detail.

Program design issues will be presented which effect concurrency, integrity and performance.

DB2 administration functions and utilities will be discussed in detail.

DB2 Application Performance considerations are reviewed.

LEARNING OBJECTIVES

After completing this course the student will be able to:

  • Explain DB2 UDB for OS/390 concepts and facilities
  • List and describe the components of DB2 UDB for OS/390
  • Create Databases, Tablespaces and Tables to support application development and user data access
  • Perform database and tablespace recovery
  • Run LOAD, UNLOAD, and CHECK DATA utilities
  • Discuss the RUNSTATS utility's capabilities
  • Implement DB2's Referential Integrity, Check Constraints, User Defined Distinct Types and User Defined Functions, and Triggers.
  • Discuss DB2 Security and Locking / Serialization considerations
  • Discuss DB2 Performance considerations
  • Discuss differences implemented in DB2 UDB for OS/390 Version 7
Audience

System administrators, database administrators, and technical personnel who are involved with planning, implementing, and maintaining the DB2 UDB for OS/390 environment.

Prerequisites

Six months of OS/390 experience is required. Six months of SQL experience is highly recommended. An understand of basic relational database concepts and objects such as tables, indexes, views, and joins is highly recommended.

Course duration

3 days

Course outline

DAY 1
 
  1. The DB2 Concepts and Terminology
  2. Creating databases and tablespaces
  3. Creating Tables and other objects
DAY 2
 
  1. Security and Locking
  2. DB2 utilities I - LOAD, CHECK DATA, RUNSTATS
  3. DB2 utilities II - COPY, REORG, UNLOAD
  4. Tablespace Recovery - RECOVERY

DAY 3
 
  1. Programming and Performance
  2. DB2 Version 7 changes

Appendices

Appendix A - IBM Sample Tables Appendix I - "Common" SQL Errors
Appendix B - Bibliography Appendix J - Version 6 Functions Summary
Appendix C - The Programming Workshop Appendix K - UDT and UDF
Appendix D - EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE Appendix L - Cast Testing
Appendix E - Hints to Success Appendix M - Trigger Introduction
Appendix F - SQLCODES / SQLSTATES Appendix N - DB2 for WINDOWs Overview
Appendix G - QMF Overview Appendix Z6- Changes Summary - DB2 V 6
Appendix H - Stored Procedures Appendix Z7- Changes Summary - DB2 V 7


Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.