Wise courses

...Upon completion of this presentation, the participant should be able to exploit the DB2 Optimizer in deciding which of several SQL alternatives will provide...

...the topics covered in this course are: Creating triggers INSERT, UPDATE and DELETE triggers Trigger interactions with referential constraints INSTEAD...

...Summary: This workshop-based course focuses on how to exploit the following DB2 facilities in the management of DB2 data: IMPORT EXPORT LOAD REORG RUNSTATS...

...data Configure and tune the DB2 UDB system Scale the configuration (e.g., Adding a partition(s) Optimise capacity (e.g., Memory, logging, etc...

...How to organise and implement performance, monitoring and tuning How to optimally size the RDBMS How to determine server requirements How to optimise...

...similarities and sameness with regards DB2 LUW and DB2 z/OS; with this in mind, we focus on the following: Architecture Schema objects DB2 limits DB2 object...

...be able to think clearly in terms of DB2's features, objects and capabilities...

...Integration with System z Scalability Availability Commands and utilities Data sharing SQL: DML, DDL and DCL Application enhancements XML Security Performance...

...(without hands-on)/ 3 days (with hands-on)Audience:DB2 developers, production DBAs and technical DBAs.Prerequisites:At least six (6) months of DB2...

...relational concepts, utilities, SQL, Application Programming Interfaces (APIs), security, etc.Objectives:Upon completion of this course, the participant...

...and Capacity Planners.Prerequisites:A working knowledge of DB2 objects and architecture.Summary:This course places particular emphasis on the monitoring...

...programming exercises to which solutions are provided.Objectives:Upon completion of this course, the delegate should be bale to use basic SQL via SPUFI on host language (e...

...data stored in one-or-more tables. Audience:Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity...

...limits of SQL operations such as: INNER JOINs OUTER JOINs UNIONs CASE expressions Subqueries Subselects Table expressions Row expressions Column/scalar...

...choices ZPARM choices IRLM choices Objectives:Upon completion of this presentation, the participant should be conversant with how the DB2 Optimizer...

...(Designers and Programmers), Database Administrators, System Administrators and Capacity Planners. Environment:Non-data sharingAudience:Application Developers...

...the delegate should understand the scope and limits of DB2 locking choices such that locking definition, management, monitoring and tuning is less of a challenge...

...Upon completion of this presentation, the participant should be able to understand: The DB2 data sharing environment. DB2 locking in a data sharing environment...

...Massive update alternatives Checkpoint/restart Parallelism Prefetch (sequential and dynamic) Objectives: Upon completion of this presentation...

...able to use DB2 related accounting, statistics and EXPLAIN reports to monitor and tune: SQL Index usage and design The DB2 subsystem in general The...