In this session the Steering Committees will bid you welcome to Elsinore and to the GSE Nordic Region Technical Conference.

Svenn-Aage Sønderskov is chairman of the GSE Nordic Region DB2 Working Group.

Are mainframes really different, and if so how? and why? This presentation will describe the key qualities of a mainframe that differentiate it from distributed servers, and will help set up the evaluation criteria for understanding "Why a mainframe is important?

David Rhoderick is a Mainframe Evangelist in the IBM Software Group zSeries Competitive Project Office. He is focused on application deployment and the financial aspects of mainframe operation. In his 31 years at IBM (in the UK and the US), Dave has worked in many different fields including software pricing, CICS marketing, ISV recruitment, consulting, sales, systems engineering, management, development and systems programming. As well as extensive mainframe experience, he was involved in the development of the OS/2 operating system for PCs, and in porting a large DEC-VAX application to the AIX environment for a media company. Dave graduated from Cambridge University with an MA in Computer and Natural Sciences and is currently studying for a Masters in Musicology at the UK?s Open University.

Keep One Step Ahead with the Mainframe's Compliance and Privacy Solutions.

System z is the most secure operating platform, with built-in capabilities to ensure privacy of data and secure processing for your companies whether simple or extended enterprises. A discussion on the latest capabilities that help customers comply, protect data, ensure privacy and reduce risk. You'll see a demo of how our compliance products uncover potential security exposures that are otherwise not readily apparent.

IBM has recently announced and made available the IBM System z10 mainframe system.

This presentation covers the highlights of the new hardware from a software perspective and the specific support for the z10 provided in z/OS.

Bob Rogers is an IBM Distinguished Engineer, working on System z software system design. He joined IBM in 1969 in Poughkeepsie as a computer operator. He received a B.A. in mathematics from Marist College in 1971 and subsequently became a computer programmer at the Poughkeepsie Programming Center, where he worked on the OS/360 operating system. Bob Rogers has been working on mainframe operating systems at IBM for over 35 years, including the transitions to both XA-370 and ESA/370, and was lead software designer for the transition to the 64-bit z/Architecture. As part of z/Architecture development, he contributed to the definition of the architecture and created the overall design of the software support. He implemented the support for single z/OS images with more than 16 CPUs. More recently, he was a lead designer of the z/OS support for the zSeries Application Assist Processors (zAAPs) and the System z Integrated Information Processor (zIIP). He is a member of the IBM System z Software Design Council and holds a number a patents. Bob is a frequent and popular speaker at technical conferences in the US and worldwide and occasionally teaches classes on the latest technologies to Software Vendors.

The original HFS on z/OS is now deprecated, with zFS taking its place. This presentation provides an overview of zFS and migration from HFS. It also covers a few interesting enhancements to USS and parts of z/OS for the Unix environment.

No one can have failed to notice how Service Oriented Architecture (SOA) has become one of the top topics of interest across the whole IT industry. And yet SOA is often misunderstood and misrepresented. In this session, the speaker will look at the true origins of SOA, and how it is driven by "the Business", rather than IT. Some different IT implementations will be overviewed, including Java Enterprise Edition and Web Services. Some new technologies have been introduced to reduce the complexity of SOA such as Service Component Architecture and Structured Data Objects - and these too will be reviewed. The speaker will discuss the key role of legacy systems in an SOA, and look at how tooling can be used to easily service-enable traditional transaction processing. Consideration will also be given to how to get started with SOA and achieve early benefits.

Alan Cooper is an IMS Consultant in the IBM Software Business, and is based in Newcastle, UK. He has worked with IMS for over 32 years, and has specialised in a broad range of aspects of IMS, including Performance, Fast Path, DBRC, Parallel Sysplex, e-business On Demand, and the new range of IBM's IMS Tools. Alan teaches IMS courses throughout Europe, and has written and contributed to several IMS Red Books. He features on the agenda of many IBM and GSE IMS-related technical conferences in Europe, assists with the IMS Early Support Programme, and travels widely to help customers working on the leading edge of IMS technology. His other technical interests include programming languages, and he is an enthusiastic champion of java.

The potentials with use of Open Source Software (OSS) license both for the user and for the vendor will be presented:

