Contenido
KEY TOPICS
Program preparation and use of packages
- Successfully go through the program preparation steps and execute programs in DB2 environment using the Time Sharing Option (TSO) attachment facility
- Understand how to 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
- Handle mirror tables
- Understand package versioning
Online schema enhancements
- Understand how to change data types and lengths of columns
- Understand how to alter or add an index to have true VARCHAR columns
- Understand how to unbundle partitioning and clustering
LOAD and REBUILD INDEX performance and availability
- Evaluate how these enhancements can be used in your installation
REORG and UNLOAD performance and availability
- Apply the performance features for REORG: SORTDATA, NOSYSREC, SORTKEYS
- Use the availability features for REORG: read-only online REORG, that is, SHRLEVEL REFERENCE; full online REORG, that is, SHRLEVEL CHANGE
- Establish inline statistics during REORG
- Unload data from table spaces and image copy data sets
Partition management
- Understand how to add partitions
- Understand how to rotate partitions
- Understand how to rebalance partitions
Generic utility jobs
- Provide reusable list definitions for use by DB2 utilities
- Use list definitions in utility control statements and understand how they expand
- Describe the concept and working of templates replacing utility Dataset Definition (DD) statements
- Use templates in utility jobs to simplify Job Control Language (JCL)
- Use templates together with list definitions
- Use the OPTIONS utility control statement to control execution parameters for utility jobs
User-defined Distinct Types (UDT), User-Defined Functions (UDF) and stored procedures
- Identify the need for schemas, define schemas, and use schemas
- Use schemas in the PATH BIND option
- Identify the need for UDTs, define UDTs, and use UDTs
- Differentiate between external scalar functions, external table functions, SQL scalar functions, and sourced functions
- Determine which UDF or stored procedure is invoked, given the invocation statement and existing functions or procedures
- Identify privileges associated with schemas, UDTs, and stored procedures
- Differentiate between the capabilities of UDFs and stored procedures
- Define a UDF
- Define a stored procedure
Triggers
- Identify benefits of triggers
- List characteristics of BEFORE and AFTER triggers and functions that can be performed by them
- Specify trigger granularity
- Define a trigger
- Use transition variables and transition tables within triggers
- Identify privileges associated with trigger definition
- Describe the trigger package
Large objects
- Identify the data types of large objects
- Explain the relationship between the base table and the auxiliary table
- Define large objects
- Identify the use of ROWIDs with large objects
- List alternative ways to process large objects within applications
- Evaluate locking considerations when processing large objects
- Identify considerations when loading tables with large objects
Performance-related topics
- Understand why performance is important
- Evaluate how table implementation impacts performance
- Understand the basics of the queuing theory
- Cool hot spots
Extensive machine lab exercises
*Precio no incluye IVA
