DB2 UDB - Administration for Experienced DBAs Training

Course #:WA2228

DB2 UDB - Administration for Experienced DBAs Training

This course is designed for experienced DBAs who are to have the responsibility for administering IBM's DB2 Universal Database in a distributed (Linux, UNIX or Windows) environment. The course introduces and explains all aspects of relational technology as implemented by DB2 UDB for Linux, UNIX and/or MS Windows. Combining formal tuition with practical workshop sessions, the course covers all areas relevant to the DBA, including advanced techniques.


On successful completion of this course attendees will be able to:

  • use Command Center, Control Center, or other SQL execution environment (e.g. WinSQL) to code SQL statements
  • use the System Catlaog
  • understand and control the locking strategy used by DB2 to maintain data integrity
  • describe the different development environments available
  • explain the use and implementation of the Development Center
  • list the different types of indexes and the use of Index Advisor
  • use Visual Explain
  • use and understand the Health Center to describe the development and execution of Utilities
  • explain the use of Journals
  • describe the Replication Center
  • explain the use of the Task Center
  • use the Event Analyzer
  • describe the Indoubt Transaction Manager
  • use the Memory Visualizer
  • describe the Configuration Assistant.


New and experienced DBAs with responsibility for the administration of IBM's DB2 UDB.


Delegates are expected to have the relevant operating system experience (i.e. Linux, UNIX, or Windows). Previous experience of using DB2 is not a prerequisite.


4 days


Outline of DB2 UDB - Administration for Experienced DBAs Training

  • Introduction
  • DB2 LUW Editions
  • The DB2 Family Tools
  • Basic Terms
    • Instance; Database; Partitioned Database; Tablespace; Table/Row/Column; View; Materialized Query Tables; Nulls; Referential integrity.
  • DB2 System Catalog
  • Attributes
  • LOBs
  • Identity Column
  • Sequence Number
  • SQL Compatibility Feature
  • SQL Execution
  • Command line processing; Command Editor; Wizard Control Center; Data Studio.
  • Data Definition Language
  • Command Line Processing; A Script File via DB2BATCH.
  • Add/Remove Instance
  • Create Drop Database
  • Tuning the Database; Database Configuration File; Partitioned Database.
  • Create/Drop Tablespace
  • Create/Drop Table
  • Table Partitioning Feature
  • Create MQT
  • Views
  • Alter
  • Generating DDL
  • Set Integrity
  • Deep Compression
  • Practical exercise
  • Locking Strategy
  • What resources can be locked
  • How To Set The Locking
  • Locking Configuration Parameters; Locking Terms; Duration of a lock; Commit/Rollback; Logging; To find out what Locks are held; Savepoints.
  • Indexing
  • Physical data management; Creation; Utilities; Runstats; Reorg.
  • Access Strategy
  • Stage 1/ Stage 2 Predicates; Single Table Access Paths; Multi table access paths.
  • Explain
  • Explain Tables; DB2EXPLN; Visual Explain.
  • Multidimensional Clustering
  • Range Clustered Tables
  • Statistical View
  • Extra DB2 Facilities
  • Table Check Constraints; Triggers; Stored Procedures; User Defined Functions; Grant security label to user; Security policy; Security labels; Data control language commands; Removing or modifying LBAC definitions.
  • Practical exercise
  • Utilities
  • Embedded Applications
  • Sample C Program; Development stages; Precompile command; Bind command; Compile/Link; Java; Declaring Host Variables.
  • Logs, Snapshot ,Event Monitor, Reorgchk & Trace Logs
  • Types of Logging; Configuring Database; Logging Information; DB2DIAG; Manual Reading of the Log.
  • Snapshot & Event Monitor
  • Trace DB2TRC
  • Configuration Parameters
  • Instance Configuration Parameters; Database Configuration Parameters.
  • Remote Administration
  • DB2 Administration Server; Starting and Stopping; Obtaining the Name of the Server; Updating the DAS Configuration Parameters; Configuration Assistant; Instance Attachment Versus DB Connecting.
  • DB2 UDB Governor
  • Creating the Configuration File; Required Rules; Starting the Governor; Stopping the Governor; Governor Log Files; Reading the Log Files.
  • Security
  • Authentication; Authorization; Permissions; Categories; Administrative Authority: Instance Authority, Database Authority, Privilege, Database Roles, Data Control Language, DB2 Security Tools.
  • SYSADM Authority
  • DBADM Authority
  • Roles
  • Trusted Context
  • DB2 Audit
  • Automatic Computing
  • Other Options
  • Activity Monitor: Memory Visualization; Health Center; Recommendation Advisor; Journals; Replication Centre; Task Centre; Event Analyzer; Configuration Assistant.
  • Indoubt Transaction Manager
  • XML
  • Terms; XDM.
  • Object Definition
  • DB2 Extenders
  • Database Creation
  • Tablespace
  • Table
  • Enabling a Database for Text Search
  • DB2TEXT.
  • Creating a Full Text Index
  • Using XML Namespaces
  • XML Compression
  • The DB2 Catalog
  • Configuration Parameters
  • XPath Text Search and Retrieval of XML Data
  • Xquery
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.