Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
course expiry notice
 
This course has been upgraded to:
 
»
 CF851  DB2 UDB for z/OS System Administration
 
This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.
 


DB2 UDB for z/OS and OS/390 System Administration
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CF850   length. 4.5 days
type. Instructor-Led   partner. IBM
price.
$2,875  
 

IACET credits 3.6
 
Examine DB2 on the z/OS platform. Learn to understand, evaluate, and manage DB2 system functions. Learn how to tailor and install DB2 and its attachment facilities, how to do system problem determination, and how to set up security procedures. Explore DB2 system recovery and system performance.

Distributed processing and data sharing is presented only at an overview level. Other courses cover those subjects.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 
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.
 
prerequisites
  
 
You should complete or understand:

DB2 UDB for z/OS and OS/390 V7 Database Administration Workshop - Part 1 (CF830)
OR have equivalent experience
DB2 SQL Workshop (CF120)
OR have working knowledge of SQL
AND UNDERSTAND the objects (tables, indexes, and databases) used in DB2 systems and how those objects are created, managed, and recovered.
 
skills gained
  
 

Select the DB2 functions that best satisfy your site requirements
Implement security procedures for a DB2 environment
Describe the components and address space structure of a DB2 subsystem
Implement DB2 system recovery procedures
Understand the basic principles of DB2 system performance tuning
Install, update, and migrate DB2 (with the help of the DB2 library)


 
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.



 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Card
Yes - IBM Education Pack
Yes - IBM Corporate Education Pass
Yes - IBM Education Pack - online account


 
skill level
  
 

Intermediate


 
course content details  
 


  Basic architecture and fundamental mechanisms

explain the principles of the DB2 address space structure
explain the principles of the START DB2 process
explain the principles of the DSNZPARM member
explain the principles of the DB2 log
explain the principles of the catalog and directory
explain the principles of the data sharing feature
explain the principles of the connection process
explain the principles of the program preparation and execution processes
explain the principles of the transaction and points of consistency




  Distributed overview

list the basics of DB2 Distributed Relational Database Architecture (DRDA) support
explain the basic properties of stored procedures
list the basics of distributed tuning




  Installation and Migration Procedures

list the basic princibles of installing DB2
identify the basics of making storage estimates
describe some of the more important installation jobs
identify how your subsystems are built
identify how to update an existing system
identify the migration process
describe the basics of Managed System Infrastructure for Setup (msys)




  Internal Resource Lock Manager (IRLM)

set up and tune the IRLM
list the important IRLM parameters




  System security

protect DB2 data sets when DB2 is up or down
protect connections to DB2
describe the high-level operation of DB2 security exits
understand multilevel security




  DB2 program flow for all environments

describe DB2 program execution
explain what a DB2 thread is
understand commit processing




  Time Sharing Option (TSO) and batch environments

describe the facilities of DB2 Interactive (DB2I)
invoke the DSN command processor in various ways
describe DB2 utility invocation
describe the QMF environment




  DB2 authorization

provide appropriate authorization for your user community
monitor authorization in the DB2 catalog
effectively assign administrative authorities such as SYSADM, DBADM, and BINDAGENT
create object for others




  DB2 audit facility

explain the purpose of audit trace
set up audit trace usage of your system
minimize the overhead of running audit trace on your system




  Logging

explain the basic algorithms of the DB2 logging facility
set up and operate your log efficiently
recover from Bootstrap Data Set (BSDS) failures
recover from certain lost log data set situations
explain the use of the log maintenance tools




  Application recovery

describe the different types of application recovery
perform various health checks to detect damaged data
read the log using DSN1LOGP
avoid certain lost log scenarios




  Transaction flow in Information Management System (IMS) and CICS

describe the two-phase commit process
explain thread recycling and the complete connection process for a DB2 thread
describe the input to and output from a SIGNON exit




  CICS - DB2 environment

set up and administer a CICS/DB2 environment
define efficient CICS to DB2 connections
use the DSNC transaction
encourage CICS thread recycling




  Operations (monitoring and controlling DB2)

operate DB2
train operators at your local site
avoid certain problem situations




  System recovery/restart

describe the DB2 restart process following both normal and abnormal terminations
prevent restart failures
recover from restart failures
perform indoubt thread resolution manually
plan and perform conditional restarts
begin planning for off-site recovery




  IMS environments

integrate IMS transactions into the DB2 environment
integrate IMS BATCH jobs into the DB2 environment
control which plans, subsystems, and connection IDs that transactions and batch jobs use




  WebSphere - DB2 environment

identify the differences between JDBC and SQL for Java (SQLJ)
identify the characteristics of different JDBC driver types
list the basics of Universal Driver for SQLJ and JDBC
describe WebSphere application connectivity to DB2 for z/OS and OS/390




  An introduction to DB2 performance

describe why performance is important
identify the components of program run time
demonstrate the importance of indexes to reduce Central Processing Unit (CPU) consumption
identify performance tuning areas




  Buffer pool tuning

describe how buffer pools work
identify the main benefit of buffer pools
describe the significance of two important buffer pool thresholds
decide how to implement buffer pools



 
Free Chumby with IBM Training

Save on IBM Training



find a course
 
phone us
 
view course schedule





Give your team direction. Authorized IT education.

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware