Wise courses

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

...Application Programmers, Production DBAs, Database Administrators and Capacity Planners. Currency:V8 & V9Audience:Application Developers, Application Programmers...

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

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

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

...System Administrators and Capacity Planners. Upon completion of this presentation, the delegate should havev a comprehensive understanding of DB2 for z/OS new features...

...optimum SQL when faced with competing SQL alternatives...

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

...Determine if subsystem will be cost-effective. Determine the cause of performance problems. Decide when and what to tune. Interpret relevant accounting and statistics reports...

...COBOL) to maintain DB2 UDB data. Additionally, the delegates should feel competent with program preparation steps involving BIND and REBIND...

...the delegate should be competent to code SQL SELECT, INSERT, UPDATE and DELETE statements to manipulate relational data stored in one-or-more tables...

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

...JOINs, UNIONs, etc.Summary:This course uses information gained from our instructor's empirical knowledge coupled with that gained from a variety of...

...concurrency while minimising locking overhead or CPU cycles in a non-data sharing environment.Objectives:Upon completion of this presentation...

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

...How to use performance tools such as a DB2 PM and -DISPLAY commands to monitor and tune locking in a DB2 data sharing environment. Environment:Data SharingAudience:System Administrators...

...In the interest of performance and availability, special emphasis will be placed on: Efficient SQL Index design in general Clustered indexes in particular...

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