DB2 UDB LUW ADMINISTRATION

Course: DB2AU

Duration: 4 Days

Level: I

Course Summary

The Course is designed to instruct those attending the course in all elements of developing and maintaining a DB2 LUW environment.

« Hide The Details

Topics Covered In This Course

Day 1

Introduction to DB2
Versions
System architecture
Terms/Terminology
Instance/Database
Tablespace
Tables
Table partitioning(9)
Views
Merge
Materialization
MQT
Columns
Nulls
Referential Integrity
Buffer Pools
Alias
Attributes
Numeric
Character
Date/Time
ROWID
IDENTITY
UDT
Lob's
Unicode
SQL Execution Environment
Command line processing
COMMAND CENTER
CONTROL CENTER(WIZARD)
Data Definition Language
CONNECT
DATABASE
TABLESPACE
TABLE
ALTER

Day 2

SELECT (single table)
*/ALL/COLUMNS/DISTICT/CONCATENATOR/literals/ORDER BY
FETCH FIRST
Efficiency aspects
Predicates
=
IN
BETWEEN
LIKE
GROUP
AND/OR
Built in function
MAX/MIN/SUM/COUNT/AVG/COUNT_BIG
Scalar Functions
Examples and use of some of them e.g. SUBSTR/VALUE etc
Complex SQL
Table joins
EQ JOIN
SUBSELECT
CORRELATED SUBSELECT
UNION
Left/Right/Full Joins
In Line Tables
CASE
Remainder of DML statements
UPDATE/DELETE/INSERT
CTE's

Day 3

Embedded SQL
Static and Dynamic SQL
Cursors
Development cycle
Precompile
DBRMs
BIND
PLANS/PACKAGES
Execution of executable program
LOCKING STRATEGY
Introduction
What resources can be locked?
The different locks available
Duration of a lock
Commit/rollback
Locking notes
INDEXING
Physical data management
Tablespace Object
Page
Record identifier
Indexes Type 1 and 2
RUNSTATS/REORG
MDC
Access strategy
Multi table access path
EXPLAIN
VISUAL EXPLAIN

Day 4

Extra Facilities
OPTIMIZE FOR
HANDLING NULLS
TEMPORARY TABLES
Remote and Distributed Environments
Logs
Security
GRANT/REVOKE
Security levels(9)
Table check constraints
TRIGGERS
STORED PROCEDURES
Utilities
BACKUP
RESTORE
LOAD
IMPORT/EXPORT
DB2 LUW Tools overview
Design Advisor
Index Advisor
Activity Monitor
Memory Visualization
Health Center
Remote Administration
Journal
Replication Center
Task Center
Event Analyzer
Recommendation Adviser

Who Should Take This Course

DB2 personnel who are new to DB2, or who have not used it for a long time and are expected to maintain or are required to write and perform activities associated with a DB2 LUW environment up to DB2 9.

Recommended Prerequisites

Those attending the course should be familiar with elementary aspects of a relational database, and are familiar with using a Linux, Unix or Windows environment.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
DB2A	DB2 for z/OS Administration	5 Days	I	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
3/5/2012	Wichita, KS

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com

Privacy Notice