OSS a license and a development method for software. Realize better quality and more effective development of software with the openness of OSS development method. New business models and economical potentials with OSS for both vendors and users with OSS.

Peter Timm has more than 30 years of working experience with It both from the vendor side and from the customer side. In the period 2006 ? 2007 he worked for the Danish government establishing ?the National Knowledge Center off Software? with the purpose of promoting both the use and the development of Open Source Software in Denmark.

Management is always interested in ways to cut costs. IBM has introduced several special-purpose processors to help them in their quest, leaving the systems programmers to manage the new beasts. This presentation covers the sysprog interactions with the zAAP and zIIP processors. It also distinquishes the outboard DataPower processor from inboard zAAP and zIIP processors.

The world of Mainframe has changed. Mainframers have realized this, but in many cases we have not been able to convince our Management.

With the latest technical developments (zIIP, zAAP, Linux and SOA) and the need to be ?Green?, it?s time we reclaim the position that the IBM Mainframe deserves.

What have companies like IBM and CA done to help mainframe users to get the most out of the mainframe and what do we need to do internally to convince our management?

This session will cover the various aspects of technology and more importantly the internal marketing we need to use to help our management to make better decisions.

Marcel den Hartog is Marketing Program Director EMEA for Mainframe & Security. In this role, he is a frequent speaker on both internal (customer) and external events where he talks about CA?s mainframe strategy and vision, but also about market trends.

Marcel joined CA in 1986 as a Pre-sales consultant. Before this, he worked as a programmer/systems analyst on VSE and MVS systems, starting with CICS DL1/IMS and later with DB2. He is still an expert in CA Easytrieve and Cobol and has hands-on experience with many CA products. He was responsible for managing CA?s pre-sales teams in The Netherlands, Belgium and South Africa for a number of years. Prior to his current role Marcel worked as a Linux Development Architect for CA?s Linux and Open Source team. In that role, he served almost two years as a board member of the open source Plone Community.

So, there is a new mainframe. Not that big surprise. What features have finally arrived? What is still in the future? How will IBM expand the market for the mainframe? The speaker looks into the developments since the 360 and the new official litterature. When this is not enough, the magic crystal ball is used to look into the future.

Paul Saers has been around since the IBM-360 was the current mainframe. He is a frequent speaker in local and global user conferences. His speciality is in tuning, capacity, upgrades and complex problems research.

The New CELL-CPU, which is the CPU of the new Playstation 3 represents a whole new philosophy, when it comes to dividing the responsibilities between hardware and software

Gone is caching, prefetch and branch-prediction. Instead the programmer gets previously unseen calculating power at his disposal. 206Gflops pr CPU or 20 times as much as a regular desktop CPU.

This presentation describes the CELL-CPU, giving samples that demonstrate how a different approach to programming can maximise it's performance, yielding very impressive results. In closing, we see how the power of a network of Playstation 3 consoles in private homes can be used to help scientists with their demand for CPU calculating power.

Brian Vinter is Master of Engineering from Aalborg University and Doctor of Science from Tromsø University in 1999. He is Professor of Computer Science and Head of the Center for eScience at the University of Copenhagen, with supercomputers and Grid as his area of expertise. He has been employed at Syddansk University, Tromsø University and Princeton University and was until 2006 director of the Nordic DataGrid Facility. He is also a member of the management of MESH Technologies.

In this session every attendee is urged to offer criticism and suggestions for areas to be covered in future conferences by using the Feedback Form to the GSE Nordic Steering Committees. It will be used by the Steering Committees as input for planning the next conference.

Each GSE Working Group Chairman is elected for a two-year term and this year the CICS and Mainframe Infrastructure chairman will be elected during this session.

Michael Erichsen is the chairman of the GSE Nordic CICS Working Group.

Web 2.0 brings about a new dimension of imagination and innovation for organizations to use information as a strategic business asset to gain a competitive advantage. It advocates Representational State Transfer or ?REST?, an increasingly popular, powerful, and simple method of leveraging HTTP as simplified Web service or feed in XML, RSS, or ATOM. A REST service or Web feed can be remixed and mashed up in new and unprecedented ways.

