Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


DB2 10.5 Administration Workshop for Linux

GK# 4476

Course Overview

This IBM course teaches database administrators how to perform basic database administrative tasks using DB2 10.5 for Linux, UNIX and Windows. These tasks include creating database objects like tables, indexes and views, and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options and monitoring with SQL statements that reference DB2 monitor functions. Instructors will demonstrate ways to cover the locking performed by DB2 and the effect the application isolation level has on locking and lock wait conditions. We will also describe implementing DB2 native encryption for a database.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.


    $2995 CAD

    4 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2995 CAD

    4 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Implement automatic archival for database logs
  • Recover a database to a specific point in time using the archived logs
  • Use EXPLAIN tools to review the access plans for SQL statements
  • Add indexes to improve SQL performance.
  • Implement database security, including adding a security administrator and security administration authority (SECADM) user
  • Implement database roles to simplify security management.


Participants should have the following skills:

  • Perform basic database administration tasks on a relational database system
  • 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: 

            -DB2 SQL Workshop
            -DB2 Fundamentals

Who Needs To Attend

This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement and maintain DB2 10.5 for Linux, UNIX and Windows databases.

Course Outline

Download Course Outline