Link to the presentation S421. RTC v3.0 focus on zOS support

by Guy Slade IBM (US)

Level: General Interest/Intermediate

Rational Team Concert integrates work item tracking, source control management, continuous builds, iteration planning, and highly configurable process support to adapt to the way you want to work, enabling developers, architects, project managers, and project owners to work together effectively. This presentation will be delivered primarily through demonstration. It will walk through a typical defect ==> fix ==> build ==> promote scenario for a zOS shop showing how the Rational Team Concert product can provide valuable productivity enhancements through its rich feature set. The demonstration will show features such as planning, tracking, Souce Control Managament, zOS build capability, and promotion.

by Marcel den Hartog CA (NL)

Audience: All, Level: Basic, Intermediat

Link to the presentation  S422. Shifts in Security Management caused by Virtualization & Cloud

Security is more important than ever. Today?s systems have hundreds of entry points, varying from HTML pages to 3270 screens, from WEB Services to JDBC calls, through operators and appliances. The past decades have already been a struggle to keep things safe. The introduction of virtualization changed the rules and the rise of Cloud computing has completely altered the game. Where does this leave us? We went from a Mainframe platform that was controllable, to an increasingly complex IT Infrastructure where everything is connected, but nothing under control. What are YOU expected to do for your companies and what should YOU expect from the companies who provide the various Cloud services? New games, new rules, new tools. This presentation will give you an overview of the various challenges we are facing and how the industry is responding to them.

Marcel den Hartog is CA's Mainframe Marketing Principal in EMEA. Marcel has 30 years of experience with IBM Mainframes and has presented at many GSE and other external events (both CA and other) on Mainframe Strategy, Solutions and lately about the new rise of the Mainframe in these times of virtualization & consolidation efforts

by Dusty Rivers, GT Software, (US)

Audience: General Interest, Level: Intermediate

Link to the presentation S423. Drive Value and Cut Costs with Mainframe Web Services

We will discuss how mainframe integration and Web services using your existing mainframe resources (IMS,CICS,etc.) can drive maximum value from your existing mainframe investments, while cutting costs. Many think this problem is completely 'solved' with current tools , free utilities, or out of date approaches. This session will challenge those beliefs and empower you to drive maximum value from the mainframe while lowering costs.

by Brian Wildt and Charlotte Heilmann BankData (DK)

Audiencel: Mainframe infra structures and Cobol developers

Level: Intermediate

Link to the presentation S425. Efficient Workbench - when ISPF is all you got

In this session we will show you around in the Bankdata Cobol workbench. The goals we had was to make it as efficient and productive as possible. The workbench is currently used by 350 developers in Bankdata in Denmark. Last year we changed the settings on TSO/ISPF for all our 350 developer. They all got the same functions keys and setup. The feedback has been very positive and the developers feel much more efficient now. So far we have not found any tools, windows- or eclipse-based that proves to be more productive. And yes ? we do have young programmers too.

Brian Wildt and Charlotte Heilmann are responsible for mainframe developing at Bankdata Denmark. They have many years experiences in all the products around Cobol developing on mainframe. They teach new employees in mainframe developing and optimize old employees

by Leif Pedersen IBM(DK)

Audience: DB2 DBA, Application Development, Architects, DD2 System Programmers, Level: Basic, Intermediate

Link to the presentation S426. Pure Query at Nets

This presentation will show you how Nets have implemented NemID by using pureQeury techonolegy to lock access paths in DB2 by converting JDBC calls to static SQL calls and also improved applcation performace. As benefit it is now easier to identify a problem SQL statement and trace it back to the Java code.

Leif Pedersen is a member of the Optim Enablement Team located at the SVL lab, in San Jose. Leif, is located in Denmark and is help customer using the Optim products e.g. Qeury Workload Tuner, pure Qeury, Optim Performance Manager.

by Qiang Song IBM China and Leif Pedersen, IBM (DK)

Audience:DB2 DBA, Application Developer Level: Intermediate

Link to the presentation S431. Workload Tuning

In this session, the speakers will introduce a complete methodology for SQL performance tuning. The session will be presented as two parts. In the first part, the speakers will introduce some background for SQL tuning, then an example will be presented to introduce single query tuning by first understanding the problem query with formatting, annotation and access plan graph, then analyze and tune the problem query from statistics, predicate and index perspective. In the second part, the speakers will introduce why workload tuning is needed and the challenge for workload tuning, then another example will be presented to introduce the workload tuning in detail. The session will be ended with a summary of the best practices for SQL performance tuning.

Qiang Song is the technical lead of the IBM Optim Query Tuner and Optim Query Workload Tuner products, working in IBM China development lab since 2005. Qiang works closely with the customers who are using these products and has rich experience in SQL performance tuning and eclipse development. Leif Pedersen is a member of the Optim Enablement Team located at the SVL lab, in San Jose. Leif, is located in Denmark and is help customer using the Optim products e.g. Qeury Workload Tuner, pure Qeury, Optim Performance Manager.

