Bonjour,

Réservez votre journée du vendredi 27 novembre 2009 pour un Guide DB2 pour z/OS ouvert à tous.

Les deux groupes Guide DB2 sur z/OS organisent le vendredi 27 novembre 2009 une réunion commune qui aura pour thème : "DB2 9 pour z/OS".
Elle aura lieu à Paris-La Défense dans l'auditorium de la Tour Europlaza grâce au concours de notre sponsor Infotel.

Lieu :
Tour Europlaza, La Défense 4
20 Avenue André Prothin
92927 Paris La Défense Cedex
Métro, station Esplanade de la Défense, ligne 1
ou RER, station Grande Arche de la Défense, ligne A

Plan d'accès (Google Maps) :
http://tinyurl.com/Europlaza

Agenda :
09h00-09h30 : Accueil (petit déjeûner)
09h30-09h45 : Mot des présidents Guide
09h45-10h15 : Infotel (sponsor) avec la présence de Michel Koutchouk, ancien président du Guide DB2
10h15-11h15 : DB2 9 for z/OS - Hints and Tips for DBAs par Namik Hrle (IBM)
11h15-11h30 : Pause café
11h30-12h30 : DB2 9 for z/OS – Hints and Tips for Application Programmers par Namik Hrle (IBM)
12h30-12h45 : Point sur les clients français utilisant DB2 9 pour z/OS
Déjeûner
14h15-15h30 : Access Path Stability for Dynamic Queries par Thomas Baumann (La Mobilière)
15h30-15h45 : Pause café
15h45-17h00 : Recursive Queries From a Performance Perspective par Thomas Baumann (La Mobilière)

La biographie des intervenants et le résumé des présentations se trouvent en annexe.

Si vous désirez participer au point des clients français utilisant DB2 9 pour z/OS, merci de nous envoyer un email.

Vu l'intérêt du sujet, cette réunion est ouverte à tout le monde, n'hésitez pas à en parler autour de vous. Attention, cette année, nous sommes limités à 120 places.


Les inscriptions sont ouvertes à l'adresse internet suivante :
http://gsefr.org/db2b/DB2AetB-27-11-2009


Sur le site, cliquez en bas de page sur "S'inscrire à cet événement".
Nous vous enverrons une confirmation par email un peu plus tard

A bientôt.

Marcel Lévy marcel_guide_db2@yahoo.fr
Guide DB2 France groupe DB2A
http://www.gsefr.org/db2a
et
Laurent Kuperberg laurent.kuperberg@halcom.fr
Guide DB2 France groupe DB2B
http://www.gsefr.org/db2b


Annexe (en anglais) :

Biographie de Namik Hrle
Namik Hrle works in the IBM Boeblingen Development Laboratory and is the lab's chief Information Management technologist, responsible for strategy and technology directions. As IBM Distinguished Engineer and a member of the IBM Academy of Technology he belongs to a small circle of the top technical leaders whose work and expertise impact the direction of IBM. He is a member of the Information Management Architecture Board, Software Group Architecture Board Steering Committee, Technical Experts Council and many other IBM's expert teams that work on strategic technology topics as well as addressing customers information technology needs and requirements. Holder of numerous patents, outstanding technical achievements, author recognition and corporate awards, Namik Hrle is respected as the ultimate expert in the area of intersection between enterprise applications and information management technologies. He is one of the most sought after experts by customers, IBM sales, marketing and technical support teams world-wide. Outside of IBM he frequently speaks at conferences on information management topics and is regularly voted among the best speakers

- DB2 9 Hints and Tips for DBAs par Namik Hrle (IBM)
DB2 9 for z/OS introduces numerous features to further enhance database availability, performance and security. Improved online schema and structure change operations, enhanced backup and recovery functions, new options to manage fast data growth and innovative security capabilities are only few of the features that affect the way DB2 database administrators perform their typical tasks. This presentation focuses on the features that are particularly interesting to database administrators, but it is not limited to them. Application programmers and other DB2 users will find it helpful in getting most out of the latest DB2 release.

- DB2 9 Hints and Tips for Application Programmers par Namik Hrle (IBM)
In DB2 9 for z/OS application programmers find numerous features that improve performance, scalability and portability of programs accessing DB2. Although pureXML functionality springs to mind first, there a many other attractive features such as rich new SQL capabilities, including additional data types and built-in functions, expanded SQL commonality with DB2 family, and enriched text handling. There are also leading-edge standards-based capabilities to enable SOA requirements. This presentation focuses on the features that are particularly interesting to application programmers, but it is not limited to them. DB2 database administrators will find it helpful in their work to enable applications to get most out of the latest DB2 release.



Biographie de Thomas Baumann
Since 1992, Thomas has been focusing on understanding how the DB2 database engine works. He has a master degree of computer sciences, and is currently working as data management team leader at Swiss Mobiliar Insurance in Berne, Switzerland. If he is not in his office trying how to get the most out of DB2, he is somewhere lecturing on optimization. Thomas is a member of the IDUG speakers hall of fame, and an internationally recognized expert in database auditing

- Access Path Stability for Dynamic Queries par Thomas Baumann (La Mobilière)
To rebind or not after a new DB2 release, a maintenance upgrade, or after running RUNSTATS has been a crucial question for a long time. After the implementation of optimizer hints, the REOPT bind option, and access plan management, things became easier for static SQL queries. But for dynamic queries, it is still at the customer's responsibility to ensure access path stability. This presentation shows methods for your dynamic workload to avoid access path regression and to correct unexplainable access paths, such that you don't dread your next RUNSTATS run, application or DB2 release, or your next maintenance upgrade.

- Recursive Queries From a Performance Perspective par Thomas Baumann (La Mobilière)
Recursive queries are a powerful technique to traverse hierarchical data structures and to solve similar problems. This presentation revisits the concepts of recursive SQL, analyzes its performance impact, discusses and compares alternate design and query techniques, and delivers tipps and tricks to optimize the performance of recursive queries.