DB3 Datasharing Courses

CF340, “DB2 UDB for z/OS  Data Sharing Performance and Tuning”

Krohn Enterprises, Inc.’s primary education offering is the invaluable data sharing performance class CF340, "DB2 UDB for z/OS Data Sharing Performance and Tuning". It is NOW AVAILABLE in it's sixth version, and includes DB2 Version 8 Considerations!  CF340 has been updated to a four-day lecture class, with paper lab exercises. The lab exercises are drawn from real-world customer installations, and illustrate performance tuning opportunities in DB2 data sharing, including z/OS tuning opportunites, CF structure sizing implications, and the effect of DB2 subsystem parameters on data sharing performance. The lecture units in the class are:

  • z/OS Support Services
  • Tuning z/OS Support Services
  • DB2 Data Sharing Mechanics - GBPs
  • DB2 Data Sharing Mechnanics - Locking and SCA 
  • Structure Tuning
  • DB2 Subsystem Tuning
  • Application Tuning
  • Tuning your Data Sharing System - Putting it All Together   NEW Unit! 

NEW! Now included in the course student handout: a detailed PERFORMANCE CHECKLIST (Melissa's List), which includes a list of performance items to check (over 80!), as well as DB2 messages to monitor for alerts! (Toni's List).

 

  These checklists could quickly become one of your most valuable tools for tuning your data sharing group!

 

NEW! NOW AVAILABLE!! Click here to download an Excel spreadsheet to help you assess the performance of your busiest Group Buffer Pools.  Also available is a Word document, describing this spreadsheet.

 

Standard Pricing and Scheduling for on-site CF340 classes through Krohn Enterprises, Inc.:

    • $1200 per student for first 10 students (minimum class size of 4)
    • $1000 per additional student for classes over 10 attendees
    • $75 per student kit (or, duplicated at customer site)
    • Travel and Living Expenses

NOTE:  CF340 is no longer offered through IBM IT Education Services.  Please contact us at Krohn Enterprises directly for scheduling the class in your city, or at your site.

 

 

KE311, “DB2 UDB for z/OS Data Sharing Implementation”

 

Krohn Enterprises, Inc.'s second education offering is the DB2 for z/OS data sharing course, KE311, "DB2 UDB for z/OS  Data Sharing Implementation". In three information-packed days, PowerPoint™ visuals provide DB2 technical support personnel a thorough and up-to-date explanation of data sharing, which includes DB2 Version 8 Considerations. After an overview of a z/OS parallel sysplex and an introduction to DB2 data sharing, planning for data sharing is discussed. The implementation and mechanics of data sharing are then covered in detail. New DB2 and OS/390 commands necessary to operate data sharing are explained and illustrated. Enhancements offered in DB2 Versions 5, 6, 7, and 8 are discussed. Communications options for both SNA and TCP/IP are explained. An introduction to performance considerations concludes the course. The lecture units in the course are:

  • z/OS and OS/390 Parallel Sysplex Overview
  • DB2 Data Sharing Introduction
  • Planning for DB2 Data Sharing
  • DB2 Data Sharing Mechanics
  • Installation and Migration
  • DB2 Data Sharing Commands
  • DB2 Data Sharing Enhancements
  • DB2 Data Sharing Considerations for Distributed
  • Introduction to DB2 Data Sharing Performance

Pricing and Scheduling for on-site KE311 classes through Krohn Enterprises, Inc.:

    • $3500 per class for up to 10 students (contact us for pricing on larger classes)
    • $60 per student kit (or, duplicated at customer site)
    • Travel and Living Expenses

           

 

KE320, “DB2 UDB for z/OS Data Sharing Recovery and Restart"

 

