Formations DB2

Page 4 sur 11
XXL Formation
Introduction à DB2 for z/osPar XXL Formation

Sensibiliser les participants au vocabulaire et aux principes généraux d’un développement d’une application sous un SGBD DB2.

Global Knowledge
DB2 12 for z/OS : Administration de la base de donnéesPar Global Knowledge

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Feel Europe
Analyste d'exploitation DB2 FOR ZOSPar Feel Europe
  • Connaître le principe du logging, de la sauvegarde et du recouvrement des données
  • Connaître les objets de DB2
  • Savoir gérer les utilitaires DB2 et leur reprise
  • Comprendre et maîtriser les besoins de réorganisation des objets DB2
  • Assurer le suivi des bases DB2
  • Savoir charger et décharger les données
  • Apprendre le rôle et la codification des commandes DB2
Feel Europe
Les apports de DB2 V10Par Feel Europe
  • Connaitre et tirer profit des nouvelles fonctionnalités de DB2 V10.x
Global Knowledge
Db2 12 for z/OS Introduction to System AdministrationPar Global Knowledge

This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

Global Knowledge
DB2 10.5 Administration Workshop for WindowsPar Global Knowledge

This course teaches database administrators to perform basic database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating database objects like tables, indexes and views, and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference DB2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements, adding indexes to improve SQL performance. We will cover the locking performed by DB2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing DB2 native encryption for a database.

The lab exercises are performed using DB2 LUW 10.5 for Windows. For some exercise tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.

Global Knowledge
IBM - Concept et présentation de l'éditique AFPPar Global Knowledge

Ce cours a pour but de présenter les différentes possibilités de l'Architecture AFP , les différentes ressources utilisables ( PAGEDEF, FORMDEF, OVERLAY, FONT (polices d'impression), ...), et les logiciels permettant de les créer.