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