Ir a inicio > Cursos > Ingeniería del Software > Álvaro Obregón > Curso de DB2 for Z/OS System Performance and Tuning CF881MX - Álvaro Obregón - CDMX - Ciudad de México

Curso de DB2 for Z/OS System Performance and Tuning CF881MX

Contacta sin compromiso con IBM Traning Centro de Capacitación

Para enviar la solicitud debes aceptar la política de privacidad

Analisis de educaedu

Pablo Nieves

Pablo Nieves

Curso de DB2 for Z/OS System Performance and Tuning CF881MX

  • Modalidad de impartición
    La modalidad de impartición es presencial.
  • Número de horas
    Consultar.
  • Titulación oficial
    Certicicación Técnica Profesional de IBM de DB2 for Z/OS System Performance and Tuning.
  • Valoración del programa
    Los objetivos del programa son: Entender los procesos de DB2 que se relacionan con el rendimiento de DB2, interpretar la salida de rastreo de DB2 en DB2 Monitor de rendimiento (PM) forma, analizar la concurrencia y cuestiones de serialización, sintonizar un subsistema DB2, proporcionar información de calidad para ayudar a los programadores de sistemas que trabajan así DB2, entre otros.
  • Precio del curso
    Preguntar.
  • Dirigido a
    Este es un curso avanzado de Tecnologías de la Información (TI) personas, que sintonizan los sistemas DB2 en entornos z / OS.
  • Empleabilidad
    Al terminarás podrás laborar en el campo de la tecnología.
¿Quieres saber más sobre este curso?
Solicitar información

Comentarios sobre Curso de DB2 for Z/OS System Performance and Tuning CF881MX - Presencial - Álvaro Obregón - CDMX - Ciudad de México

  • Objetivos del curso
    - Understand DB2 processes as they relate to DB2 performance - Interpret DB2 trace output in DB2 Performance Monitor (PM) forma - Analyze concurrency and serialization issues - Tune a DB2 subsystem - Provide quality input to help system programmers make DB2 work well
  • Prácticas
    This a Hands-On Capacitation
  • Curso dirigido a
    This is an advanced course for Information Technology (IT) individuals, who tune DB2 systems in the z/OS environments.
  • Titulación
    Certicicación Técnica Profesional de IBM de DB2 for Z/OS System Performance and Tuning
  • Contenido
    KEY TOPICS

    Course introduction
      - Identify which topics are going to be discussed, and which will not
      - Explain why some z/OS concepts and controls have important influences on DB2 performance
      - Describe how DB2 works so that you can begin to monitor and tune DB2

    DB2 instrumentation facility
      - Set up and handle DB2 traces for both continuous monitoring and for problem analysis
      - Relate when to start with statistics or with accounting reports, depending on the situation
      - Decide how to monitor and tune in your environment
      - Discuss basic principles of reading and understanding monitor reports

    DB2 workload
      - Describe how various types of processing are reflected on the reports
      - Find basic workload information on Statistics and Accounting reports
      - Break down a program's elapsed time into the individual components
      - Control the maximum number of jobs that can concurrently exist  within DB2

    Lab exercise part I
      - Examine standard reports to determine the workload for the lab environment

    Operating system and hardware considerations
      - Discuss operating system and hardware topics with other systems people
      - Describe the features and limits of certain hardware
      - Relate DB2-originated reports with system-originated reports

    The DB2 system
      - Monitor current usage (behavior) of important parts of DB2
      - Differentiate between good and bad behavior
      - Turn the tuning knobs on the DB2 system level
      - Assist application developers to exploit (if needed) certain features on the DB2 system level
      - Explain to application developers some things they should not do

    Lab exercise part II
      - Tune the DB2 subsystem, including the Internal Resource Lock Manager (IRLM), using statistics short and long reports and the system parameters report
      - Using these reports, determine the bottlenecks within the DB2 system

    Locking and concurrency
      - Monitor the working of DB2's concurrency mechanism
      - Report unusual events to application developers
      - Provide detailed reporting to enable application developers to solve certain problems
      - Adjust DB2 system control knobs

    The DB2 attachments
      - Obtain accounting information from the different environments (Time Sharing Option (TSO), CICS, and Information Management System (IMS))
      - Recognize accounting anomalies that may occur
      - Take measures to increase/decrease the maximum amount of work that can flow into DB2
      - Take measures to prevent query users from overloading your system
      - Apply performance options in the CICS and IMS interfaces to DB2

    DB2 utilities
      - Identify potential benefits and dangers of allowing utilities and applications to run together (the modern world)
      - Tune (or advise on tuning) general issues in DB2 utilities
      - Provide utility execution details by means of DB2 trace data

    Lab exercise part III
      - Using the accounting detail report, determine the performance problems causing two CICS transactions to exhibit an extremely high CLASS 1 elapsed time

    Managing DB2 performance
       - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of: monitoring and tuning DB2
       - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of discussing DB2 performance topics with system individuals
       - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of discussing DB2 performance topics with application individuals

    *Precio no incluye IVA

Últimas consultas al curso

realiza tu consulta al centro

"Me interesa saber la programacion del Curso de DB2 for Z/OS, para tunning y performance, trayectorias de acceso, etc.para el siguiente semestre. "

Manuel para Curso de DB2 for Z/OS System Performance and Tuning CF881MX

México

Otra formación relacionada con Ingeniería del Software

Este sitio utiliza cookies.
Si continua navegando, consideramos que acepta su uso.
Ver más  |