-----------------------------------------------------------------------------------------------------------

GSE Nordic Region Conference

2011

7-9 June 2011

Stockholm, Sweden


----------------------------------------------------------------------------------------------------------

Welcome
Dear colleague,

The GSE Nordic Region has the pleasure of inviting you to the Nordic Region Conference to be held in Stockholm, Sweden, at the Scandic Hotel Infracity, 7 - 9 June 2011.

The GSE Nordic Region Working Groups are groups of information technology specialists, focusing on IBM software, who meet regularly. The main objective of the groups is to give their members an opportunity to meet, to exchange ideas and experiences, to deepen their knowledge and to broaden their perspective, and in co-operation with IBM to participate in influencing the future of data processing in general and particularly in the IBM software areas covered by the groups. Four of these groups are cooperating to arrange the yearly Region Conference: The CICS, DB2, IMS, and Mainframe Infrastructure Groups.

The conference offers a full view on the enterprise IT landscape. On the back end it focuses on the mainframe as the robust back end of the enterprise IT landscape, especially when using the transactional, database, and infrastructure subsystems including CICS, DB2, IMS, and the WebSphere family of products on the mainframe platform.

Also the ambition of the conference is double: It is not only a deep, technical conference for product specialists in these areas, but also a learning source for application developers, architects, and technically oriented managers who need to update their knowledge on the new features of the mainframe and the WebSphere family of products in order to make best use of it for their companies and organisations.

The conference also invites a number of staff members and students of the
Universities of Stockholm as lecturers and as participants to broaden the scope and the networking opportunities.

The conference language will in general be English. But since this is a user conference, and since the most important aspect of it is users sharing their experiences with each other, you should be prepared for users who might prefer sharing their experiences in their own language.

Please note that GSE is non-profit, membership organisation, and all participants at a GSE conference are expected to come from a GSE member company or organisation or to be an individual member of GSE. If that is not yet the case, however, you can use this possibility to get to know more about GSE and to experience the value of participating at a GSE Nordic Region Conference.

The GSE Nordic Region Conference Steering Committee is looking forward to seeing you in Stockholm.

Link to the presentation S111. Opening Session

by Svenn-Aage Sønderskov, JN Data (DK)

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

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

by Anjul Bhambhri, IBM (US)

Audience: General Interest, Level: Basic

Link to the presentation S112A. Smarter Analytics for Big Data

The explosion of data in the enterprise from new sources such as sensors, smart phones, web logs, blogs, and social media has the potential to unlock new insights that are valuable for businesses. More than ever before, enterprise can find new ways to improve their customer satisfaction and operational efficiency from historical and real-time analytics on data at rest and data in motion. From ultra-low latency information-in-motion analytics capabilities offered via InfoSphere Streams, analytics oriented data warehouse solutions, to our innovative InfoSphere BigInsights, IBM has an unique breadth of Big Data capabilities with a holistic approach. InfoSphere BigInsights is an analytics platform that delivers Software capabilities on top of Apache Hadoop framework enabling new solutions on a business-ready platform. IBM has a holistic approach, expanding analytics to encompass Big Data, information streams, and structured data in Data Warehouses.

In this keynote, Anjul Bhambhri, IBM Vice President of Big Data, will introduce IBM's solutions together with customer scenarios on how to turn big data challenges into competitive advantages in diverse fields such as healthcare, astronomy, manufacturing, telco and financial trading etc.

Anjul Bhambhri is the Vice President of Big Data Products. She was previously the Director of IBM Optim application and data life cycle management tools. She is a seasoned professional with over twenty-two years in the database industry. Over this time, Anjul has held various engineering and management positions at IBM, Informix and Sybase. Prior to her assignment in tools, Anjul spearheaded the development of XML capabilities in IBM's DB2 database server. She is a recipient of the YWCA of Silicon Valley's ?Tribute to Women in Technology? award for 2009. Anjul holds a degree in Electrical Engineering. You may contact her at This email address is being protected from spambots. You need JavaScript enabled to view it..


S112B. The Future Runs on zEnterprise - A peek at whats to come!

by Jose Castano, IBM (US)

Audience: General Interest, Level: Basic, Intermediate

In July of 2010 IBM announced a new dimension in computing, the zEnterprise System. This announcement was met with overwhelming excitement around the world, especially around the new hybrid capabilities introduced in the new zEnterprise Blade Extension (zBX) and Unified Resource Manager (zManager). So, what is next? Come to this session to hear how IBM will continue to expand the zEnterprise platform to meet customers needs into the future

Jose is the Director for the System z Technology and Strategy organization in STG. He has over 20 years of experience within IBM and has held multiple key positions in System z during this tenure. As the Director for System z Technology and Strategy, Jose sets the technical and business strategy and direction for the System z platform working with the System z ecosystem from marketing, sales, business partners, consultants, and most importantly customers; leading the platform through an evolution that maintains leadership and meets customer and industry requirements. Jose has teams comprised of strategists who focus on business trends, market requirements and pressures, and technologists (architects) who are responsible for mapping the requirements to technologies necessary to satisfy them. Together, these teams have responsibility for researching, designing, building and maintaining the brand strategy and platform roadmap for IBM System z, driving the plans for the next 3-5 years. He is also the lead technologist and strategist for the System z eBusiness Leadership Council (zBLC), which is comprised of 43 of System z?s top customers. This technical council is used to preview technology and strategy to our most advanced customers and to fine tune or potentially direct dramatic changes to the course of direction of our platform strategy and offerings. Previously, Jose worked in the field as technical support for System z, focusing on Parallel Sysplex. He?s implemented Parallel Sysplex around the world and has consulted with customers on best practice configurations. Prior to this position, Jose was a z/OS (MVS) developer working on a variety of components deep in the operating system.

