DB2 Universal Database Approfondissement

Duration

2,00 day(s)

Language(s) of service

EN FR

Next session

Who is organizing this training?

Dawan is a training organisation that offers more than 2000 training courses in IT, management, project management and sales in instructor-led live online or on-site trainings. We have 11 centres in France and we have developed partnerships with local structures in Brussels, Luxembourg and Geneva. Our catalogue includes hundreds of topics: Java, PHP, Webmaster, E-Marketing, Linux, Windows Server, Vmware, Autocad, Photoshop, IA etc. Our courses have been created and designed by in-house trainers who have over 20 years of teaching experience. Constantly renewed, they are adapted to the requirements of our customers and to the evolution of technologies.

The content of this page is not available in English

Who is the training for?

Tous

Prerequisites

Notions d'administration DB2

Goals

Réaliser des schémas et requêtes quelconques sur DB2-UDB - Connaître les fonctionnalités principales du serveur - Installer, maintenir, administrer et optimiser un serveur DB2 UDB.

Introduction

Rappels d'installation et de maintenance générale de DB2-UDB
Présentation d'une base existante

Importation et exportation des données

Présentation
Formats manipulés: fichiers WSF, DEL, ASC, IXF
Commandes disponibles et supervision par le centre de contrôle

Logging et restauration

Présentation de l'unité de recovery
Journaux (Logging circulaire/linéaire)
Sauvegarde: images, mise en place et paramétrage de l'outil BACKUP
Les utilitaires RESTORE et ROLLFORWARD: utilisation, optimisation