Test C2090-732: DB2 9 DBA for z/OS
Information Management certification exams for Business Partners, IBMers, and Customers, are based on experience inthe Job Role defined for the exam. However, supporting courses and publications may help you prepare for the certification exam. These courses are recommended, but not required, before attempting the certification exam. Completion of the supporting courses does not ensure that you will be successfullly able to pass the certificaiton exam.
Study Guide for the certification test.
All Course Formats
This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.
DB2 9 runs under the z/OS, Linux, UNIX, and Windows operating systems, to name a few.
The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.
This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education.
This course is the classroom delivered version of Instructor Led Online Course 3E120.
This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.
This is a basic course anyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).
This course is the classroom delivered version of 3V830.
This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
Note: This course material is at the DB2 9 for z/OS level.
This is an intermediate course for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
This course is the classroom delivered version of 3V84.
This course is a continuation of course CV83 and is designed to teach you how to perform additional database administration tasks. CV84 also covers several of the topics introduced in CV830 in much more depth.
This is an intermediate course for z/OS database administrators who have the basic skills required to administer a DB2 database and want to extend their skills.
This course is for installers of DB2 UDB for z/OS V8 and/or migration to DB2 9 for z/OS using the Install CLIST. You will be involved in lectures to understand DB2 UDB for z/OS and DB2 9 Components and pointer and the processes involved to install and or migrate DB2. To reinforce the lectures a series of labs are provided to give you hands-on experience installing DB2 UDB V8 and migrating to DB2 9 for z/OS.This is the classroom version of the Instructor Led Online (ILO) course DB2 for z/OS Implementation Workshop - Instructor Led Online (3L861)
This new guide, written by Susan Lawson and Dan Luksetich covers all topics on the exam, including database design and implementation, operation and recovering, security and auditing, performance, and installation and migration. Complete with sample questions and detailed answers–as well as a full-length practice exam–this study guide serves as an essential tool. Programmers will learn how to create, maintain, and administer DB2 9 databases on the z/OS platform and how to implement XML with a DB2 9 database, making you successful database administrators after you pass certification.