Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse IBM Training Courses

DB2 v9 for LUW Administration

Course Code: DB2UDBA (Also known as: DB2UDBAGB)      Days: 4
Show all IBM Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.

Course Overview

The Course is designed to instruct those delegates attending the course how to perform database administration activities on DB2 in a Linux, UNIX or Windows environment. Those activities include all aspects of manual or automatic maintenance, utilities, problem determination, parallelism, distributed data management, remote administration, MDT, Health Center, federated databases and DB2 Governor.

Audience

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 DB2 9.

Prerequisites

Delegates are expected to have relevant operating system experience (i.e. Linux, UNIX or Windows) and knowledge of relational database theory and SQL. Previous experience of using DB2 is recommended.

Course Outline

Introduction to DB2

  • The DB2 family
  • The Big Picture
  • Basic Terms
  • DB2 System Catalog
  • Attributes
  • SQL Execution
  • Control Center
  • DDL
  • Practical Exercise

Indexing

  • Design Advisor
  • Practical Exercise

RUNSTATS

  • REORG
  • Access Strategies
  • Practical Exercise
  • Explain
  • Visual Explain
  • Practical Exercise

MDC

  • Automatic Computing
  • Configuration Parameters
  • Collecting Catalog Statistics
  • Activity Monitor
  • Memory Visualization
  • Health Center
  • Remote Administration
  • DB2 Administration Server
  • Configuration Assistant
  • Instance Attachment
  • Connection
  • The Governor and Audit

Problem Determination Tools and Techniques

  • Parallelism and SMP Enablement
  • Utilities
  • db2move
  • db2look
  • db2ocat
  • db2cfexp
  • db2cfimp
  • List Utilities

Capacity Management

  • Estimate Size
  • Storage Management
  • Database Container Operations
  • High Availability Monitor

Advanced Load

  • Distributed Management
  • Federated Databases
  • Configure Multisite Update
  • Journal
  • Replication Center
  • Task Center
  • Event Analyzer
  • Recommendation Adviser
  • Indoubt Transaction Manager


How to make a booking for the DB2UDBA course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership