 |
Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.
|
 |
|
Course title:
DB2 Family Fundamentals
Course duration: 2.0 days
Course number: CF03
Abstract: Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems. This course addresses DB2 UDB running on z/OS, AIX, Linux, HP-UX, Sun, and Windows operating systems. Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work, not on DB2 UDB internal workings. If you are interested in iSeries, AS/400, or AS/400e, you should complete: DB2 UDB for iSeries Fundamentals (S6145) Course Materials The course materials cover DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX, and Windows Version 8. Hands-On Labs No labs are included with this course. Certification Prepare for IBM Certification Test 512: DB2 UDB V7.1 Family Fundamentals and IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000350 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000267 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000369 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000360
This is a basic course for administrators, analysts, programmers and other technical individuals, who need introductory knowledge of DB2 UDB. It is also for individuals preparing for advanced and specialized DB2 UDB for z/OS and OS/390 Version 7 and DB2 UDB for Linux, UNIX and Windows Version 8 education. This course may not be required for individuals with relational database system experience.
|
|
Course title:
DB2 UDB for z/OS V8 Database Administration Workshop - Part 1
Course duration: 5.0 days
Course number: CF83xxx (Worldwide); CF831 (US)
Abstract: Learn how to physically implement a logical database design in DB2. Learn about DB2 data management, DB2 catalog tables, the bind process, database utilities, such as LOAD and REORG, and security considerations. Course Materials The course materials cover DB2 UDB for z/OS Version 8. Hands-On Labs Ten labs are included to address database administration using DB2 UDB for z/OS Version 8. Certification Prepare for IBM Certification Test 702, DB2 UDB V8.1 for z/OS Database Administration. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000364 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000365
This is an intermediate course for DB2 UDB for z/OS and OS/390 database administrators who need to acquire the basic skills required to administer a DB2 database.
|
|
Course title:
DB2 UDB for z/OS V8 Database Administration Workshop - Part 2
Course duration: 5.0 days
Course number: CF84xxx (Worldwide); CF841 (US)
Abstract: This course is a continuation of DB2 UDB for z/OS Database Administration Workshop - Part 1 (CF831). Learn how to perform additional database administration tasks. Also, examine several of the topics introduced in CF831 in much more depth. Course Materials The course materials cover DB2 UDB for z/OS Version 8. Hands-On Labs Nine labs are included to address database administration using DB2 UDB for z/OS Version 8. Certification Prepare for IBM Certification Test 702, IBM DB2 UDB Version 8 for z/OS Database Administration. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000364 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000365
This is an intermediate course for DB2 UDB for z/OS database administrators who have the basic skills required to administer a DB2 database and who want to extend their skills.
|
|
Course title:
DB2 UDB for z/OS Application Performance and Tuning
Course duration: 5.0 days
Course number: CF96xxx (Worldwide); CF961 (US)
Abstract: Learn how to detect, fix, and prevent application performance problems with DB2 UDB for z/OS, Version 8. Complete design and tuning exercises that are based on real-life experiences. Gain skills to address the most common application performance problems such as inadequate indexes, optimizer issues, lock waits, physical table design, and cursor design. Course Materials The course materials cover DB2 UDB for z/OS Version 8. Hands-On Labs Four hands-on labs are included to address use of Explain for performance evaluation using DB2 UDB for z/OS Version 8. Paper Labs Practice the techniques discussed in the lecture topics using well designed case studies. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000362 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000364
This is an advanced course for senior application programmers, senior application analysts, senior application developers, and database administrators.
|
|
Course title:
DB2 UDB for z/OS System Administration
Course duration: 4.5 days
Course number: CF85xxx (Worldwide); CF850 (US)
Abstract: Examine DB2 on the z/OS platform. Learn to understand, evaluate, and manage DB2 system functions. Learn the basic processes involved in tailoring and installing DB2 and its attachment facilities. Discuss the basic concepts of DB2 system recovery and system performance. The following topics are introduced in this course, but details are contained in other DB2 UDB for z/OS courses: DB2 system problem determination DB2 security procedures Distributed processing DB2 data sharing Course Materials The course materials cover DB2 UDB for z/OS Version 8. Hands-On Labs Five labs are included to address using DB2 UDB for z/OS Version 8. Certification Prepare for IBM Certification Test 702: DB2 UDB V8.1 for z/OS Database Administration. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000364 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000365
This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 UDB for z/OS Version 8.
|
|
|
 |
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More
Publication number: SG24-6079-00
IBM DATABASE 2 Universal Database Server for z/OS Version 8 is the twelfth and largest release of DB2 for MVS. It brings new synergy with the zSeries hardware and is the first major subsystem to exploit the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability, and performance for the enterprise of choice.
DB2 Version 8 has been re-engineered for e-business, with many fundamental changes in architecture and structure. Key improvements enhance scalability, application porting, security, and continuous availability. Management for very large databases is made much easier, while 64-bit virtual storage support makes management simpler and improves scalability and availability. This new version breaks through many old limitations in the definition of DB2 objects, including SQL improvements, schema evolution, longer names for tables and columns, longer SQL statements, enhanced Java and Unicode support, enhanced utilities, and many more advantages.
This IBM Redbook introduces the many enhancements made available with DB2 V8. It will help you understand the functions offered by DB2 V8, and provides information to help you to evaluate their applicability to your environment, as well as to plan for the installation of DB2 V8 or the migration from DB2 V7.
|
|
|
|
|
The Official Introduction to DB2 UDB for z/OS Version 8
The Official Introduction to DB2 UDB for z/OS provides a comprehensive overview of Version 8 of the DB2 UDB for z/OS product. The book serves a dual purpose: it gives new and prospective users a solid introduction to key product features and it covers material contained in the DB2 Family Fundamental exam, the first exam in the DB2 certification series. The book explains basic relational database concepts, the basics of the structured query language (SQL), and gives a solid overview of the various user tasks that are associated with this product. It includes introductory information about designing databases, creating relational objects, managing DB2 on a day-to-day basis, and writing application programs that use DB2 data. It also introduces new users to some of the more complex capabilities of DB2, such as, DB2 in the Web environment, distributed data, and data sharing. Introductory book for the DB2 mainframe audience, parallels Baklarz audience (ISBN 0130463612). Well-written (The Society of Technical Communication recognized the first edition of this book with a Merit award in the Northern California Technical Communication Competition.) Most current coverage of Version 8 of DB2 UDB for z/OS, the single largest release of this product since its inception in 1983-- Includes 8.2
|
|
|
|
