33

Presentation will cover Intersect & Except, Instead of Triggers, Merge, Select from Merge, Update and Delete, Truncate, Order by and Fetch first in subselect; the new data types. Same presentation will be conducted at the DB2 Technical conference in Dusseldorf.
 

Cursors have been around since the birth of DB2, but many DBAs still struggle to come to terms with what they are and what they do. In addition, for the last few versions of DB2 there have been many enhancements - from scrollable cursors to multi-row operations, the cursors of today are very different from those of the "olden days".
 
 

With Unicode being dominantly present in Version 8 and the strict checking of CCSID’s during the migration to Version 8 a lot people started to discuss CCSID’s and Unicode. But what are CCSID’s? When does DB2 translate for me. Or better, when should DB2 translate and when not. How to interpret the output of the migration jobs? What is true about Unicode and what is plain non-sense? Klaas will try to guide you through the jungle so you can make a judgment yourself: do we have a problem or not? Some answers are surprising…
 

Will review the new common administration and application development tools that are part of the Viper II technology that will be available later this year. This will include runtime improvements (JDBC, CLI, Ruby, PHP, etc.), tooling improvements (.NET, DWB), and also data administration.
 

Service Oriented Architecture is a key enabler for structuring and connecting IT systems in a flexible manner that maps closely to the needs of the organization. SOA often means different things for different participants in the IT ecosystem, but its data aspect is of a crucial importance irrespective of the individual views. In developing SOA solutions, ignoring the state of organization?s data risks exposing data that could be misinterpreted, incomplete, or in some cases, wrong. Data and their inter-relationships are complex, and require understanding and interpretation to expose what is really needed and relevant. A vast amount of business data is managed by mainframes. SOA enables augmenting the value of that data and getting even more from the traditionally rich, secure and highly available computing infrastructure. This presentation will provide an overview of different techniques to unlock the additional value of your mainframe data in the SOA world.
 

This presentation takes a high level look at the new features and functions of the latest version of DB2 for the z/OS platform. As well as the much publicised XML support, there are many other new SQL, security and availability items. This session will give you a good overview of DB2 9 for z/OS
 
 

Presentation will be based on the material presented by Guogen Zhang at the Anaheim IOD and it will include some worked examples.  Simple demonstration wil be included in presentation accordingly to the network access.  Primary goal would be to show that XML in V9 is a straightforward extension of existing relational technology, is simple to use and it works well.
 
 

Getting DB2 systems and applications running on them to perform in optimal way is often seen as very challenging. Many things can go wrong and it is not always easy to know where to start performance problem diagnostics and which corrective actions are available.
Nevertheless, tuning DB2 application to achieve optimal DB2 performance does not need to be a complex exercise. A large majority of problems can be easily solved and the only challenge is connecting the problem symptom with its underlying causes. This presentation offers you a simple methodology to answer the challenge. Numerous ready-to-use hints and tips are included to maximize the presentation's practical value.
 

Will review the content of the latest release of DB2 for z/OS that went GA in March.