by Gene Fuh, IBM(US) Ning Wang, IBM (China

Audience: DB2 DBA,Architect, Level: IntermediateBasic

Link to the presentation S113. Best Practices for the Implementation of Multi-Tenant Databases with DB2 for zOS

With the increasing business challenges and controlled IT budget, IT organizations are expected to maximize the value of enterprise data to enhance business processes and decisions with more affordable cost. Cloud Computing is expected to be able to help reduce CAPEX and OPEX, gain business agility & maturity, and keep enterprises competitive while demanding more IT support and driving the IT cost down. Provisioning database instances to support large number of tenants which share the same application infrastructure becomes a common task in hosting database applications in the context of a cloud environment. In this presentation, the speaker will cover the best practices that they've identified and validated in the past two years while developing a framework for the deployment of IBM database servers as a service (DBaaS) and enablement of DB2 applications for multi-tenant support.

Gene Fuh, Ph.D.

IM CTO, IBM China Development Lab. (On assignment) Distinguished Engineer, Data Servers CTO Office, IBM Silicon Valley Lab.

Ning Wang,

Techical Lead, DBaaS & Massive Multi-Tenancy Emerging Technology Institute, IBM China Development Lab.

by Susan Lawson, YLA (US)

Audience: DB2 DBA, Application Developer, Level: Intermedia

Link to the presentation  S132. Table and Index Design Strategies in DB2 9 and 10 part 2

This presentation takes a look at table and index design strategies we have practiced over the years and see how they are impacted by DB2 9 and 10. We also look at how we can move forward with current designs and also be able to take advantage of the advanced features of DB2 9 and 10. Key Points:

- Discuss overall objectives of DB2 9 and 10 table and index features

- Discuss current design limitations and issues

Look at the pros and cons of utilizing the new features in 9 and 10

- Discuss how we will move forward with current designs

- Discuss what we still need to consider for optimal designs strategies

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 develop, implement and tune some of the worlds? 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.

by John Campbell, IBM(UK)

Audience: DB2 DBA, Level: Intermediate/Advanced 

Level: Intermediate/Advanced

Link to the presentation S134. Recommended Best Practices from Customer DB2 Health Check Studies Part 2

This two part presentation will introduce and discuss the major lessons to be learned from recent customer DB2 Health Check Studies carried out by DB2 for z/OS Development. The objectives are to: introduce and discuss the most common issues, share the experience gained from customer helath check studies, share the experience from live customer production incidents, provide proven recommended best practice, and to encourage proactive behavior. The following topics will be covered: WLM Policy Setup, Balanced Design across CICS and DB2 Disaster Recovery, Continuous Availability vs. Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs. Restart Light, Storage Tuning.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. 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.

by Curt Cotner, IBM (US)

Audience: General Interest, Level: Basic/Intermediate

Link to the presentation S121. Latest Improvements for Java Applications Using DB2

This session will describe the technical challenges that customers face when trying to manage large scale Java workloads. We'll discuss our latest Java development tools for Java, which are now free for DB2 LUW and DB2 Connect customers. We'll also look at some of the latest tooling improvements that allow developers and DBAs to see all the key SQL performance metrics directly in the development tools, allowing the developers to instantly see areas in the application the present potential performance problems in production.

We'll also see the latest improvements in database application monitoring for DB2 LUW and DB2 for z/OS, which allow you to view Java workloads in very fine-grained detail.

Curt Cotner is an IBM Fellow and Vice President. 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 (Data Studio and Optim tool portfolio).

by Adarsh Pannu, IBM (US)

Audience: DB2 DBA, Application Developer, Level: Basic /Intermediate

Link to the presentation S122. The anatomy of well performing SQL

In this session, we examine how the DB2 optimizer constructs an access path.

We start with a high-level discussion of building blocks such as predicate types, access methods, and join types. We subsequently describe how the optimizer uses statistics to estimate the cost of access paths and how a winner is determined. The ultimate goal of the presentation is provide a basic understanding of how the optimizer "thinks" and how this knowledge can be used in real-world problem diagnosis and query tuning.

Adarsh Pannu is a Senior Technical Staff Member on the DB2 for z/OS development team. He has over two decades of experience developing database management systems, primarily focusing on query optimization and execution.

by Curt Cotner, IBM (US)

Audience: General Interest, Level: Basic/Intermediate

Link to the presentation S123. Optim Tools Strategy and Recent Improvements

This session will provide an overview of the Data Studio and Optim tools solutions that help customers develop and manage database systems and database applications. The session will give a brief overview of these tools, and will provide detailed updates on the latest improvements and new offerings. Particular focus will be placed on the latest improvements in database backup/recovery, configuration management, database performance tuning, and test automation of production workloads. This session will describe the technical challenges that customers face when trying to create production-like workloads in test environments. The session will also describe why it is important to be able to do this, and will cite examples where failure to do this will create availability and reliability exposures in the production system. The session will then outline IBM's future technology strategy to help address these problems.

Curt Cotner is an IBM Fellow and Vice President. 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 (Data Studio and Optim tool portfolio).