In this session the CICS, DB2, IMS, and Mainframe Infrastructure Steering Committees will bid you welcome to Hämeenlinna and to the GSE Nordic Region Technical Conference.

Anders Öhrnberg is chairman of the GSE Nordic Region IMS Working Group and of the 2007 Technical Conference.

This presentation will describe the current state of the system z platform and the challenges that customers face in the enterprise today. The presentation will describe IBM's future plans for evolving the platform to meet these challenges, while continuing to provide the industry's leading solution for availability, scalability, and performance.

Curt Cotner is an IBM Fellow and the chief technology officer for the IBM database server products, with responsibility for overseeing the technology directions for DB2 and IDS. Prior to his role as CTO for database servers, Curt worked in DB2 for z/OS as the chief product architect, where he also led the design and development of DB2 Distributed Data Facility (DDF), stored procedures, Java, and WebSphere integration.
Curt currently manages the design and development of the database application development and database administration solutions for both DB2 and Informix IDS.S03.

How can your business differentiate its offerings from the competition? Can the business grow quickly, combining existing and new offerings into innovative and compelling new products? How can you leverage your existing investments? Learn how Service Oriented Architecture (SOA) helps address these challenges. See how the mainframe plays a key role in the world of SOA.

Dr. Barry Willner is an IBM Distinguished Engineer, recognizing his technical leadership in IBM. He has been with IBM for 28 years. Dr. Willner is currently manager of the Competitive Technology Laboratory in IBM's Software Group, and has broad experience in the IT industry. He is a pioneer in the use of customer based first of a kind solutions to drive product development. Dr. Willner has led the architecture and managed the development of innovative products and solutions in areas including transaction systems, internet, content management, business integration, distributed systems, networking and media. He is a master inventor, having filed over 100 patents. Dr. Willner applies his broad expertise and customer solutions background to the Competitive Technology Laboratory which compares IBM's ability to solve customer problems with that of competitors. They communicate this information worldwide in the competitive technical seminar, helping IBM?s customers and partners see the power of IBM software for e-business on demand. Dr. Willner?s experience in IBM includes being the Global Development Executive for Media and Entertainment Industry Solutions where he had world wide responsibility for development of solutions for the Broadcasting, Publishing, Sports and Entertainment industries. Another of his prior positions was being the Global Technology Executive for Telecommunications and Media Industry Solutions where he had responsibility for technical leadership.

John J Thomas is a Senior Software Engineer in the Competitive Project Office within IBM Software Group. Over the last few years he had been working on technical analysis of Microsoft?s .NET technology compared to IBM middleware. His focus is now on the mainframe, particularly on developing a fresh perspective on the platform. He is currently working on SOA solutions and development tools for z. Prior to this John worked in the eCommerce Architecture group and was involved in design and architectural directions for IBM WebSphere Commerce Suite. Before coming to IBM he specialized in application software solutions for Insurance and other industry sectors.

Making intelligent decisions is critical if you want to grow your business and enhance your competitive edge. Today?s System z is the best data-serving platform to centralize your data-warehouse and enable you to spot trends. DB2 for z/OS is easier and more accessible than ever, and compares favorably with distributed systems running Oracle RAC with respect to scalability, availability, security and TCO. Furthermore, deploying Next Generation solutions often requires you to integrate Unix and Windows servers. But instead of bringing much-needed agility these heterogeneous environments quickly become an escalating nightmare of administration and costs (including power and cooling). There is an easy solution ? deployment using Linux on System z, marrying the robustness of the mainframe with lightening speed and the ever-increasing availability of new applications. We will show how mainframe virtualization is streets-ahead of virtualization on any other platforms (such as VMWare).

Security and compliance have become of prime importance as breaches and exposures gain national attention and force governments to act. The mainframe remains a highly secure platform which helps to improve overall compliance posture and reduce risk. This presentation describes the breadth of System z security capabilities and how mainframe hardware and software raise the level of security for the enterprise. We will discuss new capabilities that further bolster the compliance and privacy profile of business applications and show how you can analyze and audit potential security violations before they have an impact. We will also discuss the latest aspects of mainframe systems management, including an overview of the Tivoli suite of systems management products that can ensure the performance and availability of your critical business applications on System z.

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.

