Digital Badge Program DB2

This credential earner has completed instructor-led learning for understanding how to perform database administration tasks.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 10 for z/OS Database Administration Part 2 - Code: CV842G

This credential earner has completed instructor-led learning for understanding of a view of the architecture and fundamental processes required to manage a Db2 10 for the z/OS subsystem.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 10 for z/OS System Administration - Code: CV851G

This credential earner completed instructor-led learning for understanding Db2 for z/OS utilities. Topics cover: using RUNSTATS to accelerate performance of a given SQL access; employing DSN1COPY, REPAIR & DIAGNOSE for DBA tasks which are not recovery-oriented; using parallel index build with the LOAD, REORG and REBUILD INDEX utilities; load partitions in parallel; LOAD options; concurrency & performance requirements; using options with REORG & UNLOAD; LISTDEF, TEMPLATE, and OPTIONS statements.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 10 for z/OS Utilities for Database Administrators - Code: CV871G.

This credential earner has completed instructor-led learning for DB2 11 for z/OS Application Programming Workshop (CV722G) course. They have acquired the skills necessary to produce application programs that manipulate DB2 databases.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV722G DB2 11 for z/OS Application Programming Workshop instructor-led training course

This credential earner has completed instructor-led learning for understanding Db2 11 components and pointers, and the processes used to install or migrate from Db2 10 for z/OS. Topics include hands-on experience installing Db2 10 for z/OS and migrating to Db2 11 for z/OS.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11 for z/OS Implementation Workshop - Code: CV862G

This credential earner has completed instructor-led learning for understanding a view of the architecture and fundamental processes required to manage a Db2 11 for z/OS subsystem. Topics include: relating the z/OS IPL process to a Db2 subsystem; effects of stopping and starting Db2; Integrated Catalog Facility (ICF) catalog names; DSN command processor; using views; controlling access; catalog search; Internal Resource Lock Manager (IRLM); implementing Db2 and RACF security; and more.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11 for z/OS System Administration - Code: CV852G

This credential earner has completed instructor-led learning for Db2 11.1 Administration Workshop for Linux (CL207G). They understand basic database administrative tasks using Db2 11.1.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CL207G Db2 11.1 Administration Workshop for Linux instructor-led training course

This credential earner has completed instructor-led learning for understanding how to plan, implement and maintain Db2 11.1 databases. Topics covered include: Advanced Monitoring; Db2 Table Space Management; Db2 Database Memory Management; Database rebuild support; Db2 database and tablespace relocation; and Db2 Incremental Backup.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.1 Advanced Database Administration - Code: CL464G

This credential earner has completed instructor-led learning for understanding how to plan, implement and manage Db2 11.1 databases using the High Availability Disaster Recovery (HADR) feature. This includes: processing performed for a Db2 Primary and Standby Db2 database; Db2 database configuration options that define and control the HADR function; defining and operating multiple HADR standby databases; allowing read only access by applications to a HADR Standby database; Db2 commands and more.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.1 HADR Workshop - Code: CL810G

This credential earner has completed instructor-led learning for Db2 11.1 Quickstart for Experienced Relational DBAs (CL487G) course. The badge earner understands basic and advanced administrative tasks using Db2. 11.1.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CL487G Db2 11.1 Quickstart for Experienced Relational DBAs instructor-led training course.

This credential earner has completed instructor-led learning for understanding how to perform basic and advanced database administrative tasks using Db2 11.5. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Topics also cover: Db2 Optimizer; Db2 Explain tools; diagnostic methods; db2pd command options; automatic archival for database logs; redirected database restore; REBUILD and TRANSPORT options of RESTORE; plus labs.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.5 Quickstart for Relational DBAs - Code: CL489G

This credential earner has completed instructor-led learning for understanding fundamentals of Database Administration for a Db2 12 for z/OS. This includes how to physically implement a logical database design using DDL, and considerations of referentially related tables. Topics covered include the use of basic utilities, program preparation, serialization, and basic database security.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 12 for z/OS Basic Database Administration - Code: CV844G

This credential earner has completed instructor-led learning for understanding the skills and knowledge needed to administer a Db2 12 for z/OS system.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course:Db2 12 for z/OS Introduction to System Administration - Code: CV853G

