Wise courses

...reduced elapsed times, CPU and I/O. Suitable for: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners...

...triggers Trigger granularity Trigger activation time Transition variables & transition tables Triggered action Multiple triggers Synergy between triggers...

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

...Optimise database organisation and placement...

...How to optimise physical database design. How to optimise the use of utilities. How to optimise SQL Currency:V8 & V9Audience:System Administrators...

...Performance/monitoring tools Security and authorisation Performance and tuning issues Objectives:Upon completion of this presentation, the delegate should...

...between SQL Server and DB2 for LUW, the presentation then elaborates on the scope and limits of DB2 in terms of its architecture, objects...

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

...Upon completion of this presentation, the participant should be able to use DB2 for z/OS V8 & V9's interactive and embedded SQL to meet a variety of business needs...

...Summary:Delegates attending this introduction to DB2 in general and DB2 for z/OS, V8/V9, in particular would acquire a comprehensive introduction to IBM DB2 architecture...

...to use Measure system performance Determine if subsystem will be cost-effective Determine the cause of performance problems Decide when and what to...

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

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

...the DB2 Optimizer in deciding which of several SQL alternatives will provide reduced elapsed times, CPU and I/O.Lab:About 65% hands-on, incorporating...

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

...useful and practical recommendations to both online (e.g., CICS) and batch processes.Objectives:Upon completion of this presentation, the delegate should...

...The DB2 data sharing environment DB2 locking in a data sharing environment How to use performance tools such as a DB2 PM and -DISPLAY commands to monitor...

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

...I/O subsystem The DB2 buffer pools Sort pools IRLM (lock manager) Applications...