Db2 11.1 Advanced Database Administration (CL464G)

 

Quién debería asistir

This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases

Prerrequisitos

  • Perform basic database administration tasks for a Db2 database server, including using Db2 commands like BACKUP and RESTORE
  • Utilize Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
  • These skills can be developed by taking:
    • CL207 Db2 11.1 Administration Workshop for Linux

Contenido del curso

This course is designed to teach you how to: • Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. • Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. • Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. • Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. • Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. • Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. • Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. • Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. • Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. • Implement Db2 Self Tuning Memory management for specific database memory areas.

 

Classroom training

Duración 2 días

Precio (sin incluir impuestos)
  • Argentina: US$ 1.340,-
  • Brasil: US$ 1.340,-
  • Chile: US$ 1.340,-
  • Colombia: US$ 1.340,-
  • México: US$ 1.340,-
  • Perú: US$ 1.340,-
Entrenamiento en línea

Duración 2 días

Precio (sin incluir impuestos)
  • Argentina: US$ 1.340,-
  • Brasil: US$ 1.340,-
  • Chile: US$ 1.340,-
  • Colombia: US$ 1.340,-
  • México: US$ 1.340,-
  • Perú: US$ 1.340,-
 
Presionar el boton sobre el nombre de la ciudad para reservar Calendario
Este es un curso en línea Guiado por un Instructor
América Latina
Argentina
Sep 21, 2020 ― Sep 22, 2020 Entrenamiento en línea Zona Horaria: America/Buenos_Aires Lenguaje del curso: Español Inscripción
Brasil
Apr 23, 2020 ― Apr 24, 2020 Entrenamiento en línea Zona Horaria: America/Sao_Paulo Lenguaje del curso: Portugués Inscripción
Sep 21, 2020 ― Sep 22, 2020 Entrenamiento en línea Zona Horaria: America/Sao_Paulo Lenguaje del curso: Portugués Inscripción
Chile
Apr 23, 2020 ― Apr 24, 2020 Entrenamiento en línea Zona Horaria: America/Santiago Lenguaje del curso: Español Inscripción
Europa
Alemania
May 18, 2020 ― May 19, 2020 Entrenamiento en línea Zona Horaria: Europe/Berlin Lenguaje del curso: German Inscripción
Suiza
Apr 27, 2020 ― Apr 28, 2020 Basel * Inscripción
Apr 27, 2020 ― Apr 28, 2020 Entrenamiento en línea Zona Horaria: Europe/Zurich Lenguaje del curso: German * Inscripción
Jun 8, 2020 ― Jun 9, 2020 Bern * Inscripción
Jun 8, 2020 ― Jun 9, 2020 Entrenamiento en línea Zona Horaria: Europe/Zurich Lenguaje del curso: German * Inscripción
Sep 21, 2020 ― Sep 22, 2020 Ginebra * Inscripción