Countless everyday activities such as order status and inventory lookup are running enterprise transactions behind the scene. Learn how to unleash enterprise transactions into the Web 2.0 community with very little technical knowledge. The speaker will cover IBM's Web 2.0 Goes to Work offerings, which can rapidly blends information and Web services with enterprise content and services, including IBM DB2® pureXML? and IMS transactions; and easily mash them together to generate fast, flexible, and affordable applications. You will see a demo on transforming an enterprise transaction into a REST service and composing services into a business Web Mashup. Come and experience some inspiring Web Mashups to help you get started.

Jenny Hung is a software engineer working in IMS OnDemand with the focus to modernize IMS as the integration focal point in SOA and WOA. Her expertise includes IMS Info 2.0 (Web 2.0), IMS MFS Web solutions, IMS TM Resource Adapter, IMS SOAP Gateway, and Business Process Choreography. Jenny has a master degree in computer science from Stanford University

Business processes play a key role in business-to-business and enterprise application integration scenarios. They are the fundamental basis for building heterogeneous and distributed applications. Business Process Execution Language for Web Services (BPEL4WS) provides the flexible means to specify business processes that are composed of Web services as well as exposed as Web services. It has quickly become the standard for assembly of complex business processes or activities together and describing the interactions between them. These abstract activities can be controlled to run in parallel or in sequence, with conditions, or even involving human interaction. Come to this session to learn about BPEL4WS and choreographing business process applications. This session will also walk through a demo of creating a real world business process involving enterprise applications.

This presentation will introduce the what, why and how of UNICODE - what is UNICODE and why do we need it. It will also look at how to exploit UNICODE to approach truly multi-language applications, what we have and what is "missing". The bad news: we're not there yet. The good news: there is work for everybody for the next many years.

Christian Skalberg is the Godfather of DB2 in Denmark. He has worked longer with databases than most of the attendees have been in the IT industry and longer than several of the attendees have been on this earth.

Come and hear about the latest release of COBOL, Enterprise COBOL for z/OS Version 4 Release 1.

New in Enterprise COBOL V4.1 are XML PARSE enhancements, including XMLSS exploitation, XML GENERATE enhancements, including new syntax, Performance enhancements, DB2 coprocessor enhancements, Usability enhancements, and oOther functional enhancements

Tom Ross is a senior software engineer in COBOL development. Tom has spent his entire 25 year IBM career in COBOL development, working on the compiler and run-time libraries for every release of VS COBOL II, COBOL for OS/390 & VM, and IBM COBOL on AIX, Windows, and OS/2. He is an expert in migration issues for COBOL and Language Environment for MVS and VM, and in many issues facing IBM mainframe customers. He is a frequent speaker at user groups and is the IBM representative for COBOL to SHARE. Tom grew up in Los Gatos (a suburb of San Jose) California and earned a Bachelor Degree in Computer science from the University of California at Santa Cruz in 1982. He started his love affair with IBM on Valentine's Day, 1983

This session demonstrates how you can implement SOA in a CICS/Cobol environment using web services. Starting with a WSDL, generate COBOL copybooks and use them in a service-provider and in a service-consumer. The applications are CICS/Cobol programs using various CICS-commands including containers.

Carsten Andersen has more than 25 years of experience working with mainframe environments in the Danish financial sector, and has participated in the development of the integrationplatform in Jyske Bank.

Hans Iversen has more than 30 years of experience working with software development and teaching software engineering, and has participated in the development of the integrationplatform in Jyske Bank.

This session introduces you to the steps necessary to create a Batch COBOL application that accesses a DB2 for z/OS database using Developer for z. It will touch upon Eclipse, Developer for z, JCL, COBOL, and DB2 for z/OS as well as a basic SQL.

Larry England is a Senior Technical Staff Member at IBM's Silicon Valley Lab in San Jose, California. He has architectural responsibilities for application development tools on System z. England has worked in a number of areas during his IBM career including, VM/370, MVS, Language Environment, Multi-Media, Text search and retrieval, Database Management systems, and PL/I Runtime and Test. England has a BS in Mathematics and Computer Science from University of Illinois, MS in Computer Science from Oregon State University, and post-graduate work at University of California Santa Cruz. When not working at IBM, he can be found running a trail in the California hills.

This session describes how to use IBM Rational Developer for System z to create and debug Java applications that will run on z/OS. It will touch on using JzOS with RDz.