by Lars Rönbäck, Stockholm University

Audience: Architects, DBA's and Application Developers.   Level: Intermediate

Link to the presentation S432. New Trends in Datamodelling

We need to rethink the concept of a data model. We live in a world where the available information changes more rapidly for every day that passes.

This is true both for the content and structure of the information.

On top of that, search requirements are also becoming inherently harder to predict.

In such a turbulent environment, current data models do not stand the test of time. At some point it is simpler to build a new model than to modify the existing one.

We must make it easier to reflect external changes in the model. The model must be flexible and adaptable. Furthermore, when information change we should handle the legacy data without causing any downtime.

Many of these problems are particularly obvious in the field of data warehousing. Some of the effects are:

- Current data warehouses are money sinks, as changes get more and more expensive to implement during its lifetime

- Current data warehouses do not give the desired return of investment, with maintenance constituting most of the total cost of ownership

- Current data warehouses cannot answer the really interesting questions, as they are modeled to answer a predefined set of queries and not ad-hoc searches

- Current data warehouses degenerate and become haphazard collections of tables, due to divergence from the initial modeling methodology

If we are to rethink database modeling, let us also try to do away with some other obstacles. Why is there a non-intuitive step in transforming a conceptual model to a physical one? Why is it difficult to make a generalized object-relational mapping?

In Anchor Modeling, a recent modeling technique, all this has been taken into consideration. Nevertheless, breaking into a scene ruled by old paradigms take time. To speed things up we realized that you need a tool, a free tool, and some new thinking on how you interact with your model. One in which a model is not built to last, but built to change. Only then can it truly last in an ever changing environment.

Lars Rönnbäck is a consultant at Resight, with a degree in mathematics from Uppsala University, who is specializing in customer intelligence. He has been working with some of the largest companies in the Swedish insurance and retail businesses, with ten years experience from the field of Business Intelligence and five years with Anchor Modeling. More precisely, he has been building data warehouses, designing SQL-driven ETL frameworks, and lately worked with customer analysis and data mining

by Mathias Korn IBM (DE)

Level: Intermediate Audience: General Interest

Link to the presentation S433. Unix System Services Update

The most powerful document to analyze a problem in a z/OS environment is a dump. Each component running under z/OS provides their own recovery environment and schedules a dump in case of a problem. There are different ways how to capture one. They are taken on demand via command, using the slip command processor or will be taken automatically by the recovery routines. But once captured - what now? What kind of dumps exist and what are the first steps for System Programmers to get a feeling what was the dump written for? This session will show a general overview and seperates dumps into different categories. It will introduce IPCS as a powerful tool to analyze unformatted dumps and will show at different examples, how fast the root of a problem can be determined in the area of Unix System Services using a dump.

Matthias is a zSeries Software Support Specialist focused on z/OS base components and primarily working on defects in the area of the z/OS kernel as well as Unix System Services for the IBM zSeries Systemsupport in Germany. Matthias is working now since 15 years in the area of z/OS SCP (system control program) defect support and since 12 years supporting Unix System Services. He is a member of the european virtual frontend providing L2 support frontended to component specific change teams in the US. A former project has been the development of the 'ITSO OMVS Training Camp' course material for example. He frequently presents USS problem debug information at the z/OS Guide GSE conference in Lahnstein, Germany. He was a speaker at the 2010 GSE Nordics Conference as well.

by Mathias Korn IBM (DE)

Level: Intermediate Audience: General Interest

Link to the presentation S434. z/OS Dump handling - Overview and a bit more

The most powerful document to analyze a problem in a z/OS environment is a dump. Each component running under z/OS provides their own recovery environment and schedules a dump in case of a problem. There are different ways how to capture one. They are taken on demand via command, using the slip command processor or will be taken automatically by the recovery routines. But once captured - what now? What kind of dumps exist and what are the first steps for System Programmers to get a feeling what was the dump written for? This session will show a general overview and seperates dumps into different categories. It will introduce IPCS as a powerful tool to analyze unformatted dumps and will show at different examples, how fast the root of a problem can be determined in the area of Unix System Services using a dump.

Matthias is a zSeries Software Support Specialist focused on z/OS base components and primarily working on defects in the area of the z/OS kernel as well as Unix System Services for the IBM zSeries Systemsupport in Germany. Matthias is working now since 15 years in the area of z/OS SCP (system control program) defect support and since 12 years supporting Unix System Services. He is a member of the european virtual frontend providing L2 support frontended to component specific change teams in the US. A former project has been the development of the 'ITSO OMVS Training Camp' course material for example. He frequently presents USS problem debug information at the z/OS Guide GSE conference in Lahnstein, Germany. He was a speaker at the 2010 GSE Nordics Conference as well.