Introductory Course
TITLE	KE101 - "DB2 UDB for z/OS Data Sharing Introduction”
ABSTRACT	This one-day class is an introduction to DB2 data sharing. It is a subset of the topics covered in the Krohn Enterprises, Inc. course KE310, "DB2 for z/OS Data Sharing Implementation," including units "Data Sharing Overview," "Planning for Data Sharing," and "Data Sharing Mechanics."
AUDIENCE	Appropriate attendees include DB2 professionals who are responsible for planning and implementing the data sharing feature of DB2 for z/OS. This includes DB2 system programmers, DBAs, as well as IS technical management.
LEVEL	Beginner
Presentation 1 (WINNER OF BEST OVERALL SPEAKER AT IDUG EUROPE 2004!)
TITLE	"Tuning Group Buffer Pools, One Command, One Spreadsheet"
ABSTRACT	This presentation discusses the mechanics of DB2's data sharing group buffer pools, and the tuning opportunities available for them. It will concentrate on the counters that are included in the output of the DISPLAY GROUPBUFFERPOOL command. It includes a discussion on the new page P-lock counters added to command output in DB2 Version 7, as well as Version 8 considerations.  An Exel spreadsheet for use in tuning group buffer pools is also explained, and an example demonstrated.
AUDIENCE	Appropriate attendees include DB2 professionals responsible for monitoring and tuning a DB2 for z/OS data sharing production system. This would include system programmers, DBAs, and technical support personnel.
LEVEL	Intermediate to Advanced
Presentation 2
TITLE	"P-Locks -- What are They, and Why Won't They Go Away?"
ABSTRACT	This presentation examines the mechanism of P-locks, and how DB2 utilizes these amazing locks to manage the internals of DB2 data sharing. It will discuss DB2's usage of P-locks for tracking page set interest, as well as for ensuring data integrity in a row-level locking data sharing environment. The displayed format and meaning of P-lock states will be presented.
AUDIENCE	Appropriate attendees include DB2 professionals responsible for supporting a DB2 for z/OS data sharing production system. This would include system programmers, DBAs, and technical support personnel.
LEVEL	Intermediate to Advanced
Presentaion 3
TITLE	"Tuning DB2 Data Sharing -- Where do I Start?"
ABSTRACT	This presentation is a high-level view of tuning a DB2 data sharing system. Tuning opportunities will be discussed, along with a brief view of displays and reporting systems used in the tuning process. This presentation is a subset of topics covered in the data sharing performance class CF340.
AUDIENCE	Appropriate attendees include DB2 professionals responsible for monitoring and tuning a DB2 for z/OS   data sharing production system. This would include system programmers, DBAs, and technical support personnel.
LEVEL	Intermediate to Advanced
Presenation 4
TITLE	“More Data Sharing Tuning Essentials You Need to Know!”
ABSTRACT	This presentation presents a day in the life of a DB2 DBA who is presented with data sharing performance problems to solve.  A customer DBA from CheckFree Corporation will participate, showing real-world examples of the value of data sharing education in solving data sharing performance issues.  Portions of CF340, “Data Sharing Performance and Tuning” will be part of the presentation.
AUDIENCE	Appropriate attendees include DB2 professionals responsible for monitoring and tuning a DB2 for z/OS  data sharing production system. This would include system programmers, DBAs, and technical support personnel.
LEVEL	Intermediate to advanced
Presentation 5
TITLE	“System vs. User-Managed Duplexing – What is the Difference?”
ABSTRACT	(Now available).  This presentation examines the mechanisms of duplexing CF structures – user managed and system managed, and discusses best uses of each method for providing increased availability for DB2 data sharing users.
AUDIENCE	Appropriate attendees include DB2 professionals responsible for supporting a DB2 for z/OS data sharing production system. This would include system programmers, DBAs, and technical support personnel.
LEVEL	Intermediate to advanced