A user's experience on profiling mainframe applications with the tool PathPoint from ASG (Allen Software Group). Learn how PathPoint can beat bad or non-existing documentation, and discover what's inside your legacy mainframe applications. PathPoint will help you to understand how your applications work, locate performance hogs and disclose bad designs. PathPoint makes runtime analysis of online transactions or batch jobs and provides detailed information about program and data usage and the performance of programs and SQL statements. The speaker will tell how PathPoint was used to secure the quality of the CICS backend in a project for a complex webservice-based application.

Jørgen Møller Larsen has 20 years of experience working with mainframe-centric environments in the Danish financial sector, and is responsible for the use and implementation of development, testing and performance tools in Nykredit.

The following topics will be covered in this presentation:

1) Overview of query optimization - plan enumeration and cost estimation

2) Predicate application - matching predicate, screen predicate, stage 1 predicate and stage 2 predicate

3) Statistics and access path selection

Gene is an IBM Distinguished Engineer and Senior Manager based in Silicon Valley Laboratory, San Jose, California. He is the lead architect for DB2 query technologies which include but not limited to query optimization, query parallelism, spatial search, autonomic optimization, and tools for query performance monitoring and tuning. Gene joined IBM in 1993 after working in the ECAD software industry for more than three years. In his IBM career, Gene worked on compiler construction for High Performance Fortran for one year, DB2 LUW for six years, and DB2 for z/OS for eight years. Gene received BS degree in Computer Science from National Taiwan University in 1981 and MS/Ph.D. degree in Computer Science from State University of New York at Stony Brook in 1986 and 1989 respectively.

In this presentation, I'll describe a methodology for tuning access path for SQL queries. The impact of statistics collection, predicate application, and index design to access path selection will be covered in a simple case study. The Visual Explain function of DB2 Optimization Service Center will be used for the illustration of various kinds of tuning information.

Gene is an IBM Distinguished Engineer and Senior Manager based in Silicon Valley Laboratory, San Jose, California. He is the lead architect for DB2 query technologies which include but not limited to query optimization, query parallelism, spatial search, autonomic optimization, and tools for query performance monitoring and tuning. Gene joined IBM in 1993 after working in the ECAD software industry for more than three years. In his IBM career, Gene worked on compiler construction for High Performance Fortran for one year, DB2 LUW for six years, and DB2 for z/OS for eight years. Gene received BS degree in Computer Science from National Taiwan University in 1981 and MS/Ph.D. degree in Computer Science from State University of New York at Stony Brook in 1986 and 1989 respectively.

Eclipse is an open source software framework that is changing the way developers work and how new tools are being written. Break the mold that Eclipse is simply a development environment for Java and walk observe many features of Eclipse in an interactive demo showing my experiences of using the tool. See how this modern cross platform development environment is bringing a consistent ?Look & Feel? to applications and application development.

Scott Clee is the CICS Test Architect based in the IBM UK Hursley laboratory. Over the last 7 years Scott has specialized in the areas of Web services and Java in CICS. As an evangelist for the sharing of knowledge, Scott has written various IBM developerWorks articles, and co-authored two CICS Red Books; "Java Application Development for CICS" and "CICS Transaction Server V3 R1 Channels and Containers Revealed".

Built on Eclipse technology, Rational Developer for System z V7.1 (RDz) makes it easier than ever to integrate the development of CICS application programs with a single user interface. Whatever your language of choice (COBOL, PL/I, C, C++, Assembler or Java) RDz allows you to code, compile and debug your programs directly from the mainframe. Discover how the CICS Service Flow Feature builds on RDz to enable composition of CICS application interactions as reusable business services. Then tie all this together with the built in Web Services support in RDz that compliments and extends the Web services capabilities offered in CICS TS 3.2.

The problem: Redesigning a very large and very legacy COBOL /AFP printing system to create new combined documents using dynamic page breaks etc. Putting 15 million documents on DB2. Getting out of IBM 'Printing OnDemand' concept. Showing new documents as PDF on web within 0,5 seconds from data capture. The solution was build around IBM's MO:DCA language as the common denominator.

The presentation will be: Introduction to MO:DCA and AFP, introduction of the utilities needed to handle MO:DCA, a few words on the conversion of MO:DCA to PDF using mainframe UNIX, plus a few critical remarks about IBM OnDemand. DB2 will be covered quickly: no problems. IBM AFP-XML is mentioned, it was considered as the core technique, but was only used for a small part of the solution.

