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

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

...the participant should be competent to organise and invoke DB2 utilities and commands to: Manage DB2 and application data resources Recover from transaction...

...Optimise database organisation and placement. Currency:V8 & V9Audience:System Administrators and Database Administrators.Prerequisites:Completion of...

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

...Upon completion of this presentation, the delegate should be able to think clearly with regards DB2 UDB for LUW and DB2 for z/OS functional differences and likeness...

...pon completion of this course, the participant should be able to think clearly in terms of DB2 UDB's features, objects and capabilities. Audience...

...Upon completion of this presentation, the delegate should havev a comprehensive understanding of DB2 for z/OS new features, including: Integration...

...Suitable for: DB2 developers, production DBAs and technical DBAs. DB2 developers, production DBAs and technical DBAs. Level:Intermediate to advancedDuration:2...

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

...Upon completion of this presentation, the participant should be able to: Plan performance tuning. Determine which tools to use. Measure system performance...

...developers.Prerequisites:At least six (6) months of IT mainframe experience.Summary:This 'hands-on' DB2 UDB programming workshop for z/OS details...

...least 6 months experience in an MVS environment.Summary:This course focuses on the scope and limits of SQL operations such as: Overview of Data Definition Language (DDL)...

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

...z/OS chooses an access path, how the user can override the chosen access path...

...Suitable for: Application Developers (Designers and Programmers), Database Administrators, System Administrators and Capacity Planners. Application Developers...

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

...Database Administrators and Capacity Planners.Prerequisites:A working knowledge of data sharing in a z/OS environment.Summary:The, mainly, locking performance...

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

...system dependencies Workloads in terms of threads, etc. Data set placement and management Index design and usage Buffer pool usage Locking and concurrency...