Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
DB2 for z/OS Database Administration
Overview

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

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 z/OS concepts and facilities
  • List and describe the components of DB2 UDB for z/OS
  • 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
Audience

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

Prerequisites

Six months of z/OS 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
          Hands-on Workshop - Database / Tablespace
  3. Creating Tables and other objects
          Hands-on Workshop - Tables, Referential Integrity, Check Constraints, UDT, UDF
DAY 2
 
  1. Security and Locking
  2. DB2 utilities I - LOAD, CHECK DATA, RUNSTATS
          Hands-on Workshop - LOAD, CHECK DATA, RUNSTATS
  3. DB2 utilities II - COPY, REORG, UNLOAD
          Hands-on Workshop - COPY, REORG, UNLOAD
  4. Tablespace Recovery - RECOVERY
          Hands-on Workshop - Tablespace Recovery

DAY 3
 
  1. Programming and Performance
          Hands-on Workshop - Programming and Performance
  2. DB2 Version 8, 9 and 10 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 Z8- Changes Summary - DB2 V 8
Appendix H - Stored Procedures Appendix Z9- Changes Summary - DB2 V 9
  Appendix Z10- Changes Summary - DB2 10


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy