DB2 UDB for Linux, UNIX, and Windows

IBM
Bangalore, India

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Learn how to perform, basic and advanced, database administrative tasks using IBM DB2 UDB. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Examine access strategies and describe strategies chosen by Optimizer using Explain tools. Use the db2diag.log file messages to direct your investigation of problems by using db2pd, INSPECT, and db2support and DB2 traces. Also, investigate the DB2 UDB process model, including its processes for log management, Input/Output (I/O) prefetching, page cleaning and utility processing for load, backup, and restore. This course addresses a quickstart to DB2 UDB database administration skills for experienced relational Database Administrators (DBA).

Course Materials

The course materials address DB2 UDB for Linux, UNIX, and Windows V8.2.

Hands-On Labs

Eleven labs are included to address DB2 UDB for Linux, UNIX, and Windows V8.2.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration.

Key topics

Overview of DB2 UDB

list the DB2 family of products
identify the DB2 UDB products
describe the functions of DB2 components
compare DB2 packaging options and product requirements
list DB2 supported configurations
Getting Started with DB2 UDB Graphical User Interface (GUI)

list the GUI tools in DB2 UDB
explore the various ways to access the GUI tools
use different methods to execute a command or statement in DB2 UDB
Creating Databases and Data Placement

create DB2 databases
identify default objects that are created when a database is created
identify how table spaces may be defined to store different types of data
describe the two types of table space management
identify when each type of table space management should be used
create System Managed Storage (SMS) table spaces
create Database Managed Storage (DMS) table spaces
Create objects

describe DB2 object hierarchy
create database objects: tables, indexes, views, aliases, schemas
alter tables and add check constraints, triggers, and referential integrity
describe Large Objects (LOB)
Moving data

describe and use the Export and Import utilities
describe and use the Load utility
describe the functionality of the DB2 Replication component
Recovery

state the three types of recovery support
explain the principles DB2 uses for its recovery/restart functions
describe the capabilities and functional requirements of DB2 logging
use the utilities to back up and recover user data and DB2’s catalog
recover data to a prior point in time
state general considerations regarding disaster recovery
prepare and implement standard recovery procedures for data recovery
Monitoring and problem determination

use error logs
identify the different monitor types
identify how to obtain a db2trc
describe the function of EXPLAIN and use this facility to assist basic analysis
identify additional commands for listing application information
Concurrency

list objects that may be locked by the database manager
discuss available lock modes and their compatibility
influence locking strategies used by the database manager
Application alternatives

prepare applications that access DB2 data for execution
use PRECOMPILE and BIND options that are appropriate for specific application requirements
describe the application alternatives available to access DB2 data or to request other DB2 functions
list the benefits, and possible disadvantages, of the various interfaces
Application performance

list reasons for REBIND of application programs and execute this command
define the concept of single dimensional clustering and determine the proper cluster sequence, if any, for DB2 tables
use RUNSTATS, REORGCHK, and REORG to enhance application performance
identify configuration parameters that impact performance of applications
describe the function of the EXPLAIN facility
Security

use DB2 access control mechanisms to implement security within the database
use group IDs to create a control hierarchy
describe privileges within a database
describe privileges required for binding and executing a package
describe the difference between explicit privileges and implicit privileges
describe the different DB2 authorization levels
Process model and parallelism

know the DB2 UDB process model:
- DB2 UDB process model without Database Partitioning Feature (DPF)
- DB2 UDB process model with DPF
- connection concentrator
know the EDUs related to the process model
know the DB2 UDB parallel options:
- interpartition parallelism
- intrapartition parallelism
- utilities (load / backup / restore)
- understand the relevant parameters in the configuration files
Archive log management

configure the DB2 database parameters that support the DB2 logs
implement a DB2 UDB USEREXIT program to enable archival and retrieval of DB2 logs
configure the database options to automate log management
describe the utilization and considerations for DB2 logs on a raw device
understand the options provided by DB2 UDB to reduce log volume
Using Explain tools

describe the advantages of using Visual Explain
describe the advantages of using db2exfmt
create special tables used by Visual Explain and db2exfmt
identify how to set the explain snapshot and explain mode registers to capture the information of interest
differentiate between the different methods of viewing explain information
Optimizer strategies

describe the information stored in packages
look at the access plans produced by the optimizer and describe what steps will be performed to execute the query
take actions to improve the access plans
Advanced problem determination

describe the types of information collected by DB2 that can be used to diagnose problems, including the db2diag.log and the administration notification log
plan the use of various diagnostic tools to address specific problems, including the db2diag command, db2pd, db2dart, inspect and db2level
collect supporting information for DB2 database problems using db2support and db2trc
analyze DB2 generated messages in the db2diag.log file and choose appropriate tools and commands to resolve the problems
utilize the Health Monitoring functions of DB2 to check the health indicators for a DB2 instance, database, or table space

...''

Phone:1800-425-3333

School Address:

SUBRAMANYAM ARCADE
NO12 BANNERGHATTA ROAD
BANGALORE 560029
India

Jobs & Resumes: Bangalore
Houses & Roommates: Bangalore

Lotus Domino 7 System Administration
iSERIES AND AS/400e RPG IV PROGRAMMING WORKSHOP
IBM WebSphere Portal Application Development
IBM TotalStorage (TM) Enterprise Storage Server Implement. in z/OS Environment
RATIONAL ROSE
Rational Unified Process
Rational RequisitePro
Developing Lotus Domino 6 Applications
Visual Modeling with UML
DB2 UDB for z/OS Database Administration Workshop
AIX 5L Basics
AIX 5L APPLICATION PROGRAMMING

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.