DURATION
4 days
Audience
Database administrators and other technical personnel who are involved in planning, implementing, and maintaining DB2 databases.
Pre-requisites
Before taking this course, you should be able to:
Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements
Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
These skills can be developed by taking:
OS Training
AIX 5L Basics
Linux Basics and Administration
Windows Systems Administration Or by having equivalent HP-UX or Solaris administration experience
DB2 SQL Workshop
DB2 Universal Database Fundamentals
Objective
After completing this course, you should be able to:
List and describe the components of DB2 Universal Database
Implement DB2 security
Perform basic administration of a DB2 database system
Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations
Key topics
Overview of DB2 Universal Database
Getting Started with DB2 UDB GUIs
Creating Databases and Data Placement
Create Objects
Moving Data
Recovery
Monitoring and Problem Determination
Concurrency
Application Alternatives
Application Performance
Security
CURRICULUM RELATIONSHIP :
CF03 - DB2 Family Fundamentals
CF20 - DB2 Universal Database Administration Workshop for Linux
CF23 - DB2 Universal Database Administration Workshop for Windows
CF27 - DB2 Universal Database Administration Workshop for Sun Solaris
CF24 - DB2 UDB Multi Partition DBA Workshop
CF28 - Fast Path to DB2 UDB for Experienced Relational DBAs
CF10 - DB2 Universal Database Programming Fundamentals
CF11 - DB2 UDB for Linux, UNIX, and Windows Programming using Java
CG11 - DB2 UDB for UNIX, Windows, OS/2 Programming Using Java
CG24 - DB2 UDB Multi Partition Environment for Single Partition DBAs
CF41 - DB2 Universal Database Performance Monitoring and Tuning Workshop
CF44 - DB2 UDB Multi Partitioned Performance Monitoring and Tuning Workshop for UNIX
CF45 - DB2 Universal Database Advanced Administration Workshop
CF60 - DB2 Connect DRDA Implementation with TCP/IP
CF61 - DB2 Connect DRDA Implementation with SNA and TCP/IP
CF63 - DB2 Connect to DB2 for OS/390 Problem Determination and Performance
CF49 - DB2 UDB Advanced Recovery and High Availability Workshop
CG08 - DB2 UDB for Linux, UNIX, and Windows V8 Transition
CF48 - Fast Path to DB2 UDB Advanced Administration for Experienced Relational DBAs
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.