Get Free Widget

Courses

DB2 10 for z/OS System Administration

DB2 10 for z/OS System Administration

Category: DB2

Description

The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course DB2 10 for z/OS System Administration - ILO (3V851).

p>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. Engage in lectures and hands-on labs to gain experience to:

  • Relate the z/OS IPL process to a DB2 subsystem
  • Explain effects of stopping and starting DB2
  • Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • The use of DSN command processor running in batch and foreground
  • Use views to minimize your ability to see into the DB2 catalog
  • See how the catalog (through grant activity) controls access to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery requirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • Describe DB2 program flow for all environments
  • Display normal and problem threads and database status
  • See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decisio/li>
  • Interpret lock displays
  • Identify and cancel particular threads
  • Describe available DB2 utilities to manage system and user page sets

Audience

This intermediate course is for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.

Duration

5 days

Requirements

You should have an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered.

p>These skills can be developed by taking the DB2 Database Administration Workshop (CF83) / DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or through equivalent experience. You should also have a working knowledge of SQL. The DB2 SQL Workshop (CF12) / SQL Workshop - Instructor Led Online (3E120) provides that.

p>In addition, you should have:

  • At least one year as a z/OS systems programmer or equivalent experience
  • Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience

Curriculum

Basic architecture and fundamental mechanisms

  • Explain the principles of:n
    • IPLing z/OS
    • TSO/E LOGO/li>
    • Allocation CLIST
    • Control of DB2
    • START DB2 process
    • DSNZPARM member
    • DB2 address space structure
    • DB2 log
    • Catalog and directory
    • Data sharing feature
    • Connection process
    • Command routing process
    • Program preparation and execution processes
    • Transaction and points of consistency
  • Set up and tune the IRLM
  • Recognize the important IRLM parameters
p>System security

  • Protect DB2 data sets when DB2 is up or dow/li>
  • Protect connections to DB2
  • Describe the high-level operation of DB2 security exits
p>DB2 program flow for all environments

  • Describe DB2 program executio/li>
  • Explain what a DB2 thread is
  • Explain commit processing
  • Describe connection typesn
    • DS/li>
    • CAF
    • IMS
    • CICS
    • RRSAF
p>TSO and batch environments

  • Describe TSO facilities
  • Describe the facilities of DB2I
  • Invoke the DSN command processor in various ways
  • Invoke DB2 utilities
  • Describe the QMF environment
p>DB2 authorization

  • Provide appropriate authorization for your user community
  • Monitor authorization in the DB2 catalog
  • Effectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
  • Create objects for others
p>Logging

  • Explain the basic algorithms of the DB2 logging facility
  • Set up and operate your log efficiently
  • Recover from BSDS failures
  • Recover from certain lost log data set situations
  • Explain the use of the log maintenance tools
p>DB2 9 for z/OS utilities

  • Categorize and discuss DB2 utilities
  • Explain how to back up and recover DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities
  • Define high-level qualifier for catalog and directory
  • Rename DB2 data sets
  • Print log map of BSDS
p>Object 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
p>Transaction flow in 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
p>CICS - DB2 environment

  • Outline a CICS connection to DB2
  • Use the DSNC transactio/li>
  • Encourage CICS thread recycling
p>Operations (monitoring and controlling DB2)

  • Monitor and control DB2
  • Train operators at your local site
  • Discuss the functions of ATS (Administrative Task Scheduler)
p>System recovery/restart

  • Describe the DB2 restart process following both normal and abnormal terminations
  • Prevent restart failures
  • Recover from restart failures
  • Begin planning for offsite recovery
p>IMS - DB2 environment

  • Integrate IMS transactions into the DB2 environment
  • Integrate IMS BATCH jobs into the DB2 environment
  • Control which plans, subsystems, and connection IDs transactions and batch jobs use
p>Distributed - DB2 environment

  • Describe the use of DB2 for z/OS enterprise servers in a multitier environment
  • Explain the difference between JDBC and SQLJ
  • Describe the Java database connectivity capabilities: use SQLJ and/or JDBC
  • Document the requirements to set up the DB2 and Java environment in a z/OS environment

Classes

City Date Duration Language Format Early Price Exp Date Price Early bird Price Regular GTR

Register Here!

Our Delivery

on site delivery

Online or On-site de

We created a personalized delivery strategy by offering blended learning

communities of practice

Communities of practice

Find a bunch of people who are on the same page with you.

engaging

Engaging

Engaging platform with gamification for collaboration and friendly competition.

interactive

Interactive

Interactive online trainings and live webinars available.

efficient

Efficient

A special learning environment can boost learning efficiency.

accesible

Accessible

Available anywhere and anytime, on your phone, computer or tablet.

Q&A

  • Can you customize courses to suit our particular requirements? Yes, of course. We offer training consultancy and we establish the most appropriate solution according to the specific needs and business objectives of your company. Contact us and we’ll find the best training solution for you.
  • Can individuals use your services or they are organized for companies?Yes, we organise open courses which can be accessed by individuals. Whether you are looking for an IT or a Business training, you can find it at Brain Concert. Moreover, you’ll meet people from the same area of work as you and we can create communities of practice, where you can share professional tips and tricks and best practices.
  • What types of trainings are available for my company? We offer a variety of courses: in the IT area, there are Agile & Lean Courses, Software Development Courses, QA Courses, Software Administration Courses and Security Courses. We also offer Business Courses, focused on the development of soft skills. Define your objectives and choose the most appropriate training for you or your company.
  • What should I know before choosing a training? You should know that we offer courses for everyone, but you have to choose according to some criteria. First, define your objectives, then, the level of the participants (basic, advanced). There are courses with some requirements attached because the participants of a training session must form a compact group in terms of their previous knowledge so that they and the trainers are on the same page.
  • What is the minimum number of participants if we want in-house training? The minimum number of participants for an in-house depends on the course type. Please contact us to establish these details.
  • Can you organize virtual training sessions or only face to face trainings? Yes, you can choose an online or offline training session. We use Knolyx, an e-learning platform to make the process of online training delivery as efficient as a face to face training session.