I/S Resource Group: Advanced DB2 UDB for UNIX, Training, Universal, UNIX, Windows, DB2, Relational, database, SQL, query, table, dynamic, CLI, scratch, temporary, large, object, transaction, commit, locking, EXPLAIN, log, statistics, bind, performance

Advanced DB2 UDB for UNIX

Abstract
(4 Days)

This course provides application programmers with insight into performance and advanced programming techniques for DB2 UDB for UNIX. It includes some database administration issues, as well as database utilities.

Audience

This course is open to any application programmer with a working knowledge of DB2 UDB.

Topics

UDB use of scratch database for temporary tables
UDB CLI interface
UDB large objects
UDB Locking
- Transactions and commit points
DB2 UDB Performance Issues
- Data/index placement
- EXPLAIN
- Logging size
- Network I/O – reduce RPC calls and data transfer
- Sorting
- Statistics gathering
- Binding/rebinding
UDB performance monitoring
Invoking utilities from application programs
Embedding DB2 command in shell scripts

Supervised Exercises

Each class session will be accompanied by a set of written/programming exercises designed to reinforce the classroom material.