Wise courses

...SQL via DB2 Explain facilities in terms of the following DB2 UDB features: Isolation levels Locking and concurrency Join optimisation Sequence and identity...

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

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

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

...DBAs and System Administrators. Prerequisites: At least 1-year of technical experience with SQL Server. Summary: After establishing a terminology match...

...Performance and best practices (summarized) Installation and migration As DB2 for z/OS V9 new features are detailed, performance and best practices are discussed and summarized...

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

...e.g.,Oracle, Sybase, SQL Server, etc. Those new to relational concepts but have worked with other DBMS (e.g., IMS) or file system (e.g., VSAM)...

...Interpret relevant accounting and statistics reports Tune DB2 subsystem facilities Lab:Numerous exercises involving accounting reports, statistics reports and command displays...

...Upon completion of this course, the delegate should be bale to use basic SQL via SPUFI on host language (e.g., COBOL) to maintain DB2 UDB...

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

...incorporating DB2 for z/OS V8 Visual Explain...

...Programmers and System Programmers.Prerequisites:A working knowledge of SQL predicate types, I/O types and SQL statements such as SELECTs, UPDATEs...

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

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

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

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