The level of the presentation will be intermediate. Implementing the presented technique is hard-core.

Morten Bøgh is mainframe architect at CSC for the danish 'IRS', the personal taxing system.

In this session we will take a look at the rich set of enhancements provided by CICS TS V3.2 and then review the additional function being provided as post GA items in 2008. This talk will encompass a wide variety of technical subjects including CICS Web services, capacity constraint relief (such as larger ESDS data sets, MRO/XCF group management), CICS threadsafety, CICS file control, CICS Java support and the Service Flow Feature.

Phil Wakelin is a member of the CICS Strategy and Planning team in IBM Hursley, and is responsible for the future development plans of CICS connector technology and the architecture of the CICS Transaction Gateway. He joined IBM in 1990 and originally worked in the System Test department of IBM Hursley, where he worked on most platforms and versions of CICS before joining the Installation Support Centre, as a pre-sales support specialist for CICS client-server. He then worked at the IBM International Technical Support Centre, in IBM San Jose, where he was responsible for the development and publishing of 11 CICS related IBM Redbooks. He is an IBM Certified Solutions Expert, CICS Web Enablement, and a Senior IT Specialist.

As part of a multi-release initiative, CICS TS V3.2 has introduced a new TCP/IP-based intercommunication protocol as an alternative to that provided via ISC or MRO. This allows Distributed Program Link (DPL) requests to be routed between CICS TS V3.2 regions over a TCP/IP network, and also provides for Java requests via the CICS Transaction Gateway to invoke CICS programs using the Channels and Containers programming model and the ECI interface. This session will provide in-depth guidance on how to configure both your CICS and CICS Transaction Gateway systems to fully exploit the new IP interconnectivity (IPIC) support, and provides details on how the qualities of security, transactionality and connection management are best managed in both CICS TS V3.2 and the CICS Transaction Gateway.

This session looks at support for various sorts of security with web services. In particular, the requirement for and support of WS-Security in CICS TS V3.1 and CICS TS V3.2 is explained. The session also looks at the support for WS-Trust which was added in CICS TS V3.2. When higher levels of security are required for a web service, there is an inevitable performance cost. This session looks at some performance figures and compares CICS TS V3.1 and CICS TS V3.2 for various security options.

This presentation discusses the configuration of pipelines in CICS TS as used for web services. The basic configuration supplied with CICS is explained and then the possibilities for end user configuration are considered. The differences between message handlers and SOAP header handlers is explained with the potential benefits of using one as opposed to the other considered.

Darren Beard is a member of the CICS Development team, based at the IBM Hursley Laboratory in the UK. He has 18 years experience in development and has worked on many parts of the product from terminal control to web services. Darren has written several technical articles on CICS. He has presented at the US and European Technical Conferences and at GUIDE.

This session discusses performance considerations for various flavours of VSAM within CICS. Comparion of Non Shared Resources (NSR) and Local Shared Resources (LSR) and which method is best for your workload will be reviewed. Benchmark figures for workload comparisons are discussed, as are performance comparisons of Record Level Sharing (RLS) and function shipped requests to local VSAM in FORs. The recent threadsafe enhancements to CICS Transaction Server for z/OS V3.2 are also reviewed from the perspective of CICS File Control and WebSphere MQ workloads.

Andy Wright is a Senior Software Engineer in the CICS Change Team, based at the IBM Hursley Lab in the UK. He has 20 years experience working with and supporting CICS, its associated tools and utilities, from CICS/OS 1.6 through to CICS TS 3.2. Andy works closely with the various IBM locations such as Raleigh and Poughkeepsie in the US. He has participated in a number of ITSO residencies to help develop IBM Redbooks and education classes. Andy has written something like 70 articles sharing his knowledge and information about IBM?s software, and presented at the US and European Technical Conferences, and at Nordic GUIDE and SHARE.

The CICS trace facility is one of the most useful debugging tools for CICS application and system programmers. This session takes a variety of problem situations and shows how to apply trace analysis techniques to resolve them. It covers traditional areas of interest such as abends, loops and storage problems, together with reviewing newer OTE, Web and Web Service activity from the trace perspective. In addition, this session also discusses the facilities and benefits of CICSPlex Systems Manager, such as its API, Web Interface and various capabilities.

