Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 Administration, Performance and Procedures for Linux, Unix and Windows Training

DB2 Administration, Performance and Procedures for Linux, Unix and Windows Training

Course#: WA1860

This course is custom designed to review the Administration of DB2 version 9.7 for LINUX, UNIX and Windows. This course has 4 major sections; basic administration, advanced recovery, “performance and tuning” and SQL Procedures.  DB2 commands and SQL will be used to focus on relevant DB2 activities.  DB2 administration functions and utilities will be reviewed and applied in workshops.  Performance and tuning issues will be reviewed and applied in workshops. Snapshot commands and administrative views will be used to gather performance data. In addition the design and use of stored procedures will be reviewed.  GUI tools may be used to create, test and debug procedures. Design issues for functions and stored procedures will be reviewed and applied in workshops. EXPLAIN tools can be used to analyze SQL access strategy. The impact of index design will be reviewed. The Developers Workbench or IBM Data Studio may be used in workshops.

What you will learn

 

After completing this course the student should be able to:


  • Understand the basic concepts and facilities of DB2.
  • Create instances, databases and relational objects to support application development and user data access.
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
  • Perform basic and advanced database and tablespace recovery
  • Understand row compression and range partitioning on tables to improve performance
  • Understand and control the locking behavior of DB2 and gather snapshot information for analysis.
  • Know how the DB2 Optimizer can be influenced to aid performance.
  • Use EXPLAIN tools and techniques to improve SQL performance
  • Alter the configuration of DB2 to improve performance and enable automatic maintenance of DB2 tables
  • Develop SQL stored procedures

Audience

 

DB2 administrators, programmers and data designers who are responsible for DB2 applications behavior.

Prerequisites

 

Relevant Operating Systems experience (Linux, UNIX or Windows).  Knowledge of relational database theory and SQL. Previous experience of using DB2 is recommended.

Duration

  Five days.

Outline of WA1860 DB2 Administration, Performance and Procedures for Linux, Unix and Windows Training

Getting started with DB2 (INSTANCES)

  • The DB2 hierarchy of objects
  • TCP/IP Connectivity for DB2
  • Instance creation and configuration
  • CLP (command line processor) coding options
  • The DB2 Administration Server

DB2 and GUI

  • Administration (GUI) tools
  • Configuring a DB2 Client to access remote instances and databases
  • using the Command Editor to run queries or commands
  • Using the Control Center to create a database object

Creating databases and tablespaces

  • Know how to create a database
  • Create SMS and DMS tablespaces
  • List tablespace and container information for a database
  • Get tablespace snapshots
  • Alter a tablespace and change container sizes
  • List and change the database and instance configuration files
  • Introduce Automatic storage


Creating Tables and other objects

  • Creating tables and indexes
  • Using data types and nullity attributes for columns
  • Defining Referential and table Check constraints
  • Creating views and nested table expressions
  • introduce row compression
  • identify concepts of range partitioning

DB2 LOCKING

  • How DB2 controls concurrency and integrity for multiple users
  • Know the factors effecting data locking
  • use commands to effect the behavior of DB2 locking
  • use monitors to analyze user locking activity
  • database configuration parameters that effect locking

IMPORT/EXPORT/LOAD Utilities

  • when and how to useIMPORT, EXPORT and LOAD
  • Choose options to improve performance
  • the effects of using LOAD and how to bring a table to normal status
  • Compare LOAD and IMPORT

Basic Database Recovery

  • when and how to use BACKUP and RECOVERY operations.
  • Choose a database configuration for “full recovery” after failure.
  • ROLLFORWARD through the transaction logs to reapply changes to data.
  • Check the status of a tablespace and resolving problems
  • Accomplish point-in-time recovery of a tablespace

Disaster Recovery for tables and tablespaces

  • Complete a redirected restore, to replace lost or changed containers for tablespaces.
  • Recover from dropped table
  • Incremental backup and recovery techniques
  • why and how to choose an incremental backup activity.
  • Determine options for database and tablespace recovery, after anincremental backup
  • Setup for a database for incremental backup activity

Data Access Techniques

  • Understand strategies that might be used by the DB2 optimizer
  • Know what happens at execute time for specific strategies.
  • Use the EXPLAIN tools to analyse access strategy.
  • The DB2 Optimizer
  • Know the impact of optimizer options on performance
  • Review multi-table access
  • Create indexes with varying options to improve performance
  • Create automatic summary tables
  • Consider the ways RAID or SAN technology may be used
  • use lab activities to analyze and influence SQL performance

DB2 Operational Model

  • Review the architectural concepts for DB2
  • look at the behavior of DB2, with respect to I/O operations
  • identify important cache and monitoring elements
  • Lab activities involve extensive performance and tuning of the database to improve overall performance. Analysis of DB2 snapshots will prompt changes in database configuration. This pattern of analysis and change (tuning), will be repeated until performance is optimized.

Configuring for self tuning of DB2

  • automatic maintenance with utilities
  • Self tuning memory
  • database global memory
  • automatic tuning

SQL Procedures

  • Basics of creating stored SQL procedures with commands or GUI tools
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.