Wise courses

...Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners. This course focuses on tuning advanced...

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

...course Database Administration or equivalent knowledge.Summary:This course is designed to assist DB2 UDB system administrators in monitoring and tuning the DB2 for LUW system...

...How to organise and implement performance, monitoring and tuning How to optimally size the RDBMS How to determine server requirements How to optimise...

...creation and maintenance DB2 address spaces DB2 storage model DB2 tools Locking and concurrency I/O concepts DB2 optimizer Backup and recovery utilities...

...be able to think clearly in terms of DB2's features, objects and capabilities...

...and best practices (summarized) Installation and migration. Suitable for: Database Administrators, System Administrators and Capacity Planners. Database Administrators...

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

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

...to optimise SQL statements in terms of elapsed, CPU and I/O times.Objectives:Upon completion of this presentation, the participant should be able to exploit...

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

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

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

...able to use DB2 related accounting, statistics and EXPLAIN reports to monitor and tune: SQL Index usage and design The DB2 subsystem in general The...