This session follows the birth of CICS and its path to becoming the most successful Transaction Server in computing. It details the history of CICS and how it's continually pushed the fold of technology, leading to it supporting SOA and Web Services technology. CICS has been a market leader for nearly 40 years and is 4 letters Top Businesses swear by.

Nick Garrod works in the CICS Marketing group in the CICS Development Lab. located in Hursley. He is responsible for marketing materials associated with CICS as well as speaking and arranging speakers at events all over the world. He has contributed to Redbooks, White Papers and articles about CICS Transaction Server as well as having a Business background in CICS.

How can you manage your CICS Transaction Gateway systems so as to meet the growing availability and performance requirements of your business? - The latest release of the CICS TG - V7.1 provides a wealth of new systems monitoring functionality and together with the new IBM Tivoli® OMEGAMON® XE for CICS TG product provides you with a comprehensive set of capacity planning and problem determination capabilities including throughput and performance analysis, historical data analysis, and a request monitoring infrastructure for advanced problem determination.

Attend this session to hear about the latest enhancements to CICS Monitoring and Statistics in support of the new functions in CICS Transaction Server for z/OS V3.2. Topics such as the monitoring and statistics data for the CICS Web Services support, IP Connectivity, WebSphere MQ, and the Open Transaction Environment (OTE) will be covered as well as the latest updates to the utility and sample programs including the ever popular statistics sample program DFH0STAT.

With the growing uptake of Java in CICS there?s never been a better time to take advantage of the technology. Learn about the latest and greatest Java features incorporated in CICS TS 3.2, including usability enhancements to help provide a smoother Java experience in CICS. Discover how to configure CICS Java support and debug your live Java programs running in CICS TS, using the latest Eclipse based tooling.

This presentation will cover deprecated/removed function. new post GA function to be delivered, planned stability, planning for rebind and access path change, VSCR, CPU improvement/regression, LRSN spin, improvements to COPY and RECOVER, object level recovery from system level backup, reordered row format

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab and he is one of the senior technical leaders within DB2 for z/OS Development. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

With the number and size of database objects constantly growing, and requirements on availability getting tougher every month, reorgs of tables and indexes need to be planned well. In this presentation I will focus mainly on automation considerations and different availability options. I will also cover online reorganization and reorg avoidance. And yes, you still need to reorg in DB2 V8 and 9. This session will cover generic, vendor independent topics, valid and useful for every DB2 administrator.

Peter Plevka, Business Solutions Manager, BMC Software Austria I started my IT career in 1987 at a large Austrian insurance company as an MVS Operator and later as a DB2 systems programmer and Database Administrator. In 1994 I joined Platinum technology as a technical consultant for their DB2 solutions. Later with CA my role expanded being the european technology leader for CA's database management solutions for DB2, IMS and ORACLE. With BMC since 2003 I assume a very similar position in the EMEA Mainframe market as a business solutions manager for Data Management (DB2/IMS) and I am involved in customer support, product training and sales enablement, as well as presenting at local and international user groups.

After migration into DB2 v8 was completed in june 2006, Danske Bank has in cooperation with IBM exploited the information given in the RTS tables. This presentation will give you an overview of the conversion made by the technical DBA and operations group by converting an old reorg system into a new system based on RTS. The presentation will also give you information on how the RTS tables, have been used to predict which tablespaces needed alteration DB2 production environment, in order to be able to scale data from a huge conversion project. Method of how prediciton of batch operationial areas where tuning or alterations were needed will also be given.

Introduced to DB2 in1988 Peter Steen Nielsen has since been working in various areas of development, and for the past more than 10 years as DBA. At present he is the Department Manager of the Danske Bank DBA development team in Copenhagen and Aarhus.

This talk will focus largely upon the significant enhancements provided by DB2 utilities in DB2 9 for z/OS. In addition, we will cover some recent changes that are provided in the maintenance stream on both V8 and V9, and that are therefore of immediate importance to anyone running either version. Finally, we will take a quick look at where we may be heading in future. This talk is for anyone wishing to fully exploit utilities' capabilities today and who wishes to plan for what's coming next.

