Schulung - IBM CV843G - DB2 11 for zOS Database Administration Workshop Part 2

  • Live Online oder Präsenz
Download als PDF
DURCHFÜHRUNG MIT TERMIN
Nr.
30012

Dauer
24h00

Preis
2.400,00 € netto
2.856,00 € inkl. 19% MwSt.

TERMIN UND ORT NACH ABSPRACHE
On-demand Training
Sind Sie an diesem Thema interessiert?
Unsere Experten entwickeln Ihr individuell angepasstes Seminar!

Teilen Sie dieses Seminar

Overview

This course teaches database administrators various features they must be familiar with as DB2 11 for z/OS Database Administrators. These include program preparation, online schema changes, user defined functions, archive-enabled and temporal tables, partition management, stored procedures, and triggers. The course includes many hands-on demonstrations which give the students experience with the included topics.  Additionally, there is information on other features in the course appendices, including schemas and user defined data types, clone tables, materialized query tables, large objects, global variables, and row permissions and column masks.  This course is a follow-on course to CV832 – IBM DB2 11 for z/OS Database Administration Workshop Part 1.   Note: This course is 3 days in length.  If the instructor has time, he can cover the optional appendices as desired.

Lesen Sie mehr
Zielgruppe

Wer sollte teilnehmen:

Zielgruppe

Audience

Database Administrators and System Programmers who would like to get further insight into database administration tasks.

Voraussetzungen

Prerequisites

DB2 11 for z/OS Database Administration Part 1 (CV832) or equivalent experience or knowledge.

Trainingsprogramm

Trainingsprogramm

Course Outline

1: Program preparation and the use of packages part 1Go through the program preparation steps and execute programs in the DB2 environment using the TSO Attachment FacilityResolve some of the most commonly occurring problems, for example SQL error -805Understand the importance of collections and packagesUnderstand how to access different tables and views at execution time without changing the program2: Online schema changes part 1Discuss immediate, online schema changesChange data types and lengths of columnsRename indexesAdd columns to indexesRelate implications of renaming a column in a table or renaming an indexDescribe versioning3: Online schema changes part 2Explore pending schema changesMaterialize pending schema changesDrop a columnMigrate existing classic table space types to UTSChange table space characteristics such as DSSIZE, page size, and SEGSIZETake care of the implications of applying those pending online schema changes4: UDFsDifferentiate between external scalar functions, external table functions, SQL scalar functions, and sourced functionsDetermine which user-defined function will be invoked given the invocation statementCreate a user-defined function

5: Archive-enabled tablesDescribe transparent archivingUnderstand archive-enabled and archive tables6: Temporal tablesUnderstand the need for temporal tablesUtilize System Time temporal tablesUtilize Business Time temporal tablesUtilize Bitemporal tables7: Partition management part 1Add partitionsRotate partitions8. Partition management part 2Modify limit keysRebalance partitions9. Stored procedures part 1Explain what a stored procedure isDescribe how to implement and maintain stored proceduresDiscuss types of stored proceduresDefine external stored proceduresExamine DB2 commands affecting stored procedures10. Stored procedures part 2Examine native SQL stored proceduresExplain native SQL procedure versioning and deployment

Objective

  • Introduce program preparation and the use of packages
  • Discuss immediate and pending online schema changes
  • Utilize UDFs
  • Utilize archive enabled tables
  • Utilize temporal tables
  • Manage partitions
  • Utilize Stored Procedures
  • Work with Triggers

Schulungsmethode

Schulungsmethode

presentation, discussion, hands-on exercises

Weitere Informationen

Weitere Informationen

Termine und Orte

Sortieren nach:

  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
Schulung - IBM CV843G - DB2 11 for zOS Database Administration Workshop Part 2