If you think that the mainframe is expensive then you are in for a surprise because System z is often the cheapest platform for Next Generation systems. We will discuss the components of TCO and show how the mainframe really has the best value. Not only is it the least expensive platform but also cost savings continue to improve over time. We will conclude by showing how the mis-perception came about, and how a new tool can properly show the true TCO so you can now establish and prove reality.

IT is many decades old, but still we fight ancient issues. IT have developed, but have we?? Did IT go where we wanted it?? Are we still just Homo Ludens ? The Playing man??

Ove B. Larsen is a solutions engineer at ASG, Allen Systems Group, in Copenhagen with almost 40 years of programming, systems-programming, problem crunching and application integration mostly on the so called big iron, and has seen the most from a 24x7 perspective.

This session will briefly describe some of the history of the Open Source Software movement, its implications for both developers and consumers of the software, some of the types of open source software that is a generally available and also IBM's provision of selected open source tools for z/OS.

Ian Mitchell is an IBM Senior Technical Staff Member at the Hursley Development Lab. He's spent nearly 20 years working on CICS and is currently the Architect for CICS TS for z/OS. He regularly presents sessions at SHARE, the Transaction and Messaging Conferences and for regional GSE Conferemces.

RACF, PKI, Kerberos, LDAP, Communications Server, EIM, WebSphere, and heritage applications; this presentation takes a survey view of z/OS security and the rich set of functions that have evolved in reflection of the flexibility and richness of z/OS itself. Besides adding clarification to your understanding of the topology of z/OS security today, the presenter will discuss important trends and directions that are expected to affect the future.

Jack Jones has 30 years of experience with IBM in the z/OS, storage, and security areas. He has a CISSP certification, as well as IBM's internal certification for security. Jack has presented at IBM conferences as well as SHARE in the US, Asia, and Europe. He currently is assigned to Advanced Technical Support at the Washington System Center.

The session will go through the approach and lessons learned on a large bank integration program and the speaker will give hints and tips on how to conduct a successful integration from performance and high-availability Point of View. They will give a background of the platform and the challenges and the test approach. Lessons learned on method and methodology as well as tools and challenges will be in focus. Tools and organisation will be covered and a great desal of the time will be spent on the way to analyse bottlenecks and how to get application development and technical teams to fix these and get a highly performing and available system as a result. The platform for this was a four way mainframe SysPlex based upon IMS and DB2 databases with transactions from CICS, IMS, Shadow Web and MQ all utilising full data sharing across the sysplex.

Per-Olof Lindqvist is a Senior IT architect with IBM, who has done several Bank and Mainframe consolidations during the last ten years. He has a long technical background on Mainframe systems.

IBM has been increasing its investment in mainframe hardware ona has management responsibility for the team that designs, develops and supports DB2. In this role, she provides leadeand software in recent years, and continues to accelerate and increase that investment. At the same time, many of our customers are engaged in application and infrastructure upgrades/replacements. As you go through your own investment cycles, are we investing in the best way to help you succeed? We see many opportunities for you to leverage the mainframe as you consolidate, reengineer and grow. We understand some of the inhibitors you face - skills, cost of acquisition, etc. This session is intended to explore both opportunities and inhibitors in open discussion.

Fiona Gleeson is the Director of z Growth in Information Management. In this role Fiona focuses on the growth of our Information Management portfolio, especially DB2, on the mainframe. During her career, Fiona has held a variety of management and technical roles across IBM's Software Group, primarily in the Information Management division of Software Group. Prior assignments include development responsibility for DB2 UDB for Linux, Unix and Windows, and development of business intelligence software in the ExtractTranformLoad (ETL) space. Her most recent role was as Director of DB2 for z/OS, where she had management responsibility for the team that designs, develops and supports DB2 for z/OS.

