Wise courses

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

...Production DBAs, Database Administrators and Capacity Planners.Prerequisites:Completion of our course DB2 SQL Essentials or equivalent knowledge.Summary:Among...

...db2look Database backup Database restore Rollforward Logging While emphasis is placed on planning and implementing sound DB2 UDB backup, restore and recovery...

...In particular, emphasis is placed on: Memory usage Buffer pool tuning Prefetching I/O design Table design Index design Configuration parameters...

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

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

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

...Tune DB2 subsystem facilities Duration:4 days (non-data sharing) 5 days (including data sharing)Audience:Database Administrators, System Administrators...

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

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

...functions Date/time arithmetic Cursor operations Locking & concurrency Index design & usage this course focuses on using Visual Explain V8 for DB2...

...how the user can override the chosen access path, etc. Audience:Database Administrators, System Administrators, Application Developers, Programmers...

...Upon completion of this presentation, the delegate should be able to make application-based locking choices that maximise currency and control deadlock/timeouts and 'hot spots'...

...this course focuses on everything the DBA should understand about the internals of DB2 locking in a non-data sharing environment. Equipped with such knowledge...

...and tune locking in a DB2 data sharing environment...

...the delegate should be able to make use of batch application design guidelines which, when adopted, can improve overall batch program performance on system availability...

...Non-data sharing Audience: Production DBAs, Capacity Planners, Database Administrators and System Administrators. Prerequisites: A working knowledge of DB2 objects...