Best Practises for DB2 Maintenance Print
Workshops

The latest DB2 versions introduced new functionality that may demand changes in the way you run your maintenance today. New utility options allows you to get better availability, performance, scalability, recoverability, decrease resource usage and lower costs. The workshop describes the best practices to exploit the power of your utilities.

Referenten

 Tal Lifshitz, Kai Stroh

Type

 Seminar with integrated Workshop

Audience

 This workshop is intended for DB2 System administrators, database administrators and other technical individuals, who manage and implement DB2 z/OS and are responsible for DB2 installation and maintenance, backup and recovery, disaster recovery, data propagation, system and application performance and tuning.

Prerequisites

 Before taking this course, you should have an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered. At least one year working with DB2 as a DBA on the mainframe or equivalent experience.

Durartion

 2 Days

Purpose/Objectives

The latest DB2 versions introduced new functionality that may demand changes in the way you run your maintenance today. New utility options allows you to get better availability, performance, scalability, recoverability, decrease resource usage and lower costs. The workshop describes the best practices to exploit the power of your utilities.

After completing this session, you should be able to:

  • Implement maintenance procedures for a DB2 environment.
  • Identify new utility options and understand how to apply utility features intelligently while lowering costs and saving resources.

Amount

 Seminar: Course documents ca. 100 text pages

Available Languages

 German, English

Topics

1. Real Time Statistics

  • What is RTS, how to enable it and exploit it
  • DSNACORR stored procedure
  • RTS version 9 changes

2. Statistics Collection

  • RUNSTATS or inline statistics collection
  • Collecting Distributed Statistics
  • Histograms in version 9

3. Backups

  • Backup frequency and policy
  • Monthly and Yearly backups
  • Incremental Backups
  • Backups for indexes
  • MERGECOPY and COPYTOCOPY
  • Templates naming conventions
  • Template switching

4. LISTDEF

  • Different lists for different utilities
  • Limited use

5. Reorg

  • Mapping tables
  • BUILD2 phase
  • KEEPDICTIONARY considerations
  • NOSYSREC recommendations
  • Reorg Rebalance
  • Reorg Discard
  • Diskussion und Empfehlungen zur Einstellung

6. CHECK DATA

  • Exceptions tables
  • Using recursive SQL to detect dependencies
  • Using REPORT TABLESPACESET to detect dependencies
  • Online CHECK DATA in DB2 version 9

7. Unload and Reload

  • Delimited data
  • LOB Handling for LOAD/UNLOAD using File Reference Variables
  • UNLOAD SKIP LOCKED DATA
  • Online LOAD with CLONE tables

8. QUIESCE

  • Log point, syncpoint, quiet point
  • Ensuring recoverability

9. Recover

  • PIT Recovery
  • Fast log apply
  • Recover with consistency
  • Disaster Recovery

10. MODIFY RECOVERY

  • How to get it done fast
  • New version 9 RETAIN options

11. Managing Logs

  • Recovery considerations
  • Archiving to DASD and managing DASD pools
  • BSDS Conversion

12. Restarting Utilities

  • DB2 RESTART feature
  • Reallocating and resizing work datasets

13. DSNUTILS and DSNUTILU stored procedures

  • WLM environment requirements
  • Executing from REXX

14. DSN1COPY

  • Comparing physical attributes
  • Translating internal ids
  • Defining Missing Linear Datasets
  • Online Schema Changes Consideration
  • Compression dictionary versions

15. DSN1LOGP

  • Detecting units of recovery
  • Detecting quiet points

16. DSN1COMP

  • Sampling data for compression evaluation
  • Analyzing results 

Fee

1.180,- € plus VAT, per attendant

4.500,- € plus VAT, for INHOUSE-Workshop without limitation of attendance figure