Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 UDB - Administration for Experienced DBAs Training

DB2 UDB - Administration for Experienced DBAs Training

Course#: WA2228

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.

Objectives

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.

Audience

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

Prerequisites

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.

Duration

4 days

 

Outline of WA2228 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
  • SYSCAT VIEWS; SYSSTAT VIEWS; SYSIBM TABLES; Table Relationships.
  • 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
  • BACKUP; RESTORE; LOAD Utility; IMPORT/EXPORT Utility.
  • 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
  • REORGCHK
  • 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.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.