Multidisciplinary cognitive neuroscience extends from neurobiology to bioinformatics enabling us to study, with the aid of e.g. brain imaging techniques, how the neural networks of the brain are activated during different types of cognitive tasks. Working memory, its interaction with long-term memory structures (our individually unique brain data bank) and optimal use of attentional resources are the corner stones of information processing of the human brain. Frontal lobe functions are essential for controlling and monitoring our behaviour. The physiological state of the autonomous and nervous system, e.g. vigilance, sleepiness, stress level, have an effect on overall brain well-being and thus also cognitive and mental performance. In modern work, Information and the technology applications used for its handling and processing are basic tools for carrying out tasks. Human and artificial intelligence meet at computer interfaces. Computational engineering, data mining and research on neural networks provide new applications for visualization of information at interfaces. Neurocognitive ergonomics aims at providing knowledge on how the brain and mind function so that these human-related factors can be taken into account the development of user-friendly technology. The main goal is to ensure that the solutions support human information processing also in cognitively complex environments. Optimizing information loading is also relevant for the overall health of the brain.

Kiti Müller, MD, PhD is a specialist in neurology and traffic medicine. She is the research professor and head of the Brain and Work Research Centre at the Finnish Institute of Occupational Health, Finland. Additionally she teaches cognitive neurosciences at Helsinki University and neurocognitive ergonomics at Helsinki University of Technology.

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 DB2 and IMS chairman will be elected during this session.

Jørgen Malmstrøm will be the chairman of the 2008 Technical Conference.

A presentation of how Jyske Bank has designed layered application arhitecture and how they decouple the physical programs:
What layers do they have, which responsibilities do the layers have, what has been built in the infrastructure, and what must the developers do by themselves. What are the costs in building layered application, and what are the costs in runtime environment.
The process: How does Jyske Bank practice coming from designing services to developing the physical programs and databases.

Helle Fredberg Nielsen has 19 years of experience as developer (mainly mainframe) and project mamager. 3 years as an architect, working on project designing a component based architecture.

XML and Web Services together fundamentally changed application integration on the Internet. Extensible Stylesheet Language Transformations (XSLT) is an XML-based language used for the transformation of XML documents into an HTML, plain text, or another XML document. Come to this introduction and learn about XML structure, XML parsing, Web Services, XSLT and other technologies in this arena. The session will also introduce IMS OnDemand products that utilize XML and Web Services!

Deepak Kohli has over 25 years of experience in the IT industry. He is currently working for IBM at SVL as the Team Lead for IMS On Demand Level 2 team.

Why has Java revolutionized the computer programming industry? What has made this language such a phenomenon? When and how did it all start? How does Java fit in with legacy systems (like IMS)? What's an applet? What's Bytecode? What's JDK, JVM, JIT? What's a Java Bean? If you've ever pondered these questions on a sunny Saturday afternoon, then this session is for you. This session introduces Java as a programming language. It discusses concepts such as classes, bytecode, applets, Java development kits (JDK), Java Virtual Machine (JVM), Just-in-time (JIT) compilers and many other concepts.

JCA (J2EE Connector Architecture) is a standard that provides a uniform method for talking to different kinds of Enterprise Informations Systems (EIS) from a J2EE-complaint application server. A resource adapter is a J2EE component that implements the J2EE Connector Architecture (JCA) for a specific EIS. Examples of JCA-somplaint resource adapters are the rar files provided with CICS Transaction Gateway and IMS's IMS TM Resource Adapter (formerly known as IC4J). This session provides a high level introduction to JCA.

RXS is a framework around REXX-coding, with the high-level structures of the language offering interfaces to all mainframe resources, from MQ to XML. This is done in a uniform syntax, adhering strictly to a 'filters-and-pipes' setup. Seeing utility programming as some piping or plumbing work, some urban utility company aimed at making data flow vivid and controlled in the programming department will make the picture. The category 'scripting languages' is two-faced: It denotes a language focused on the linking of resources and activities on the computer using a script - a programmed sequence of actions. Or a language focused on the generation of coding, that is to make the lines of a C or COBOL (or whatever) program depend on some input, or to script the making of the program. RXS is propelling both kind of scripting. Resources for the language are at www.kmboegh.dk. This session is a discussion of scripting, and the use of RXS. Pro and cons is also discussed: RXS is a small language, giving small and hard hitting programs, the flip side being that you are forced to think and visualize scripting differently, thinking 'filters-and-pipes'.

Morten Bøgh has worked for 16 years with the coding of the Danish Tax System - 15 million COBOL coding lines; all to be kept alive and well, and one million of the lines renewed every year. As technical coordinator for the system, Morten has been forced to - or has chosen to - promote heavy use of scripting, to keep programming, testing and configuration management tidy.

