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

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