DB2 11 for zOS Database Administration Workshop Part 2 (CV843G) – Outline

Detailed Course Outline

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 program 2: 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 versioning 3: 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 changes 4: 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

5: Archive-enabled tables • Describe transparent archiving • Understand archive-enabled and archive tables 6: Temporal tables • Understand the need for temporal tables • Utilize System Time temporal tables • Utilize Business Time temporal tables • Utilize Bitemporal tables 7: Partition management part 1 • Add partitions • Rotate partitions 8. Partition management part 2 • Modify limit keys • Rebalance partitions 9. Stored procedures part 1 • Explain what a stored procedure is • Describe how to implement and maintain stored procedures • Discuss types of stored procedures • Define external stored procedures • Examine DB2 commands affecting stored procedures 10. Stored procedures part 2 • Examine native SQL stored procedures • Explain native SQL procedure versioning and deployment