With enhanced processor speeds and increased storage limits, application tuning is becoming an obsolete art. That is not a reason to ignore the subject, as many performance benefits can now be gained by exploiting new technology and the latest releases of software. As CICS systems grow, they must support new applications that have been derived from legacy programs to enable Web technology. It is imperative that in order to support this new growth, the enhanced application still provides the end user with the service and responsiveness they are familiar with - in effect, a transparent migration from old to new technology.

Peter Siddell is a Technical Specialist with CICS Tools Development at the Hursley Laboratory. He presents on various CICS topics as well as the CICS Tools Portfolio, and teaches CICSPlex/SM.

If you think, JCL is not readable or understandable, and you just copy somebody else?s Job and submit crossing your fingers, come and become and JCL-expert in one hour.
If you think, ORDER has to do with SQL and not JCL, that IF THEN ELSE and INCLUDE are statements in PL/1 and not JCL, CCSID might come from a ISPF-panel and not JCL, that OUTPUT is a pile of paper and not a JCL-statement, come and become and JCL-expert in one hour.
Enjoy a 50 years development with JCL and learn how to love your BATCH-jobs ? because there you can read and understand all, that happens!

Kim Ørtved has been a longhaired and bearded MVS-, ISPF- and DB2-hippie and is now turning into a grey haired grandfather having problems remembering complicated languages and commands used in the IBM -world. So why not stick to a simple powerful language JCL: With less than 10 statements it gives you fully controlled, unlimited access to all the powerful MVS-resources, while you relax at home: The simple, readable and debugable Job Control Language. Enjoy the Magical Mystery Tour and become an expert in one hour - satisfaction guaranteed.

Hiperbatch is a feature introduced in MVS/ESA in the early 1990s to exploit Expanded Storage. Its primary purpose was to facilitate simultaneous access of a sequential data set by multiple jobs. Does it still have a role in the new millenium? This presentation covers the basics of when and how to use this arcane facility.

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.

New features in DB2 V8 can simplify DB2 application development, making application code that faster to write, easier to maintain and with better performance. On the other hand, other new features may provide limited benefit to many organizations. This session will describe what's hot and what's not for application developers.

This presentation will highlight the many technical innovations in the recently announced CICS TS release in the areas of application integration, reuse and service management. This includes new Web service capabilities, interconnecting CICS regions over TCP/IP, systems management and performance enhancements for TCP/IP workloads, on-line management of program libraries, support for Enterprise Workload Manager, enhancements to CPSM, and much more.

Mark Cocker is a CICS TS consultant working for IBM Software Group at the Hursley Laboratory. Since joining in 1992, Mark has worked in various roles in CICS Development, the Change Team, the Beta program, the IBM Design Center for e-Business on Demand, and now in CICS Technical Strategy and Planning. Mark's responsibilities have included developing code, problem diagnosis and resolution, customer programmes, consulting on best practices and proof of concepts, and most recently defining elements of future product releases. Mark regularly presents the latest CICS TS capabilities and product strategy.

This session will take a look at the improvements made to CICS TS v3.2 to remove constraints on data tables capacity, the use of larger ESDS data sets, the removal of the limit on CICS systems using MRO/XCF connections in a sysplex and the extensions to threadsafety including for CICS File Control. CICS TS v3.2 also supports the Application Response Measurement (ARM) standard for Enterprise Workload Management. The session will describe the benefits and features of this capability and show how CICS TS systems appear on the the z/OS eWLM console.

During 2007 it is expected that there will be a new release of CICS Transaction Server. This product will incorporate CICSPlex/SM, IBM's strategic system management software for CICS installations. One of the major features of any new release of CICSPlex/SM will be the removal of the End User Interface (EUI), and it's natural successor, the Web User Interface (WUI). This session will highlight the new features that are included with this release.

Discover how you can use the new CICS Service Flow Feature to to create business services by composing a sequence of CICS application interactions. These business services can be called like any other CICS program and be readily published as Web services in an SOA by exploiting the Web services capabilities of CICS TS V3.1. This approach complements and extends the Web services capabilities offered in CICS for use with composed CICS applications.

