• Objetivos del Cursos:

  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

• Cursos 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 del Cursos:

  Certification IBM DB2 UDB Version 8 for z/OS Database Administration

• Contenido del Cursos:

  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

Cursos y master en Mexico - Cursos y master en Chile - Cursos e mestrados no Brasil - Cursos y master en Argentina

Formations et masters en France - Corsi e master in Italia - Cursos y master en Colombia

Cursos y maestrías en Peru - Cursos y maestrías en Ecuador