Haakon Roberts has over 20 years' experience working with DB2 on the mainframe platform, spanning various aspects of systems programming, database administration and software support. Since 1999 he has worked directly for DB2 development and is a Senior Technical Staff Member at the Silicon Valley Laboratory in San Jose, California. He is currently the technical lead for DB2 Utilities and is also focused on availability, service and serviceability issues.

This presentation will describe IBM's new pureQuery technology, which provides a much more manageable infrastructure of Java applications that access databases. pureQuery has new Java API capabilities that make accessing the database much more flexible and powerful. Applications that exploit pureQuery are automatically enabled for superior problem determination, performance monitoring, and problem determination assistance for the IT staff. The presentation will also reveiw recent contributions from IBM to the open source (iBatis, Spring, OpenJPA) that allows IBM's JDBC and pureQuery solutions to run in the popular open source frameworks.

IBM Fellow Vice President & Chief Technology Officer for Database Servers Curt Cotner is an IBM Fellow, and a member of the IBM Academy of Technology. Curt is the chief technology officer for the DB2 family and Informix IDS database servers, and has both management and technology oversight responsibility for all the client software offerings used with DB2 and IDS. This includes the client runtime APIs (JDBC, .NET, CLI, pureQuery, etc.) and the application development and administration tools offerings (IBM Data Studio). Prior to taking his current assignment, Curt was the chief architect for the DB2 for z/OS development team.

This presentation will cover V8 DBM1 VSCR, V8 EDM storage, estimation of V8 VSCR, 64-bit bufferpool, bufferpool long term page fix, batch of GBP reads and writes, virtual storage tuning, DBM1 VSCR in V9, V9 EDM storage, automatic bufferpool management, prefetch and deferred write quantity, dynamic prefetch and preformat, workfile bufferpools

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab and he is one of the senior technical leaders within DB2 for z/OS Development. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

The widespread use of XML in web applications is extending into the database layer, not least because of legislation demanding the use of XML formats. While the technology is well-known in other areas, it is new to the mainframe and this poses a challenge to mainframe developers and DBA's. It is time to start exploring the possibilities already available. This session gives a brief introduction to what XML data is, and then demonstrates through an example application why it has a natural place inside the database and how this is done with pureXML in DB2 9. The application has been made as simple as possible while realistically showing the framework and concepts of XML integration in DB2. It builds on Java Servlets accessing DB2 on z/OS through JDBC using SQL/XML and XPath, and data validation through XML Schema.

Kirsten Ann Larsen is a Senior IT Specialist with IBM Denmark. She has worked with DB2 for more than 10 years and participated in several studies exploring new features in DB2. She co-authored the redbook 'Securing DB2 and Implementing MLS on z/OS'.

In this seminar we will look at some of the nice performance features of V8 SQL and how they have been useful in our applications. We will discuss some of the things we still desire in terms of application and SQL performance and take a look to V9 to see what new SQL features we can take advantage of V8 SQL Performance Features and Performance Multi-Row Fetch - Usage and Results Recursion - Usage for reduction of SQL Common Table Expressions - Clever uses INSERT within a SELECT Scalar Fullselect - Usage Examples Distribution Statistics V9 SQL Features UPDATE/DELETE with a SELECT Optimistic Locking Index on Expression Histogram Statistics Discuss the importance of smart SQL Discuss V8 SQL and show examples Discuss Performance benefits of V8 SQL features Discuss Challenges still remaining in V8 with SQL performance Look at some new V9 SQL features .

Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help development, implement and tune some of the world?s largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities have included authoring articles, presenting at user group meetings, and authoring white papers. She is an IBM GOLD Consultant for DB2 and z/Series, and has authored the IBM ?DB2 for z/OS V8 DBA Certification Guide? and the IBM ?DB2 for z/OS V7 Application Programming Certification Guide?. She is also the co-author of several DB2 books including the IBM ?DB2 9 for z/OS DBA Certification Guide?, ?DB2 High Performance Design and Tuning? and ?DB2 Answers?