Krohn Enterprises, Inc.'s third education offering is the DB2 for z/OS data sharing course, KE320, "DB2 UDB for z/OS Data Sharing Recovery and Restart". In 2 days, recovery and restart capabilities of DB2 data sharing are explained.  The changes in database recovery operational procedures are discussed in the first unit.  The following units concentrate on the system aspects of data sharing recovery and restart.  The lecture units in the course are:

 

  • Database Recovery in the Data Sharing Environment
  • Parallel Sysplex Availability Considerations
  • Structure Allocation and Recovery Considerations and Restart
  • Parallel Sysplex Component Recovery in the Data Sharing Environment
  • Disaster Recovery Considerations for DB2 Data Sharing

 

Pricing and Scheduling for on-site KE320 classes through Krohn Enterprises, Inc.:

    • $3000 per class for up to 10 students (contact us for pricing on larger classes)
    • $60 per student kit (or, duplicated at customer site)
    • Travel and Living Expenses

           

 

 KE310 and KE320 scheduled together:

 

Pricing and Scheduling for on-site KE310 combined with KE320 classes in the same

week through Krohn Enterprises, Inc.:

    • $6000 per combined class for up to 10 students (contact us for pricing on larger classes)
    • $120 per student kit (or, duplicated at customer site)
    • Travel and Living Expenses

 

KE350, “DB2 UDB for z/OS Data Sharing Implementation Workshop”

 

Krohn Enterprises, Inc.'s newest education offering is the DB2 for z/OS data sharing course, KE350, "DB2 UDB for z/OS  Data Sharing Implementation workshop". In four information-packed days, PowerPoint™ visuals provide DB2 technical support personnel a thorough and up-to-date explanation of data sharing, which includes DB2 Version 8 Considerations. After an overview of a z/OS parallel sysplex and an introduction to DB2 data sharing, planning for data sharing is discussed. The implementation and mechanics of data sharing are then covered in detail. New DB2 and OS/390 commands necessary to operate data sharing are explained and illustrated. Enhancements offered in DB2 Versions 5, 6, 7, and 8 are discussed. Communications options for both SNA and TCP/IP are explained. An introduction to performance considerations concludes the course. The lecture units in the course are:

  • z/OS and OS/390 Parallel Sysplex Overview
  • DB2 Data Sharing Introduction
  • Planning for DB2 Data Sharing
  • DB2 Data Sharing Mechanics
  • Installation and Migration
  • DB2 Data Sharing Commands
  • DB2 Data Sharing Enhancements
  • DB2 Data Sharing Considerations for Distributed
  • Introduction to DB2 Data Sharing Performance

These lecture units are re-inforced with hands-on labs, during which the students will enable a data sharing group on their own system.  Additional lab exercises will give students experience working with a data sharing group.

 

Contact us for Pricing and Scheduling for on-site KE350 classes through Krohn Enterprises, Inc.

 

KE380, “The How and Why of DB2 for z/OS Version 8”

 

                    Krohn Enterprises, Inc.'s newest education offering is the DB2 for z/OS data sharing course, KE380, "The How and Why of DB2 for z/OS Version 8". In three information-packed days, the planning steps necessary for migrating to Version 8 will be explored, including early customer experiences with Version 8.  Performance considerations will be an important part of the course, as well as an overview of the many new functions available in Version 8.  The lecture units in the course are:

    • Overview of DB2 Version 8 Features
    • Planning for Version 8, and Incompatible Changes
    • Version 8 Meeting the Availability Challenges
    • Version 8 Migration and Installation
    • Version 8 Doing eBusiness
    • Network Computing in Version 8
    • Unicode in Version 8
    • Version 8 and Storage and Scalability Challenges
    • Data Sharing Performance Enhancements
    • Utility Enhancements in Version 8
    • Performance Considerations in Version 8
    • Application Enablement
    • New SQL in Version 8

 

 ( Let us know at Krohn Enterprises, Inc.of  your interest in this course - it is available NOW!.

 

Contact us for Pricing and Scheduling for on-site KE380 classes through Krohn Enterprises, Inc.

 

 
ABOUT US | SERVICES | COURSES | REFERENCES | NEWS | CONTACT US