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

...policies and procedures, deliberate attention is given to high availability and data integrity issues. Objectives: Upon completion of this presentation...

...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 the disk subsystem...

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

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

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

...(without hands-on)/ 3 days (with hands-on)Audience:DB2 developers, production DBAs and technical DBAs.Prerequisites:At least six (6) months of DB2...

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

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

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

...Create/Alter/Drop DB2 objects Data Manipulation Language (DML) Predicates NULL considerations INNER JOINs OUTER JOINs UNIONs CASE expressions GROUP...

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

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

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

...DISPLAY GROUP Statistics reports Accounting reports And the like. Objectives:Upon completion of this presentation, the participant should be able to understand...

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

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