Scott Clee is a senior CICS Tester based in the IBM UK Hursley laboratory. Over the last 6 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 more recently has co-authored two CICS Red Books; "Java Application Development for CICS" and "CICS Transaction Server V3 R1 Channels and Containers Revealed".

This presentation introduces the concepts and value of a Web services repository as a metadata repository for service descriptions, including a closer look at how the WebSphere Service Registry and Repository (WSRR) fulfils this role. We will also look at how the recent CICS SupportPac CA1N can be used to automatically register WSDL that represents CICS Web service providers and extract WSDL that can be used by CICS Web service requesters.

With the open nature of Web Services comes the need to provide secure and coordinated information exchanges. Through collaboration of industry leading technology companies, the WS-Security and WS-Coordination standards have been introduced. These extensible standards allow new and existing security and communication technologies to interoperate between disparate system to guarantee the integrity and security of data. This presentation gives an overview of several new technologies for Web Services, and a detailed look at security and transactions using the Web Services standards in CICS TS V3.1.

The almost universal acceptance of TCP/IP networking has demanded many improvements in the zSeries networking infrastructure in order to offer the same Qualities of Service for TCP/IP networks as historically provided for mainframe based SNA networks. This talk explains how the TCP/IP load balancing technology provided by Communications Server for z/OS can be utilised by z/OS sub-systems such as CICS, CICS Transaction Gateway, or MQ Series, to provide the performance, recovery and availability characteristics required in a modern zSeries enterprise environment. The talk will introduce you to the Port Sharing, VIPA, and Sysplex Distributor functions of Communications Server, contrast these with proprietary TCP/IP load balancing solutions, and provide real-life examples of how they have been exploited in customer environments.

CICS Transaction Server 3.1 extended Open Transaction Environment (OTE) support to allow OPENAPI and XPLINK applications. This session looks at threadsafe coding techniques, what types of applications are best suited to exploit OPENAPI and XPLINK, and what types of application are best left as THREADSAFE CICSAPI applications.

Preparing your CICS configuration to run in a Sysplex environment requires more than just making changes to CICS and z/OS. Your applications must be examined in detail to understand whether or not they are "sysplex enabled". If not, what can be done to ensure that the services you are providing can run interrupted, and are available 24/7. This session will look at what constitutes an affinity, and what steps can be taken to remove them. In some cases, this may not be possible, so what fallback is there for those applications?

Discover what Java support in CICS is all about by learning how to configure, run and debug your Java applications inside of CICS. This session provides an explanation of JCICS terminology and the capabilities of the JCICS API. Learn to configure Java in CICS and to enhance the performance of your Java programs. If anything goes wrong it'll be useful to know how to debug them too! See how CICS has fully embraced the Java language and how it can interact with programs written in any of the CICS supported languages.

This session will tell you about the latest enhancements to CICS Monitoring and Statistics in CICS Transaction Server Version 3. Did you know that you can now monitor file and temporary storage queue usage by transaction or something called application naming support? No? Well, come to this session to hear about this and some of the other many enhancements to CICS monitoring and statistics data in support of the new functions in CICS Transaction Server V3. Topics such as the monitoring and statistics data for the CICS Web services support, the enhanced CICS Web Support (CWS), security performance improvements (SSL), and the Open Transaction Environment (OTE) will all be covered as well as the latest updates to the utility and sample programs including the statistics sample program DFH0STAT.

CICS TS 3.1 provides tooling and runtime changes to enable you to implement Web services directly in CICS. These changes build upon the SOAP for CICS feature, which was available in CICS TS V2, but now the support is fully incorporated into CICS. There are tools provided to assist you in preparing existing application programs to become Web services and also to assist with starting from WSDL and implementing a program in CICS which can act as the Web service as defined in the WSDL. This presentation explains the tooling provided and how it can be used. It also explains the runtime support for Web services.

This presentation will provide details on the content of DB2 9 for z/OS and will talk about future directions for the DB2 for z/OS product. This will include a description of some of the top customer requirements that are under consideration for the new release.

This presentation will talk about the current options that are available for accessing databases from Java applications, and the operational challenges that those options present to enterprise IT customers. The presentation will provide details on IBM's plans to provide new database access technologies that will fit into these existing data access frameworks, and provide solutions to the operational challenges.

