50

You’ve been working with LOBS for a while now, but V10 has more opportunities to streamline your LOB processing. What’s up with this new INLINE LOB thing? How will it affect your processing? Is it worth messing with? This presentation will explain the structure of LOBs, discuss the benefits of using the new INLINE syntax, and give you a heads up on how they may impact your processing. I’ll also talk about the new DB2 10 options for processing LOB data.

pureScale architecture and components
pureScale installation and deployment
pureScale scalability
pureScale demo (on nanoCluster)
 

This presentation will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also discuss converting legacy programs to DB2 and how to best code for DB2 performance.

Have you seen how IBM made many security changes in DB2 9? With all the new possibilities in DB2 you can change your procedures to be compliant with the latest security standards. Klaas will review IBM’s blueprint on security and what and where it has been implemented in DB2 LUW like LBAC, SSL, Audit, Trusted Context, Roles and Security Administration. After this session you will be up-to-date with all the security changes and have an idea how they will impact your procedures when you implement them.

pureScale architecture and components
pureScale installation and deployment
pureScale scalability
pureScale demo (on nanoCluster)
 

Since DB2 version 9 we have the possibility to store XML natively in DB2 tables. It’s really cool, it’s really powerful… BUT how do you start? What are your options? Do my developers know how to deal with this? Does my DBA speak, Xpath, Xquery or am I looking at Xtra problems?
This presentation will start from the very basics and will explain both to developers as DBAs the possibilities, functionalities filled with working examples, that you can take home and start playing around with.

Tablespaces in DB2 (storage design)
Multi-temperature data management – new in DB2 10!(storage design)
Data Compression (storage design)
classic compression
adaptive compression – new in DB2 10!
index compression
temporary tables compression
XML/LOB compression
 

With today’s complex n-tier architectures and heterogeneous applications and platforms, optimization and availability can be a challenge, in addition, the ways on which DB2 communicates with its distributed clients is evolving and presents new challenges for monitoring and troubleshooting.
This presentation will explore and provide hints and tips on how to monitor and troubleshoot distributed access to DB2 for z/OS.

Features spotlight/features overview:
Faster Query Response, Improved Index Mgmt
Adaptive Compression
Multi-Temperature Data Management
SQL Compatibility enhancements
Row and Column Access Control
Temporal Capabilities
DB2 pureScale enhancements
Workload Management Enhancements
HADR Supports Multiple Standby Servers
DB2 Fundamentals (optionally)
 

IBM DB2 Analytics Accelerator has drawn lots of attention from DB2 for z/OS users. In many respects it presents itself as just another DB2 access path (but what a powerful one!) and its deep integration into DB2 as well as the application transparency makes it one of the most exciting DB2 enhancements in years. IDAA complements DB2 by adding industry leading data intensive complex query performance thanks to being powered by the Netezza engine and enhances DB2 to the ultimate database management system that delivers the best for both worlds: transactional as well as analytical workloads.
This presentation brings the latest news from the IDAA development and shows the trends and directions in which this technology develops.