Curso de DB2 UDB for Z/OS and OS/390 Database Administration Part 2 CF831MX

Análisis de educaedu

Pablo Nieves

Curso de DB2 UDB for Z/OS and OS/390 Database Administration Part 2 CF831MX

• Modalidad de impartición
  La modalidad de impartición del programa es presencial.
• Número de horas
  Preguntar.
• Titulación oficial
  Certification IBM DB2 UDB Version 8 for z/OS Database Administration.
• Valoración del programa
  Este curso te ofrece ejecutar la preparación del programa incluyendo los pasos para resolver problemas comunes, la definición de las colecciones y los paquetes y las versiones de los paquetes, de alterar las características de la tabla, tales como tipos de datos de las columnas, entre otros.
• Precio del curso
  Consultar.
• Dirigido a
  Este es un curso intermedio para DB2 UDB para z/OS a los administradores de bases de datos, que tienen los conocimientos básicos necesarios para administrar una base de datos DB2 y que desean ampliar sus conocimientos.
• Empleabilidad
  Al terminar estarás mejor capacitado para trabajar en el campo de la tecnología y la administración.

Comentarios sobre Curso de DB2 UDB for Z/OS and OS/390 Database Administration Part 2 CF831MX - Presencial - Álvaro Obregón - CDMX - Ciudad de México

• Objetivos del curso
  Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages Alter table characteristics, such as data types of columns, and identify the impact of making such changes
• Prácticas
  Nine labs are included to address database administration using DB2 UDB for z/OS Version 8.
• Curso dirigido a
  This is an intermediate course for DB2 UDB for z/OS database administrators who have the basic skills required to administer a DB2 database and who want to extend their skills.
• Titulación
  Certification IBM DB2 UDB Version 8 for z/OS Database Administration
• Contenido
  KEY TOPICS
  
  Program preparation and use of packages
      - Successfully go through the program preparation steps and execute programs in DB2 environment using the Time Sharing Option (TSO) attachment facility
      - Understand how to resolve some of the most commonly occurring problems, for example SQL error -805
      - Understand the importance of collections and packages
      - Understand how to access different tables and views at execution time without changing the program
      - Handle mirror tables
      - Understand package versioning
  
  Online schema enhancements
      - Understand how to change data types and lengths of columns
      - Understand how to alter or add an index to have true VARCHAR columns
      - Understand how to unbundle partitioning and clustering
  
  LOAD and REBUILD INDEX performance and availability
      - Evaluate how these enhancements can be used in your installation
  
  REORG and UNLOAD performance and availability
      - Apply the performance features for REORG: SORTDATA, NOSYSREC, SORTKEYS
      - Use the availability features for REORG: read-only online REORG, that is, SHRLEVEL REFERENCE;  full online REORG, that is, SHRLEVEL CHANGE
      - Establish inline statistics during REORG
      - Unload data from table spaces and image copy data sets
  
  Partition management
      - Understand how to add partitions
      - Understand how to rotate partitions
      - Understand how to rebalance partitions
  
  Generic utility jobs
      - Provide reusable list definitions for use by DB2 utilities
      - Use list definitions in utility control statements and understand how they expand
      - Describe the concept and working of templates replacing utility Dataset Definition (DD) statements
      - Use templates in utility jobs to simplify Job Control Language (JCL)
      - Use templates together with list definitions
      - Use the OPTIONS utility control statement to control execution parameters for utility jobs
  
  User-defined Distinct Types (UDT), User-Defined Functions (UDF) and stored procedures
      - Identify the need for schemas, define schemas, and use schemas
      - Use schemas in the PATH BIND option
      - Identify the need for UDTs, define UDTs, and use UDTs
      - Differentiate between external scalar functions, external table functions, SQL scalar functions, and sourced functions
      - Determine which UDF or stored procedure is invoked, given the invocation statement and existing functions or procedures
      - Identify privileges associated with schemas, UDTs, and stored procedures
      - Differentiate between the capabilities of UDFs and stored procedures
      - Define a UDF
      - Define a stored procedure
  
  Triggers
      - Identify benefits of triggers
      - List characteristics of BEFORE and AFTER triggers and functions that can be performed by them
      - Specify trigger granularity
      - Define a trigger
      - Use transition variables and transition tables within triggers
      - Identify privileges associated with trigger definition
      - Describe the trigger package
  
  Large objects
      - Identify the data types of large objects
      - Explain the relationship between the base table and the auxiliary table
      - Define large objects
      - Identify the use of ROWIDs with large objects
      - List alternative ways to process large objects within applications
      - Evaluate locking considerations when processing large objects
      - Identify considerations when loading tables with large objects
  
  Performance-related topics
      - Understand why performance is important
      - Evaluate how table implementation impacts performance
      - Understand the basics of the queuing theory
      - Cool hot spots
  
  Extensive machine lab exercises
  
  *Precio no incluye IVA

Otra formación relacionada con ingeniería del software