This session will introduce and discuss the performance impact of DB2 9 for z/OS, especially Performance/Scalability enhancements (Insert/Update/Delete), Query/Access Path Performance Enhancements, Other Performance Enhancements (Native SQL procedure, Index compression, Varchar, Utility), Synergy with new hardware, and VSCR below 2GB DBM1 virtual storage usage

John is an IBM Distinguished Engineeer working for 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 specializes in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications. He is recognized by IBM Development and leading IBM customers as a worldwide authority for high end DB2, SAP R/3, CICS, and WebSphere for z/OS systems.

This session is a follow up to the session ''Health Checking Your DB2 System? session given at previous conference. This session will discuss individual and collective settings for: DSNZPARM, local bufferpool, group bufferpool, BIND options - the gotchas aka the law of unintending consequences, positive vs negative impact on system performance, trade offs between optimum performance vs. robust defensive performance to main high availability.

During the past several years we have worked with several companies to design high performance databases and applications and have done extensive testing and research on ways to minimize I/O and CPU. Many of those applications and databases are faster than we ever could imagine. However, those are the exception. Too often we see shops with critically CPU constrained environments. Most of these shops have one thing in common: They are wasting CPU. There are some very common ways to do this and we need to look at how you can safely and effectively reduce CPU usage in a DB2 z/OS environment. This session will look at the top 10 ways we have seen customers waste enormous amounts of CPU unnecessarily (and unknowingly).

Susan Lawson is an internationally known speaker and consultant. She specializes in design, development and tuning of high performance DB2 z/OS databases and applications.

In this session 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.

This 'Data Warehousing on System z'-Best Practices presentation addresses customers with their main OLTP database on DB2 for z/OS who want to benefit from a consolidation and/or modernization of their warehouses and data marts to achieve near real-time data warehousing, single enterprise wide data warehousing, best of industry security and regulatory compliance.
See the benefits of profiting by the cost effective System z Integrated Information Processors (zIIP) for reporting accelerators, analytic accelerators, and ETL accelerators.
How to use ETL accelerator to build a warehouse from various operational data sources?
How to use analytical and reporting accelerators within the Data Warehouse on System z?
Come and discuss with us our experience of taking advantage of DB2 on System z for your Data Warehousing Needs

Jaime has been a developer at IBM's Silicon Valley Laboratory in San Jose, California, for 17 years.
Jaime joined DB2 for z/OS development in 1989 as part of a core team of architects, designers, and developers working on n-way sysplex data sharing for DB2, eventually becoming the IRLM technical lead.
In 2000, Jaime joined the DB2 Replication team to help lead the rearchitecture that culminated in the release of Q Replication technology for high throughput and low latency replication. In 2006, Jaime has returned to DB2 for z/OS development as a DB2 Architect to lead the positioning of end-to-end BI solutions exploiting warehousing on System z and DB2 for z/OS.

Many applications enter production with sub-optimal indexing strategies. Regardless of the reasons for this, performance can be substantially improved if indexes are redesigned to better match the needs of the application.
This presentation will review index structure, and discuss a number of ways to redesign indexes without affecting application integrity. This presentation applies to all DB2 platforms, and examples will come from the presenter?s experience. The use of IBM?s Explain will also be shown.

Martin Hubel is an independent consultant and has worked extensively with DB2 since 1985. Martin develops and teaches both basic and advanced DB2 classes. He is a member of the IBM Gold Consultants Program, is a member of IDUG Board of Directors, and is the Executive Editor of the IDUG Solutions Journal.

While testing should be designed with finding errors in mind, there are many other aspects of relational applications that also require testing. These aspects include set processing, referential integrity, and procedural constructs. In addition, stress testing in a concurrent online and batch environment also provides special challenges. The session will address these topics and more.

Imagine a typical three-tier application - SAP and PeopleSoft are examples of these. Remember how these applications utilize a single common authid for all communication with the database server? Even when the communication is administration of database objects? This authid must hold all the privileges needed for each part of the application, leaving the authorization of different types of end-users to the application. Also, the audit trail in DB2 does not reveal much as all transactions are made with the same authid.
On the other hand imagine a DBA doing monthly database maintenance in the production environment. The work requires extensive privileges that are beyond what is accepted on a daily basis and should not only be limited to these times, it should also be audited.
DB2 V9 for z/OS offers two powerful new constructs that enhance security and audibility, solving these two problems along with many others.

