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 for z/OS Operations and Utilities

Course Code: DB2OU (Also known as: DB2OUGB)      Days: 2
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 provides detailed coverage of the operation and recovery of IBMs DB2 UDB for OS/390 database management system.

Audience

Technical Support staff who will be working with IBMs DB2 UDB for OS/390 database management system. DBAs, Systems Programmers and Operators in particular will find the content ideally suited

Prerequisites

A basic understanding of OS/390 Operations, Transaction Processing, TSO and Database fundamentals. A basic understanding of DB2 or attending The Introduction to DB2 course would be helpful

Course Outline

  • DB2 Objects
  • Tables.
  • Storage Groups and Databases.
  • Tablespaces: Simple, Segmented, and Partitioned.
  • Indexes.
  • Free Space.
  • Large Objects.
  • DB2 Catalog and Directory.
  • Software Structure
  • DB2 Address Spaces.
  • Connections and Threads.
  • RDS, Data Manager and Buffer Manager.
  • Buffer Pools.
  • Basic Operation
  • DB2 Definition.
  • Starting and Stopping DB2.
  • DB2 Commands.
  • DB2 Messages.
  • Controlling DB2 Databases
  • START DATABASE.
  • STOP DATABASE.
  • DISPLAY DATABASE.
  • Controlling Utilities
  • DISPLAY UTIL.
  • TERM UTIL.
  • Restarting Utilities.
  • Controlling IRLM
  • Controlling Connections
  • TSO, CICS, and IMS Connections.
  • Two Phase Commit.
  • Tracing Facilities
  • Recovery Overview
  • DB2 Utilities
  • Standard Recovery Utilities.
  • Utilities that Impact Recovery.
  • Stand Alone Utilities.
  • Invoking Utilities.
  • Standard Backup and Recovery
  • Image Copy, Recovery, and Index Recovery.
  • Mergecopy, Report Recovery, and Modify.
  • Concurrent Copy and Inline Image Copies.
  • Recovery Data
  • Data Object States
  • Possible Statuses.
  • Changing States.
  • Resetting States set by DB2.
  • Check Data, Check LOB, Check Index.
  • Repair.
  • Error Range and LPL.
  • Recovery to a Prior Point in Time
  • Point of Consistency.
  • Quiesce and Report Tablespaceset.
  • Recovery to POC.
  • Catalog & Directory Recovery
  • Subsystem Shutdown & Restart
  • Shutdown.
  • Restart Processing.
  • Resolving In-Doubt URs.
  • Deferred Restart.
  • Log and BSDS Failures
  • Log and BSDS Errors.
  • Print Log Map and Change Log Inventory Utilities.
  • Conditional Restart.
  • Disaster Recovery


How to make a booking for the DB2OU 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