Home
  
How it works
  
About the quality of your course
 
Managed services
  
Promote CourseMonster
  
 
 
 
 
IBM

DB2 v9 for LUW Administration

Course Code: DB2UDBA (Also known as: DB2UDBAGB)      Days: 4
Show all IBM Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
England
Somerset
Bath (BA1) 01/12/08 £ 1,350
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? 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