This presentation covers new, bold, creative solutions to achieve high availability and high performance. New challenges mean thinking outside the old rules. We also look at how to synergize creative table designs with applications to achieve our goals. * Discuss some new innovative ways to create tables * Discuss new challenges and opportunities for index design * Discuss how to integrate designs with applications for best performance and availability ? Discuss how to use new features of DB2 to solve problems ? Discuss ways to think differently about designs and see examples from real implementations 1. Current challenges faced by our clients 2. Creating new innovative solutions 3. Solving todays performance and availability problems with new designs

Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help development, implement and tune some of the world?s largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities have included authoring articles, presenting at user group meetings, and authoring white papers. She is an IBM GOLD Consultant for DB2 and z/Series, and has authored the IBM ?DB2 for z/OS V8 DBA Certification Guide? and the IBM ?DB2 for z/OS V7 Application Programming Certification Guide?. She is also the co-author of several DB2 books including the IBM ?DB2 9 for z/OS DBA Certification Guide?, ?DB2 High Performance Design and Tuning? and ?DB2 Answers?

IBM Data Studio is a new integrated solution that helps IT organizations manage the life cycle of both the database and the applications that depend upon the database. This presentation will describe the capabilities of IBM Data Studio and the expected rollout of functionality over time. This will include database modelling/design, application development, database administration, performance monitoring, problem determination, and data governance.

IBM Fellow Vice President & Chief Technology Officer for Database Servers Curt Cotner is an IBM Fellow, and a member of the IBM Academy of Technology. Curt is the chief technology officer for the DB2 family and Informix IDS database servers, and has both management and technology oversight responsibility for all the client software offerings used with DB2 and IDS. This includes the client runtime APIs (JDBC, .NET, CLI, pureQuery, etc.) and the application development and administration tools offerings (IBM Data Studio). Prior to taking his current assignment, Curt was the chief architect for the DB2 for z/OS development team.

This presentation introduces and discusses DB2 for z/OS V8 system performance monitoring and tuning issues and recommendations. It will focus on key areas of bufferpool, group bufferpool, lock/latch contention, system address space CPU and EDM Pool Tuning. It will identify the key performance indicators to be monitored, provide rules-of-thumb to be applied and provide tuning advice for common problems.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab and he is one of the senior technical leaders within DB2 for z/OS Development. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

The following topics will be covered in this presentation: OE and OSC offering

Application tuning with OE/OSC covering Obtaining application profile, Statistics Advisor, Index Advisor, Query Advisor, Exception monitoring

Single query tuning with OE/OSC covering Identifying Problem Queries, Query Annotation, Query Report, Visual Explain, Visual Plan Hint

Gene is an IBM Distinguished Engineer and Senior Manager based in Silicon Valley Laboratory, San Jose, California. He is the lead architect for DB2 query technologies which include but not limited to query optimization, query parallelism, spatial search, autonomic optimization, and tools for query performance monitoring and tuning. Gene joined IBM in 1993 after working in the ECAD software industry for more than three years. In his IBM career, Gene worked on compiler construction for High Performance Fortran for one year, DB2 LUW for six years, and DB2 for z/OS for eight years. Gene received BS degree in Computer Science from National Taiwan University in 1981 and MS/Ph.D. degree in Computer Science from State University of New York at Stony Brook in 1986 and 1989 respectively.

IMS has reached 40 years of age! Throughout its life so far, it has always provided state-of-the-art solutions for data base and transaction processing. And this will continue as IMS enters its fifth decade! In this session, the speaker will look at how IMS has been adapting to the changing IT world, addressing customer skills issues, and enabling and simplifying web-enablement and service oriented access. The continuing evolution of IMS's traditional qualities of service - performance, availability, serviceability and security - will also be emphasized. The speaker will then give some pointers as to how IMS will follow these strategic directions into the future.

Alan Cooper is an IMS Consultant in the IBM Software Business, and is based in Newcastle, UK. He has worked with IMS for over 32 years, and has specialised in a broad range of aspects of IMS, including Performance, Fast Path, DBRC, Parallel Sysplex, e-business On Demand, and the new range of IBM's IMS Tools. Alan teaches IMS courses throughout Europe, and has written and contributed to several IMS Red Books. He features on the agenda of many IBM and GSE IMS-related technical conferences in Europe, assists with the IMS Early Support Programme, and travels widely to help customers working on the leading edge of IMS technology. His other technical interests include programming languages, and he is an enthusiastic champion of java.