DB2 10 for z/OS System Administration

DB2 10 for z/OS System Administration Course Description

Duration: 5.00 days (40 hours)

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 decision

  • Interpret lock displays

  • Identify and cancel particular threads

  • Describe available DB2 utilities to manage system and user page sets
  • Next Class Dates

    Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

    Back to Top

    Intended Audience for this DB2 10 for z/OS System Administration Course

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

    Back to Top

    This Course is also part of:

    Back to Top

    DB2 10 for z/OS System Administration Course Objectives

    • » Start and stop the DB2 subsystem
    • » Explain the allocation CLIST used at logon for DB2 data sets
    • » Use Set SYSPARM command
    • » Locate the Command recognition character for the DB2 subsystem
    • » Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped
    • » Explore DB2 Address Spaces information
    • » Select the DB2 functions that best satisfy your site requirements
    • » Explain the use of RACF for DB2 connection security
    • » Explain the use of Roles and Trusted Context
    • » Implement security procedures for a DB2 environment
    • » Describe the components and address space structure of a DB2 subsystem
    • » Explain DB2 Program Flow for all environments
    • » Explain parameter settings for the IRLM
    • » Display storage values for the IRLMPROC
    • » Dynamically change IRLM storage
    • » Estimate lock storage required for the IRLM
    • » Invoke and use DB2 TSO Facilities
    • » Use the DB2 Catalog to monitor authorizations
    • » Increase the size of the Active Log data sets
    • » Explain DB2 Logging
    • » Use SET LOG SUSPEND and SET LOG RESUME
    • » Use DSNJU004 to Print Log Map
    • » Interpret the output of Print Log Map
    • » Use DSNJU003 to rename DB2 data sets
    • » Plan for recovery of a BSDS failure
    • » Monitor and control DB2
    • » Explain transaction flow in IMS and CICS
    • » Describe the CICS and DB2 environment
    • » Explain the difference between JDBC and SQLJ

    Back to Top

    DB2 10 for z/OS System Administration Course Outline

        1. Basic architecture and fundamental mechanisms
          1. IPLing z/OS
          2. TSO/E LOGON
          3. Allocation CLIST
          4. Control of DB2
          5. START DB2 process
          6. DSNZPARM member
          7. DB2 address space structure
          8. DB2 log
          9. Catalog and directory
          10. Data sharing feature
          11. Connection process
          12. Command routing process
          13. Program preparation and execution processes
          14. Transaction and points of consistency
          15. Set up and tune the IRLM
          16. Recognize the important IRLM parameters
        2. System security
          1. Protect DB2 data sets when DB2 is up or down
          2. Protect connections to DB2
          3. Describe the high-level operation of DB2 security exits
        3. DB2 program flow for all environments
          1. Describe DB2 program execution
          2. Explain what a DB2 thread is
          3. Explain commit processing
          4. DSN
          5. CAF
          6. IMS
          7. CICS
          8. RRSAF
        4. TSO and batch environments
          1. Describe TSO facilities
          2. Describe the facilities of DB2I
          3. Invoke the DSN command processor in various ways
          4. Invoke DB2 utilities
          5. Describe the QMF environment
        5. DB2 authorization
          1. Provide appropriate authorization for your user community
          2. Monitor authorization in the DB2 catalog
          3. Effectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
          4. Create objects for others
        6. Logging
          1. Explain the basic algorithms of the DB2 logging facility
          2. Set up and operate your log efficiently
          3. Recover from BSDS failures
          4. Recover from certain lost log data set situations
          5. Explain the use of the log maintenance tools
        7. DB2 9 for z/OS utilities
          1. Categorize and discuss DB2 utilities
          2. Explain how to back up and recover DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities
          3. Define high-level qualifier for catalog and directory
          4. Rename DB2 data sets
          5. Print log map of BSDS
        8. Object recovery
          1. Describe the different types of application recovery
          2. Perform various health checks to detect damaged data
          3. Read the log using DSN1LOGP
          4. Avoid certain lost log scenarios
        9. Transaction flow in IMS and CICS
          1. Describe the two-phase commit process
          2. Explain thread recycling and the complete connection process for a DB2 thread
          3. Describe the input to and output from a SIGNON exit
        10. CICS - DB2 environment
          1. Outline a CICS connection to DB2
          2. Use the DSNC transaction
          3. Encourage CICS thread recycling
        11. Operations (monitoring and controlling DB2)
          1. Monitor and control DB2
          2. Train operators at your local site
          3. Discuss the functions of ATS (Administrative Task Scheduler)
        12. System recovery/restart
          1. Describe the DB2 restart process following both normal and abnormal terminations
          2. Prevent restart failures
          3. Recover from restart failures
          4. Begin planning for offsite recovery
        13. IMS - DB2 environment
          1. Integrate IMS transactions into the DB2 environment
          2. Integrate IMS BATCH jobs into the DB2 environment
          3. Control which plans, subsystems, and connection IDs transactions and batch jobs use
        14. Distributed - DB2 environment
          1. Describe the use of DB2 for z/OS enterprise servers in a multitier environment
          2. Explain the difference between JDBC and SQLJ
          3. Describe the Java database connectivity capabilities: use SQLJ and/or JDBC
          4. Document the requirements to set up the DB2 and Java environment in a z/OS environment

    Back to Top

    Do you have the right background for DB2 10 for z/OS System Administration?

    Skills Assessment

    We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

    Our required skill-assessments ensure that:

    1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
    2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
    3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
    This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

    Take your FREE Skill Assessment test »

    Back to Top

    Award winning, world-class Instructors

    Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

    Back to Top

    Client Testimonials & Reviews about their Learning Experience

    We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
    Read what students had to say about their experience at NetCom.   Read student testimonials...

    Back to Top