Curso de DB2 9 Administration CF232MX

Contacta sin compromiso con IBM Traning Centro de Capacitación

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

Análisis de educaedu

Pablo Nieves

Pablo Nieves

Curso de DB2 9 Administration CF232MX

  • Modalidad de impartición
    La modalidad de impartición del curso es presencial.
  • Número de horas
    Consultar.
  • Titulación oficial
    Certificación de Administración de IBM DB2 9.
  • Valoración del programa
    Aprender a realizar tareas de administración de base de datos como la creación de instancias de DB2, crear y alimentar las bases de datos, diseño lógico y el uso de apoyo a los requisitos de concurrencia y la recuperación con DB2 9 para Linux, UNIX y Windows, entre otros.
  • Precio del curso
    Preguntar.
  • Dirigido a
    Este es un curso intermedio para los administradores de sistemas, administradores de base de datos y demás personal técnico, involucrado en la planificación, implementación y mantenimiento de DB2 para Linux, UNIX y Windows bases de datos.
  • Empleabilidad
    Al terminar habrás obtenido herramientas para administrar bases de datos.
¿quieres saber más sobre este curso?
Solicitar información

Comentarios sobre Curso de DB2 9 Administration CF232MX - Presencial - Álvaro Obregón - CDMX - Ciudad de México

  • Objetivos del curso
    Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 9 for Linux, UNIX, and Windows. New features, such as range partitioning, data row compression, and pureXML (native XML storage) will be introduced. Use a Linux operating system during hands-on labs.
  • Prácticas
    Eleven labs are included to address DB2 9 for Linux, UNIX, and Windows.
  • Curso dirigido a
    This is an intermediate course for system administrators, database administrators and other technical personnel involved in planning, implementing, and maintaining DB2 for Linux, UNIX and Windows databases.
  • Titulación
    Certification IBM DB2 9 Administration
  • Contenido
    KEY TOPICS

    Overview of DB2 9 on Linux, UNIX and Windows
        - Contrast the DB2 Family of products
        - Identify the DB2 Products
        - Describe the functions of DB2 components
        - Explore installation and parameters

    Command Line Processor (CLP) and GUI usage
        - Use the Command Line Processor
        - Explore the GUI environment
        - Describe the DAS role with GUI tools

    The DB2 environment
        - Specify the key features of an Instance
        - Create and drop an Instance
        - Use db2start and db2stop
        - Distinguish between types of configuration
        - Describe and modify the Database Manager Configuration

    Creating databases and data placement
        - Review specifics of creating a database
        - Explore the System Catalog tables and views
        - Compare DMS versus SMS table spaces
        - Describe how to setup and manage a DB2 database with Automatic Storage enabled
        - Differentiate between table spaces, containers, extents, and pages
        - Define table spaces
        - Use the get snapshot for tablespaces command to display table space statistics
        - Explore Database configuration parameters

    Creating database objects
        - List DB2 object hierarchy and physical directories and files
        - Create the following objects: Schema, Table, View, Alias, Index
        - Explore the use of table partitioning
        - Review the use of Temporary Tables
        - Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
        - Exploring the need for and the use of Large Objects
        - Recognize XML and its native store as critical infrastructure for emerging technologies

    Moving data
        - Discuss the INSERT statement and recognize its limitations
        - Explain the differences between IMPORT and LOAD
        - Explain the EXPORT, IMPORT, and LOAD syntax
        - Create and use Exception Tables and Dump-Files
        - Distinguish and resolve Table States: Load Pending and Set Integrity Pending
        - Use the SET INTEGRITY command
        - Discuss the db2move and db2look commands

    Backup and recovery
        - Describe the major principles and methods for backup and recovery
        - State the three types of recovery used by DB2
        - Explain the importance of logging for backup and recovery
        - Describe how data logging takes place, including circular logging and archival logging
        - Use the BACKUP, RESTORE, and ROLLFORWARD commands
        - Perform a table space backup and recovery
        - Restore a database to the end of logs or to a point-in-time
        - Discuss the configuration parameters and the recovery history file and use these to handle various backup and recovery scenarios

    Locking and concurrency
        - Explain why locking is needed
        - List objects that can be locked
        - Describe and discuss the various lock modes and their compatibility
        - Explain four different levels of data protection
        - Set isolation level and lock time out for current activity
        - Explain lock conversion and escalation
        - Describe the situation that causes deadlocks

    Problem determination
        - Collect information for problem analysis and resolution
        - Use error logs for basic problem analysis
        - Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, Health Monitor
        - Describe the function of EXPLAIN and use this facility to assist basic analysis
        - Use a series of basic commands to better work with connections and sessions
        - Retrieve statistics and other information from a running DB2 instance

    Application issues and performance
      - Prepare applications that access DB2 data for execution
      - Use PRECOMPILE and BIND options that are appropriate for specific application requirements
      - Describe the application alternatives available to access DB2 data or request other DB2 functions
      - List reasons for REBIND of application programs and execute this command
      - Define the concept of single dimensional clustering, and determine the proper cluster sequence, if any, for DB2 tables
      - Use RUNSTATS, REORGCHK, and REORG to enhance application performance
      - Work with the Explain facility

    Security
      - Use DB2 access control mechanisms to implement security within the database
      - Use group IDs to create a control hierarchy
      - Describe Label Based Access Control (LBAC)
      - Describe privileges within a database
      - Describe privileges required for binding and executing a package
      - Describe the difference between explicit privileges and implicit privileges
      - Describe the different DB2 authorization levels

    *Precio no incluye IVA

Últimas consultas al curso

realiza tu consulta al centro

"Quisiera obtener informacion vía email acerca de este curso. su temario, precio, localidad y horarios. "

Gustavo para Curso de DB2 9 Administration CF232MX

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  |