Training Course:DB2 UDB for z/OS and OS/390 Data Sharing ImplementationSchool/Trainer:M/UX
Chicago, Phoenix, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This is an advanced course for senior system administrators, senior database administrators, and senior technical system professional individuals, who plan, implement, and maintain DB2 UDB for z/OS and OS/390.
Skills Taught
--------------------------------------------------------------------------------
Describe DB2 for OS/390 or z/OS data sharing components
Describe an OS/390 or z/OS Parallel Sysplex environment
Understand how DB2 data sharing utilizes OS/390 or z/OS sysplex services
Plan for and implement DB2 data sharing
Operate a DB2 for OS/390 or z/OS data sharing group
Implement, monitor, and tune the DB2 data sharing components
Implement, monitor, and tune group buffer pools
Implement, monitor, and tune global locking structure
Implement, monitor, and tune Shared Communications Area (SCA)
Understand the key performance issues for DB2 data sharing
Course outline
--------------------------------------------------------------------------------
OS/390 and z/OS sysplex overview
describe the components of a z/OS or OS/390 sysplex
understand the role of these components in DB2 data sharing
explain how DB2 data sharing exploits parallel sysplex technology
DB2 data sharing overview
describe the major components of a DB2 data sharing group
understand the hardware requirements for data sharing
describe how DB2 exploits z/OS and OS/390 parallel sysplex services to share data
understand the mechanisms used by DB2 to provide global data integrity and consistency
Planning for DB2 data sharing
describe the prerequisites for data sharing
design a flexible and trouble-free naming convention
estimate the storage needed for coupling facility structures
integrate a data sharing group into your security environment
The coupling facility and data sharing
describe the operation of group buffer pools
understand the global locking mechanism
explain some of the uses of the SCA
DB2 data sharing commands
monitor the sysplex components used by DB2 data sharing
monitor DB2 structures in the coupling facility
understand and make use of z/OS, OS/390, and DB2 data sharing related commands
Installation
enable data sharing on a non-data sharing DB2 subsystem
use the installation DB2 clist and its jobs
create a new DB2 data sharing group
Migration and disabling
describe and perform the process of migrating a DB2 data sharing group to a new release of DB2
describe the process of disabling a DB2 data sharing group
describe the consequences of disabling a DB2 data sharing group
describe how to remove a member of a data sharing group by making it dormant
Physical lock (P-lock) considerations
describe a P-lock
understand DB2 usage of page set and page P-locks
describe and interpret the changes in states of page set P-locks
DB2 data sharing enhancements
understand the DB2 data sharing improvements in each DB2 version beyond Version 4
describe group buffer pool rebuild, automatic group buffer pool recovery, and group buffer pool duplexing
understand DB2 restart enhancements
describe inter-DB2 interest tracking enhancements
explain space map page processing enhancements
describe GBPCACHE options
explain new page size considerations
explain sysplex query parallelism
Merging data into a data sharing group
describe the advantages and disadvantages of using DB2 utility DSNTIAUL & LOAD
describe the advantages and disadvantages of using DB2 utility DSN1COPY
describe the advantages and disadvantages of using DB2 utilities RENAME and REPAIR
Distributed considerations for data sharing
describe the ways to connect to a DB2 data sharing group
implement the new Communication Database (CDB) tables and entries for data sharing support
explain the workload balancing alternatives
An introduction to data sharing performance
obtain good performance from a data sharing system by monitoring and tuning group buffer pools and global locking
find and understand the key data sharing sections of performance reports including Resource Measurement Facility (RMF) and DB2 Performance Monitor Statistics and Accounting
Find and understand the key data sharing sections of z/OS and DB2 DISPLAY commands
change the sizes, thresholds, and ratios of coupling facility structures
Daily Agenda
Day 1
Welcome
OS/390 and z/OS Sysplex Overview
DB2 Data Sharing Overview
Planning for DB2 Data Sharing
Day 2
The Coupling Facility and Data Sharing
DB2 Data Sharing Commands
Day 3
Installation
Migration and Disabling
P-Lock Considerations
DB2 Data Sharing Enhancements
Merging Data Into a Data Sharing Group
Distributed Considerations for Data Sharing
An Introduction to Data Sharing Performance (Optional)
...''
Please go to the school's official website for training price and schedule:
http://www.mux-ed.com/
Phone:866-700-9811
School Address:
pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537
CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511
DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533
M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA
Jobs & Resumes: Chicago, Phoenix
Houses & Roommates: Chicago, Phoenix
Other training courses offered by M/UX:
CICS V3.2 Fundamentals
DB2 SQL Workshop
Relational Database Design
Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 for z/OS and OS/390 Data Sharing Recovery and Restart
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming Workshop
DB2 UDB for z/OS System/Disaster Recovery Workshop
Query and Manage XML data with DB2 9
DB2 UDB for z/OS Stored Procedures using COBOL
DB2 and SQL Programming Workshop
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
|
