IBM DB2 11 for zOS Database Administration Workshop Part 2
Skills Gained
- 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
Who Can Benefit
Database Administrators and System Programmers who would like to get further insight into database administration tasks.
Prerequisites
DB2 11 for z/OS Database Administration Part 1 (CV832) or equivalent experience or knowledge.
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
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date