Mainframe DB2 DBA L2

Sr. No. Topics Measurement criteria
1 PARR Understanding MVS System Components - PROCLIB, PARMLIB, APF, Linklist, and LPA This learning activity will enable you to achieve the following objectives: Explain what Procedure Libraries (PROCLIBs) and Parameter Libraries (PARMLIBs) z/OS® uses; Know and describe an Authorized Program Facility (APF) list; Know and describe the Linklist; Know and describe the Link Pack Area (LPA) list; Know and describe the Library Lookaside (LLA) list; and Locate the active libraries that z/OS uses.
2 PARR Understanding Basic MVS Storage Components - SMS and ISMF This learning activity should enable you to achieve the following objectives: Describe the differences among the five major DFSMS components; Define basic System-Managed Storage (SMS) terminology concepts; Describe the basic fundamentals of the Interactive Storage Management Facility (ISMF); and Explain the general connections between the output of the TSO LISTCAT command and the previously described SMS and ISMF basic concepts.
3 DB2 Family Fundamentals - Web-Based 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 runs under the z/OS, VM, 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.
4 z/OS and DB2 Basics for DB2 for z/OS DBA Beginners - Instructor Led Online This course will help beginning DBAs develop fundamental z/OS and DB2 for z/OS skills through lectures and hands-on labs in the areas of: z/OS TSO/E and ISPF Data sets JCL and SDSF DB2 Objects Structured Query Language DB2 Commands DB
5 PARR Delivering an IBM z/OS Product with the GSD Platform - Overview This learning activity should familiarize you with the steps for using Reference System Support Services (R3S) to deliver a product to a target system from the GSD repository server.
6 PARR Understanding Security Requirements for all DB2 Objects and Classes (DSNR, AAPL, APPCPORT) This learning activity will enable you to understand the external security requirement for installation and customization of new DB2 subsystem and Distributed Database Facility DDF. The learning covers only RACF security system. At the end of this learning you should be able to differentiate the 3 RACF classes (DSNR, APPCPORT and APPL) and their associated profiles. DB2 internal security is not covered in this learning
7 PARR IBM DB2 9 for z/OS - Installation, Customization, and Verification This learning activity will enable you to understand the software installation delivery method known as System Modification Program/Extended (SMP/E). It will briefly show by example only how SMP/E work is performed and how to determine if a program temporary fix (PTF) has been applied. It will also show how to use the customization Interactive Productivity Facility (ISPF) panels to customize DB2 for z/OS. It will also show the steps to verify a correct installation.
8 z/OS Basics This classroom course of 4 and 1/2 days prepares the student to work in a z/OS mainframe environment by introducing the current mainframes and major base elements and optional features of the z/OS environment.
9 SQL Workshop - SPVC This course provides an introduction to the SQL language and applies to both DB2 and Informix. This course is appropriate for customers working in all DB2 or Informix environments.
10 DB2 9 for z/OS Technical Overview This book introduces the enhancements made available with DB2 9 for z/OS. It helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities. Understand prerequisites and migration process and evaluate applicability and major returns.
11 z/OS JCL and Utilities This course is designed to teach you how to use z/OS job control language (JCL) and selected z/OS utility programs in an online batch environment. Both Storage Management Subsystem (SMS) and non-SMS JCL are discussed. Machine lab exercises complement the lecture material.
12 DB2 9 for z/OS - Using the Utilities Suite This IBM Redbooks® publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information about introducing the functions that help set up and invoke the utilities in operational scenarios, shows how to optimize concurrent execution of utilities and collect information for triggering utilities execution, and provides considerations about partitioning.
13 DB2 for z/OS Implementation Workshop 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. The participants are involved in lectures that explain DB2 9 components and pointers, and the processes used to install or migrate from DB2 UDB V8. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 UDB V8 and migrating to DB2 9 for z/OS.
14 DB2 10 for z/OS Implementation Workshop This course is for installers of DB2 9 z/OS and/or migration to DB2 10 for z/OS using the Install CLIST. The participants are involved in lectures that explain DB2 10 components and pointers, and the processes used to install or migrate from DB2 9 for z/OS. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 9 for z/OS and migrating to DB2 10 for z/OS.
15 DB2 9 for z/OS Spotlight on zParms This course is designed to teach Systems Programmers and Database Administrators what is behind most of the DB2 9 for z/OS ZPARMs. Although all parameters are described in the Installation guide, for many of them it is not obvious what they really do, how changing several of them can really help you doing your every day job and make DB2 perform and behave better. During this course, you will touch almost every DB2 9 ZPARM.
16 DB2 9 for z/OS Administration Workshop Part 1 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.
17 DB2 9 for z/OS Administration Workshop Part 2 This course is a continuation of course DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) and is designed to teach you how to perform additional database administration tasks
18 DB2 10 for z/OS System Administration Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem.
19 DB2 10 for z/OS Database Administration Workshop Part 1 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 10 for z/OS level
20 DB2 10 for z/OS Database Administration Part 2 This course is a continuation of DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) and is designed to teach you how to perform additional database administration tasks.
21 Basics of z/OS RACF Administration Learn how to administer the z/OS Security Server Resource Access Control Facility (RACF). Get an introduction to the z/OS environment, Time Sharing Option (TSO) and Interactive System Productivity Facility / Program Development Facility (ISPF/PDF), batch processing, and z/OS data sets. Gain experience with z/OS by viewing, and allocating datasets, submitting a batch job, and viewing job output. Learn how to use basic RACF command parameters and panels.
22 SMP/E for z/OS Workshop This course is designed to provide the SMP/E skills needed in the installation and maintenance of optional features and maintenance in the z/OS operating environment. You are taught to define the SMP/E database and invoke SMP/E to add, modify, or replace system elements. The course includes extensive hands-on labs using a current level of SMP/E.
23 DB2 9 for z/OS Advanced System and Disaster Recovery Workshop The course is designed to provide instruction in the design and implementation of recovery and restart procedures for DB2 which maximize availability.
24 z/OS REXX Programming Workshop This course is designed to teach you the basic skills required to write programs using the Rexx language in the standard z/OS environments: TSO, ISPF, and MVS. The course covers the TSO extensions to Rexx, the interface with ISPF, and interaction with other environments such as the MVS console, and running Rexx in batch jobs, and compiling Rexx.
25 DB2 for z/OS - Data Sharing in a Nutshell This IBM Redbooks publication facilitates your journey towards data sharing by providing a cookbook approach to the main tasks in enabling data sharing and workload balancing. It does not have all the answers, because it is a brief summary of a large field of knowledge, but it contains the key elements and it points you in the right direction to get more details. Throughout this document we assume that your sysplex environment is set up and a DB2 subsystem exists at a currently supported level.
26 DB2 10 for z/OS Technical Overview This IBM Redbooks publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10. Explore the new system and application functions, obtain information about expected performance improvements, and decide how and when to migrate to DB2 10.
27 PARR IBM DB2 System - Backup and Recovery - Overview This learning activity should enable you to perform basic backup and recovery activities for application data used with DB2 for z/OS. In addition, it will show you how the relative byte addressing works with DB2 as it relates to backup, recovery, point-in-time recoveries, and log synchronization. Finally, you will learn how the BACKUP SYSTEM and RESTORE SYSTEM utilities function.
28 IBM Certified Database Associate - DB2 9 Fundamentals To attain the IBM Certified Database Associate - DB2 9 Fundamentals certification, candidates must pass this test. Test 000-730 is a pre-requisite to both a. IBM Certified System Administrator and b. IBM Certified Database Administrator
     
Last modified on Thursday, 02 July 2015 17:54
Super User

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare consectetur sodales. Nulla luctus cursus mauris at dapibus. Cras ac felis et neque consequat elementum a eget turpis. Aliquam erat volutpat.

More in this category: « About Us SQL DBA Level 2 »

About us

  • Founded in 2007 by Santosh Lohar, GSS Infosoft Pvt Ltd started with a commitment to deliver the best in IT services, Consulting and Outsourcing. We quickly built our reputation as the preferred innovation and solution partner on web and enterprise portal, office automation, Quality & IT Security Management, testing and test automation technologies. We have helped over 100 clients build and modernize their products & services.
    Read more...

Newsletter

Register your email for alert!!