IBM - DB2 9 for z/OS - Database Administration Workshop Part 2

PROKODA Gmbh
In Hamburg

1.890 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

  • Workshop
  • Hamburg
  • Dauer:
    4 Tage
Beschreibung

IBM - DB2 9 for z/OS - Database Administration Workshop Part 2: Zielgruppe This intermediate course is for Database Administrators and System Programmers who would like to get in insight view of database administration tasks. Kursziele Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages Alter table..
Gerichtet an: Zielgruppe This intermediate course is for Database Administrators and System Programmers who would like to get in insight view of database administration tasks. Kursziele 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 Alter indexes to add columns or to change the varying length or...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Hamburg
Nagelsweg 55, 20097, Hamburg, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

You should have completed: DB2 9 for z/OS Database Administration Workshop Part 1 (CV830DE) or have attained a similar level of experience

Themenkreis

KURSZIEL
IBM - DB2 9 for z/OS - Database Administration Workshop Part 2: Zielgruppe
This intermediate course is for Database Administrators and System Programmers who would like to get in insight view of database administration tasks.
Kursziele
  • 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
  • Alter indexes to add columns or to change the varying length or clustering characteristics of the index, and identify the impact of making such changes
  • React to the "Advisory Reorg" Database Exception Table state
  • Make appropriate decisions to successfully handle table space versions
  • Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
  • Determine the applicability and implement clone tables, user-defined distinct types, user-defined functions, stored procedures, triggers, and large objects


ZIELGRUPPE
Zielgruppe
This intermediate course is for Database Administrators and System Programmers who would like to get in insight view of database administration tasks.
Kursziele
  • 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
  • Alter indexes to add columns or to change the varying length or clustering characteristics of the index, and identify the impact of making such changes
  • React to the "Advisory Reorg" Database Exception Table state
  • Make appropriate decisions to successfully handle table space versions
  • Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
  • Determine the applicability and implement clone tables, user-defined distinct types, user-defined functions, stored procedures, triggers, and large objects


KURSINHALT
This is the classroom version of the Instructor Led Online course DB2 for z/OS - Database Adminn Workshop P2 - ILO (3V841DE)
This course provides lectures and hands on lab exercises for database administrators in a DB2 for z/OS environment. You are expected to learn DBA related topics which we would not necessarily consider advanced, but not necessarily needed in order to be able to start working as database administrator and perform basic administrative tasks.
This course is supposed to be an enhanced subset of the former DB2 for z/OS Database Administration Workshop Part 2 (CV840DE) couse which covered all the units that are also covered in this course plus the utilities oriented topics which we have decided to take out of this course and offer a separate course DB2 9 for z/OS - Utilities for Database Administrators (CV8700DE) covering more really advanced database administrator utility topics.
The skills taught in this course include more in-depth program preparation knowledge, the use of Online Schema changes, Partition Management, UDTs, UDFs and Stored Procedures, Triggers, and LOBs.
Themenübersicht
Day 1
  • Welcome
  • Unit 1: Transition from CV830 to CV841
  • Unit 2: Program Preparation and Use of Packages
  • Exercise 1: Program Preparation
  • Unit 3: Online Schema Changes
  • Exercise 2: Online Schema Changes
Day 2
  • Unit 4: Clone Tables
  • Exercise 3: Clone Tables
  • Unit 5: Partition Management
  • Exercise 4: Partition Management
  • Unit 6: UDTs and UDFs
  • Exercise 5: UDTs and UDFs
Day 3
  • Unit 7: Stored Procedures
  • Exercise 6: Stored Procedures
  • Unit 8: Triggers
  • Exercise 7: Triggers
  • Unit 9: Large Objects
  • Exercise 8: LOBs


VORRAUSSETZUNG
You should have completed:
  • DB2 9 for z/OS Database Administration Workshop Part 1 (CV830DE)
  • or have attained a similar level of experience

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen