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...

...Suitable for: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners. Application Developers...

...Recover from transaction failures. Recover from system failures. Recover from media (disk) failures. Use a variety of commands to monitor and manage recoverable resources...

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

...Upon completion of this presentation, the participant should understand the following as they relate to the optimal performance of IBM DB2 UDB database for...

...the delegate should be able to think clearly with regards DB2 UDB for LUW and DB2 for z/OS functional differences and likeness...

...DBAs and System Administrators. Prerequisites: At least 1-year of technical experience with SQL Server. Summary: After establishing a terminology match...

...and best practices (summarized) Installation and migration. Suitable for: Database Administrators, System Administrators and Capacity Planners. Database Administrators...

...Additionally, the participant should be able to use the full complement of DB2 EXPLAIN tools to determine the optimum SQL when faced with competing SQL alternatives...

...the participant should be literate with DB2 for z/OS, V8 & V9, per the 'Core Topics' in the detailed outline...

...Interpret relevant accounting and statistics reports Tune DB2 subsystem facilities Lab:Numerous exercises involving accounting reports, statistics reports and command displays...

...Additionally, the delegates should feel competent with program preparation steps involving BIND and REBIND. Audience:Would-be application programmers...

...Upon completion of this lab-oriented course, the delegate should be competent to code SQL SELECT, INSERT, UPDATE and DELETE statements to manipulate relational...

...reduced elapsed times, CPU and I/O. Currency:DB2 for z/OS V8Audience:Application Developers, Application Programmers, Production DBAs, Database Administrators...

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

...experience.Summary:Designed especially for Application Developers, this presentation's main focus is on how to design application processes that maximise...

...management, monitoring and tuning is less of a challenge. Environment:Non-data SharingAudience:Database Administrators, System Administrators and Capacity...

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

...Prerequisites: At least one (1) year of application development experience. Summary: For Developers, this presentation summarises effective batch application design...

...SQL. Index usage and design. The DB2 subsystem in general. The DB2 I/O subsystem. The DB2 buffer pools. Sort pools. IRLM (lock manager). Applications Environment...