This credential earner has completed instructor-led learning for understanding how to prevent SQL performance problems and how to improve the performance of existing SQL. Topics include: understanding and designing better indexes; determining how to work with the optimizer (avoid pitfalls, provide guidance); optimizing multi-table access; working with subqueries; avoiding locking problems; and using accounting traces and other tools to locate performance problems in existing SQL.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 12 for z/OS SQL Performance and Tuning - Code: CV964G

This credential earner has completed instructor-led learning for Db2 12 for zOS: Basics for DBA Beginners (CV042G) course. They have learned the fundamental skills required to administer a Db2 Database in a z/OS environment.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV042G Db2 12 for zOS: Basics for DBA Beginners instructor-led training course

This credential earner has completed instructor-led learning for understanding fundamentals of Database Administration for a Db2 13 for z/OS. This includes how to physically implement a logical database design using DDL and considerations of referentially related tables. Topics covered include the use of basic utilities, program preparation, serialization, and basic database security.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV845G Db2 13 for z/OS Basic Database Administration instructor-led training course

This credential earner has completed instructor-led learning for Db2 13 for z/OS Utilities for Database Administrators. In this course, students have learned advanced topics about Db2 for z/OS utilities.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV972G Db2 13 for z/OS Utilities for Database Administrators instructor-led training course

This badge is for the completion of Db2 13 for z/OS: Advanced Database Administration. This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. This course also covered performance and availability features of utilities, including LOAD, REBUILD INDEX, REORG, and UNLOAD.

Course Objectives

Badge Criteria and Activities

Complete the following course:

This credential earner has completed instructor-led learning for understanding 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 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few. Topics covered include how the Db2 products provide services, with a focus on the services Db2 provides and how we work with Db2, not on its internal workings.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 Family Fundamentals - Code: CE031G

This credential earner has completed instructor-led learning for understanding how to tune for optimum performance the IBM Db2 10 for Linux, UNIX, & Windows relational database management system & associated applications written for this environment.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 for LUW Performance Tuning and Monitoring Workshop - Code: CL413G.

This credential earner has completed instructor-led learning for Db2 for z/OS 13: Introduction to System Administration and has demonstrated the foundational skills and knowledge required to administer Db2 13 for z/OS system.

Course Objectives

Badge Criteria and Activities

Complete the following course:

This credential earner has completed instructor-led learning for how to optimally tune the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Topics include: DB2 10 for Linux, UNIX, and Windows in support of single or multiple partition database environments; performance issues affecting the design of the database & applications using the database; major database performance parameters, and the different tools.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 LUW Performance Tuning & Monitoring for Single or Multiple Partition DBs - Code: CL443G

This credential earner has completed instructor-led learning for Db2 SQL Workshop (CE121G) course. They have introductory level knowledge on writing, supporting and understanding SQL queries.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CE121G DB2 SQL Workshop instructor-led training course

This credential earner has completed instructor-led learning for understanding how to make use of advanced SQL techniques to access DB2 databases in different environments.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 SQL Workshop for Experienced Users - Code: CE131G

The credential earner has completed the instructor-led training for the IBM Db2 LUW Family Fundamentals course. They have learned about the functions of IBM's Db2 and how Db2 products provide services.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CE032G IBM Db2 LUW Family Fundamentals instructor-led training course

This credential earner has completed instructor-led learning for Introduction to DB2 for zOS for Systems and Operations Personnel. The badge earner has demonstrated the basic skills required to administer a DB2 database in a z/OS environment.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV021G Introduction to DB2 for zOS for Systems and Operations Personnel instructor-led training course

This credential earner has completed instructor-led learning for understanding basic skills required to administer a DB2 database in a z/OS environment. Topics include: TSO/E and ISPF; Data sets; DB2 Objects; Structured Query Language; DB2 Commands; JCL and SDSF; DB2 Utilities; DB2 Logging; and DB2 Program Preparation.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: z/OS and DB2 Basics for DB2 for z/OS DBA Beginners - Code: CV401G.

This credential earner has completed instructor-led learning to introduce advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. This also includes performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD).

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 12 for zOS Advanced Database Administration - Code: CV880G