Kirsten Ann Larsen is a senior IT specialist with IBM in Denmark. She has worked with DB2 for 10 years, since version 4. She has recently co-authored the redbook 'Securing DB2 and Implementing MLS on z/OS'.

Businesses now realize that the time spent improving the performance of a DB2 application and the software to assist in that task is justified. This presentation will provide a basis for evaluating the performance of existing and planned DB2 applications.
Tuning SQL statements involves the analysis and prudent use of several factors depending upon the type of SQL and the performance tradeoffs that must be made. Performance tradeoffs are made based upon the cost of resources to accomplish the required business functions
This presentation provides a basis for understanding the DB2 Optimizer and information that will assist you in making reasonable decisions regarding the source of the performance problem and the place to look in the data for clues to the root cause of the performance problem.

Paul Oostvogels started as IMS systems programmer in the early 80?s, moved into the DB2, at that time v1.2. Worked as a DBA and Systems programmer in various companies throughout Benelux before joining BMC Software in 1995. Paul is Principal Consultant at BMC Software EMEA. He has more than fifteen years of experience with DB2 and has presented papers at several European conferences and local user-groups. He assists in selecting, implementing, and educating the IMS, DB2 solution offerings from BMC Software throughout the Northern European Countries. Many customers appreciate Paul's technical leadership on several domains of DB2 data management.

DB2 for z/OS is a true industrial strength database server that satisfies the most demanding requirements for high availability, continuous operations, virtually unlimited number of users and database size, superior scale out and top performance. The world's largest and most challenging installations regularly include DB2 as their prime database management system. In the recent years DB2 has been under considerable pressure from its competitors, most notably Oracle RAC. They claim to provide the same functionality and quality of service characteristics as DB2. Many in the IT community accept these claims very easily. DB2 specialists are often asked by the business decision makers to articulate DB2 technical advantages and justify the choice of DB2 as the database server. Why is DB2 for z/OS considered the ultimate database server? What are the technical differentiators by which it stands out, particularly against Oracle RAC? Why should every enterprise infrastructure include DB2 for data serving? This session provides answers to these questions.

JN Data has installed DB2 version 8 on all LPARS and they are exploiting the new functions.
This presentation will tell about their experiences with Automatic Space Management, The use of Multirow SQL (Block Fetch/Insert), some considerations about Materialized Query Tables and backward index scan as well as DPSI-experiences.
Come and see how the tooling and implementation was done.

Svenn-Aage Sønderskov is the chairman of the DB2 Working Group in GSE Nordic and is DBA/Sysprog/development support for the 7-800 developers at Jyske Bank and Nykredit in Denmark. Svenn-Aage has 31 years experience from all the areas of IT as both a developer, systems programmer and DBA.

IMS helps companies provide flexible processes to quickly and easily connect and manage their business transaction systems. IMS provides a strong, agile, adaptable base, using new technology to address evolving requirements. IMS enables investment protection through Web Services, autonomic enterprise management and ultra scalability. IMS not only keeps pace, but sets it. Unleashing the power of IMS information, companies can better serve customers, make business decisions rapidly, improve operations, increase productivity, and ensure regulatory compliance. This session discusses new and future IMS solutions, integrated with DB2, eased manageability with autonomic computing, and increased scalability in availability, recovery, performance and capacity. this session the technical advances and solutions that IMS provides for global Integration to ensure that IMS is still the best solution to help you evolve your business in this rapidly changing world, where resource/skills shortages have become a way of life.

Steve Nathan has 34 years of IMS experience as a developer, application analyst, DBA, systems programmer, and performance tuner. For the last 4 years he has worked for IBM in IMS Level 2.

This session provides an overview of IMS Version 10, which was announced in October 2006, and is expected to become generally available towards the end of 2007. Version 10 is the most exciting new IMS release for many years, and provides new functions relevant to a broad range of IMS customers. New features include Dynamic Resource Definition with an associated reduction of disruption caused by Online Change. The new operator interface introduced with the Common Service Layer (in Version 8) has reached maturity in Version 10, and makes SPOCs the operator interface of choice. The usability and performance of MSC is significantly enhanced, and fo