Curso de DB2 UDB for Z/OS and OS/390 Database Administration Part 2 CF831MX
Modalidad de imparticiónLa modalidad de impartición del programa es presencial.
Número de horasPreguntar.
Titulación oficialCertification IBM DB2 UDB Version 8 for z/OS Database Administration.
Valoración del programaEste 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 cursoConsultar.
Dirigido aEste 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.
EmpleabilidadAl terminar estarás mejor capacitado para trabajar en el campo de la tecnología y la administración.
Curso de DB2 UDB for Z/OS and OS/390 Database Administration Part 2 CF831MX
Objetivos del cursoExecute 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ácticasNine labs are included to address database administration using DB2 UDB for z/OS Version 8.
Curso dirigido aThis 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ónCertification IBM DB2 UDB Version 8 for z/OS Database Administration
ContenidoKEY 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