Recherche cours

Domaine

Titre

Référence satom

Référence externe

DB2 11 for zOS Database Administration Workshop Part 2

Durée:

3

Langue:

DE

Prix:

2869.25

Description:

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.

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

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

1: Program preparation and the use of packages part 1â¢ Go through the program preparation steps and execute programs in the DB2 environment using the TSO Attachment Facilityâ¢ Resolve some of the most commonly occurring problems, for example SQL error -805â¢ Understand the importance of collections and packagesâ¢ Understand how to access different tables and views at execution time without changing the program2: Online schema changes part 1â¢ Discuss immediate, online schema changesâ¢ Change data types and lengths of columnsâ¢ Rename indexesâ¢ Add columns to indexesâ¢ Relate implications of renaming a column in a table or renaming an indexâ¢ Describe versioning3: Online schema changes part 2â¢ Explore pending schema changesâ¢ Materialize pending schema changesâ¢ Drop a columnâ¢ Migrate existing classic table space types to UTSâ¢ Change table space characteristics such as DSSIZE, page size, and SEGSIZEâ¢ Take care of the implications of applying those pending online schema changes4: UDFsâ¢ Differentiate between external scalar functions, external table functions, SQL scalar functions, and sourced functionsâ¢ Determine which user-defined function will be invoked given the invocation statementâ¢ Create a user-defined function