DB2 for LUW (Linux, UNIX & Windows) Administration

DB2 for LUW (Linux, UNIX & Windows) Administration

Audience

This course is for Systems Administrators, Database Administrators and technical personnel who are involved in all stages of designing, planning, implementation and maintaining DB2 for LUW Databases. The course is delivered up to the latest release level of DB2.  Earlier releases can be covered on request.

Prerequisites

Delegates are expected to have relevant operating system experience (i.e. Linux, UNIX or Windows). Knowledge of relational database theory is not a pre-requisite, nor is previous experience of using DB2.

Duration

4 days. Hands on.

Course Objectives

The course is designed to teach delegates how to perform database administration activities on DB2 in a Linux, UNIX or Windows environment. Those activities include all aspects of creating and maintaining DB2 instances, databases, tablespaces and tables, manual or automatic maintenance, utilities, problem determination, parallelism, distributed data management and all aspects of efficiency in a DB2 LUW environment.

The course contains numerous practical exercises to consolidate the course content.

Course Content

Introduction

DB2 LUW Editions

The DB2 Family Tools

Basic Terms
Instance.
Database.
Configuration Parameters.
Partitioned Database.
Tablespace.
Table/Row/Column.
View.
Materialized Query Tables.
Temporial Tables.
Nulls.
Referential integrity.

DB2 System Catalog
SYSCAT VIEWS.
SYSSTAT VIEWS.
SYSIBM TABLES.
Table Relationships.

Attributes

LOB'S

Identity Column

Sequence Number

SQL Compatibility Feature

SQL Execution
Command line processing.
Command Editor.
Wizard Control Center.
Data Studio.

Data Definition Language
Command Line Processing.
A Script File Via DB2BATCH.

Add/Remove Instance

Create Drop Database
Tuning The Database.
Database Configuration File.
Partitioned Database.

Create/Drop Tablespace

Create/Drop Table
Table Partitioning Feature.
Temporal Tables.

Create MQT

Views

Alter

Generating DDL

Set Integrity

Deep Compression

Practical Eexercise

Locking Strategy
What resources can be locked?

How To Set The Locking
Locking Configuration Parameters.
Locking Terms.
Duration of a lock.
Commit/Rollback.
Logging.
To Find Out What Locks Are Held.
Savepoints.

Indexing
Physical data management.
Creation.
Utilities.
Runstats.
Reorg.

Access Strategy
Stage 1 / Stage 2 Predicates.
Single Table Access Paths.
Multi table access path (incl Zigzag join).

Explain
Explain Tables.
DB2EXPLN.
Visual Explain.

Multidimensional Clustering

Range Clustered Tables

Statistical View

Extra DB2 Facilities
Table Check Constraints.
Triggers.
Stored Procedures.
User Defined Functions.
Grant security label to user:
• Security policy.
• Security labels.
• Data control language commands.
• Removing or modifying LBAC definitions.

Practical Exercise

Utilities
BACKUP.
RESTORE.
LOAD Utility.
IMPORT/EXPORT Utility.
INGEST (10.1).

Embedded Applications
Sample C Program.
Development stages.
Precompile command.
Bind command.
Compile/Link.
Java.
Declaring Host Variables.

Logs, Snapshot, Event Monitor, Reorgchk & Trace Logs
Types of Logging.
Configuring Database.
Logging Information.
DB2DIAG.
Manual Reading of the Log.

Snapshot & Event Monitor

Trace DB2TRC

REORGCHK

Configuration Parameters
Instance Configuration Parameters.
Database Configuration Parameters.

Remote Administration
DB2 Administration Server.
Starting and Stopping.
Obtaining the Name of the Server.
Updating the DAS Configuration Parameters.
Configuration Assistant.
Instance Attachment Versus DB Connecting.

DB2 UDB Governor
Creating the Configuration File.
Required Rules.
Starting the Governor.
Stopping the Governor.
Governor Log Files.
Reading the Log Files.

Security
Authentication.
Authorization.
Permissions.
Categories .
Administrative Authority:
• Instance Authority.
• Database Authority. 
• Privilege.
• Database Roles.
• Data Control Language.
• DB2 Security Tools.

SYSADM Authority

DBADM Authority

Roles

Trusted Context

Row and Column Access

DB2 Audit

Automatic Computing

Other Options
Activity Monitor.
Memory Visualization.
Health Center.
Recommendation Advisor.
Journals.
Replication Centre.
Task Centre.
Event Analyzer.
Configuration Assistant.

Indoubt Transaction Manager

XML
Terms.
XDM.

Object Definition

DB2 Extenders

Database Creation

Tablespace

Table

Enabling a Database for Text Search
DB2TEXT.

Creating a Full Text Index

Using XML Namespaces

XML Compression

The DB2 Catalog

Configuration Parameters

XPath Text Search and Retrieval of XML Data

XQuery

Public Courses

There are no up-coming events

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...