Primary tab navigation

DB2 sessions

Click on the triangle before each session title to view description and speakers

Administration sessions

  • -IDZ-1140A The Many Uses of the FlashCopy Function with IBM DB2 for z/OS
    The FlashCopy function makes it possible to create, nearly instantaneously, point-in-time copies of entire logical volumes or data sets. This function opens up new possibilities. Even IBM DB2 for z/OS utilities have started to make more use of FlashCopy technology. This session introduces the copy options that are supported by FlashCopy and explains how DB2 for z/OS can use them. This session provides hints and tips on how to set up your environment. It also addresses common pitfalls, including all the possible issues when combining FlashCopy and IBM Remote Copy Services, including Metro Mirror (PPRC), z/OS Global Mirror (Extended Remote Copy), Global Copy and Global Mirror.
    Speaker: Florence Dubois, IBM, Consulting IT Specialist
  • -IDZ-1657A IBM DB2 for z/OS Management and Tuning - Best Practices in Information Technology
    Infrastructure optimization goes beyond products and technologies. People and processes are involved too. Many standards and best practices in organizations address this area in IT service management. This presentation addresses IBM DB2 for z/OS management and tuning, starting with data modeling, database design and testing and end with performance monitoring suggestions. We will touch areas of application, database and system performance. Due to the sensitive nature of the records involved, the company's testing team will have to find a way to de-identify the data they use, while ensuring that the data sets remain meaningful. . What is the role of the database administrator and his tasks in IT? What role does ITIL have with DB2?
    Speaker: Zeljen Stanic, CA Technologies, Sr Solution Strategist
  • -IDZ-2030A Governing Your DB2 for z/OS Subsystems for Improved Availability
    We will review steps that we have taken over the last two years working with IBM to improve governance for users of IBM DB2. Previously we were having issues because of unexpected workloads causing impacts to more critical workloads.
    Speaker: Greg DeBo, State Farm, IT Architect
  • -IDZ-2033A Hands-on lab: Back to Basics IBM DB2 for z/OS Accounting and Statistics Counters
    Almost all of IBM DB2 for z/OS users gather DB2 accounting and statistics information into SMF data, but do you also use, understand and exploit the information that is in those records. There might be too many counters for the beginners to start with. This session will start with very basic counters such as accounting class 1, 2 and 3. Using the actual traces we have collected or received, we will analyze key metrics and learn how to take advantage of this great source of information. The goal is to become familiar with the information in DB2 accounting and statistics traces and be able to interpret the key performance fields from this gold mine, DB2 accounting and statistics.
    Speaker: Akiko Hoshikawa, IBM , STSM, DB2 performance; Ting Xu Guan, IBM, Worldwide DB2 for z/OS level 2 support; Maggie Jin, IBM, Advisory Software Engineer; Brian Baggett, IBM, Senior Software Engineer
  • -IDZ-2125A IBM DB2 for z/OS: The Super-Server for Client-Server Applications
    Some people think of mainframes as the platform on which heritage applications run old-fashioned, monolithic, green-screen applications written when Pac-Man was cutting-edge game technology. While its true that some older programs still run on mainframes (that’s compatibility with later versions a good feature), today’s System z, paired with DB2 for z/OS, is, across industries and worldwide, the foundation for modern, multi-tiered GUI applications, written in languages such as Java and C# / .NET. In this session, you’ll learn what’s fueling the growth of mainframe DB2 client-server computing, and why DB2 for z/OS is king of the data server hill when it comes to scalability, availability, security and operational flexibility.
    Speaker: Robert Catterall, IBM, Consulting DB2 Specialist
  • -IDZ-2422A Practical WLM for Distributed Access to DB2 for z/OS
    Distributed workload is more and more present in today's IBM DB2 environments. A typical distributed workload can be described as a mix of short transactions and long-running reports having different business importance. A common characteristic is the unpredictability of resources demand for each execution, but end user's response time expectations are always high. How could a database administrator (DBA) tune a system in order to protect the important work, penalize badly behaving jobs and keep end users satisfied? Work load manager (WLM) provides great tools that can help you on this task. This session will discuss these tools from a DBA point of view.
    Speaker: Cristian Molaro, MConsulting, Consultant
  • -IDZ-2426A Why, Where And How: Using DB2 for z/OS Trusted Contexts and Roles
    An introduction to IBM DB2 for z Trusted Contexts and Roles: Why, where and how to use the database. Exploration of the conditions and the benefits related to the use and exploitation of trusted contexts and roles. A step-by-step guide to implementation, including dos and dont's.
    Speaker: Cristian Molaro, MConsulting, Consultant
  • -IDZ-3063A DB2 for z/OS Security: New Ways to Protect Your Assets
    IBM DB2 for z/OS supports security management using DB2 native controls, as well as external controls. Security controls using external authorization is not always compatible with native authorization. This presentation will discuss the enhancements in DB2 11 for z/OS that provide new ways to address the restrictions when using access control authorization exit. This presentation will also discuss other security enhancements in DB2 11 for z/OS.
    Speaker: Gayathiri Chandran, IBM, Senior Software Engineer
  • -IDZ-3063B DB2 for z/OS Security: New Ways to Protect Your Assets
    IBM DB2 for z/OS supports security management using DB2 native controls, as well as external controls. Security controls using external authorization is not always compatible with native authorization. This presentation will discuss the enhancements in DB2 11 for z/OS that provide new ways to address the restrictions when using access control authorization exit. This presentation will also discuss other security enhancements in DB2 11 for z/OS.
    Speaker: Gayathiri Chandran, IBM, Senior Software Engineer
  • -IDZ-3361B Set Yourself Free with Real-Time Statistics
    IBM Real Time Statistics (RTS) will set you free from the chore of scheduling Reorgs and Runstats. RTS can help optimize these processes and provide a vendor-neutral solution for these mundane but important tasks.
    Speaker: Paul Walters, Navy Federal Credit Union, DB2 DBA; Jim Reed, IBM, Program Director

Application development sessions

  • -IDZ-1007A Unleashing the Power of XML Retrieval with XPath and Xquery
    This session focuses on retrieving values from an XML column. It begins with a short theoretical overview and simple to complex examples. It demonstrates the use of XPath, which was introduced in IBM DB2 9 for z/OS, and XQuery as an APAR in DB2 10 for z/OS. This session helps you prepare for developer questions about how to use and retrieve XML columns. You gain basic navigation skills to FLWOR (pronounced as flower) expressions and XML constructs. This session also explains XML retrieval by showing you step-by-step examples.
    Speaker: Kurt Struyf, suadasoft, senior consultant
  • -IDZ-1025A Sensor Data as Big Data for IBM DB2 for z/OS
    John Deere has an application that gathers telematics data from sensors on machines in the field. Recently the company redesigned this application to provide scalability for future demand. This session explore big data, John Deeres application, and some of the basic concepts of IBM DB2 for z/OS that the company implemented to meet the challenges of this application. This session includes information about such DB2 concepts as page size, clustering, partitioning, SEQUENCE OBJECTS, and APPEND. You will see the John Deere application suite of products through two videos.
    Speaker: Bryan Paulsen, John Deere, Technology Architect
  • -IDZ-1215A Real-Time Analytics on Transactional Data with IBM DB2 Analytics Accelerator
    In this session, you learn how to use IBM DB2 Analytics Accelerator to perform analytical queries on OLTP data. This session highlights use cases and benefits, both from a business and IT perspective. It also demonstrates the savings in processor cycles and tuning reduction efforts. The differences between DB2 and IBM Netezza SQL are also presented.
    Speaker: Thomas Baumann, Swiss Mobiliar, IT Performance Architect; Carlo Marchesi, IBM Switzerland, PureData TechSales, PureData Champion
  • -IDZ-1470A Hands-on lab: Integrating DB2 for z/OS with Big Insights for Big Data Solutions
    This HOL focuses on coming key technologies in DB2 11 for z/OS that enable a seamless integration between DB2 and Big Insights, using both structured and non-structured data. We also show how DB2 for z/OS provides SOA solutions using SOAP and REST UDFs and pureXML. We will cover common usage scenarios that can apply to your business. We will show what needs to be done in the DB2 server and what information your application needs to know to create an enterprise with great performance, improving customer satisfaction, maximizing profit, and minimizing cost.
    Speaker: Jane Man, IBM, Software Development; Rick Chang, IBM, Advisory Software Engineer; Jason Cu, IBM, Senior Software Engineer
  • -IDZ-1620A IBM DB2 Version 11 for SAP Solutions
    IBM DB2 Version 11 raises the bar to further optimize SAP solutions. It improves performance of SAP applications and scales them higher. Also, there are exciting enhancements in DB2 utilities to seamlessly work with high-end SAP application workloads such as SAP Banking. This session discusses the ground-breaking improvements of DB2 11 that are particularly beneficial for SAP workloads and shows which challenges they address typically. These capabilities also benefit other enterprise applications that are based on Open Database Connectivity (ODBC), CLI and Java Database Connectivity (JDBC).
    Speaker: Johannes Schuetzner, IBM Deutschland R&D, STSM
  • -IDZ-1652A Temporal Enhancements of IBM DB2 11 for z/OS
    This presentation discusses the major improvements in temporal support that deliver more capabilities for application developers. Enhancements include time machine support without requirement on changing applications and providing temporal features to users of views. In addition -- built on top of DB2 10 temporal -- a more comprehensive and generic auditing proposal will be discussed to track who, how, where, and what, which is ever more relevant in today's information management. Temporal data is going to be integrated into all future system designs, and this presentation shows you how to take advantage of these new features and the design considerations. It also shows the best ways to implement it for achieving overall performance.
    Speaker: Steve Chen, IBM, DB2 z/OS architect, STSM; Xiaohong Fu, IBM, Software Development
  • -IDZ-1755A Banco do Brasil: Delivering a Fast, Reliable, Secure Business Analytic Environment on System z
    Banco do Brasil, the largest Latin America Bank, will show and discuss how they are delivering a fast, reliable, and secure environment for business analytics running on System z with DB2 for z/OS, IBM DB2 Analytics Accelerator and IBM Replication Server, among others.
    Speaker: Italo Freitas, Banco do Brasil, System z Manager; Fabricio Pimentel, IBM, Information Architect; Rafael Toshio, IBM, Client Technical Specialist - Information Management Software
  • -IDZ-1860A Exciting pureXML Enhancements in IBM DB2 11 for z/OS
    This session focuses on new XML features and enhancements in IBM DB2 11 for z/OS, and XML features delivered to the services stream of DB2 10. We will show how to use some of these leading-edge features and enhancements to improve performance and development productivity. We will illustrate using XQuery to simplify the application logic in handling XML documents. We will also show how to use these enhancements to improve performance: partial validation of XML document after XMLModify, binary XML validation, XQuery and XMLTABLE performance enhancements and others. We will cover common usage scenarios that can apply to your business. We will also share a success story of a major client who recently adopted the DB2z-pureXML solution.
    Speaker: Jane Man, IBM, Software Development; Mengchu Cai, IBM, DB2 for z/OS development; Rick Chang, IBM, Advisory Software Engineer
  • -IDZ-2147A Cool SQL for Real World Problems
    Do you ever wonder if there are legitimate use cases for certain clauses of SQL statements? Who uses recursive SQL? Why would you want to use a nested table expression? What is an INSTEAD OF trigger and when would you use it? Learn the answers to these questions and many others from over 25 years of experience spent assisting application developers in developing effective and efficient SQL statements using IBM DB2 for z/OS.
    Speaker: Glenn McGeoch, IBM, Senior Certified IT Specialist
  • -IDZ-2331A Hands-on lab: IBM DB2 Analytics Accelerator
    The IBM DB2 Analytics Accelerator brings revolutionary query performance to DB2 for z/OS for select queries with great cost/performance characteristics. It is a workload optimized, appliance add-on, that enables the integration of business insights into operational processes to drive winning strategies. IBM DB2 Analytics Accelerator is deeply integrated with DB2 9 and 10 to combine the best of both System z and Netezza technologies to deliver unparalleled, mixed workload performance to DB2 applications transparently. This hands-on lab contains step-by-step instructions on using IBM DB2 Analytics Accelerator to accelerate DB2 queries.
    Speaker: CJ Chang, IBM, Software Engineer; Maggie Jin, IBM, Advisory Software Engineer; Roy Smith, IBM, Advisory Software Engineer; Ruiping Li, IBM, Senior Software Engineer
  • -IDZ-2488A Reconcile Big Data Technologies with Business Needs: A New Data Strategy
    Actual business is facing new challenges and a new approach to business intelligence (BI). This implies new requirements and challenges for the IT architecture: more data and a larger number of users to deal with. Banca Carige have kept this challenge and have selected DB2 on z and IBM DB2 Analytics Accelerator to give support to the new architectural vision where a new class of applications for new users in the enterprise will be deployed. Having DB2 safety, mainframe reliability and Accelerator performance, Carige is finding new ways to build a true real-time analysis on full enterprise data. The presentation will go thru new business needs, will show why the platform was selected and give a bird's-eye view on best practices, new approaches and first projects outcomes.
    Speaker: Daniele Cericola, Banca Carige, ICT Governance Director; Enrico Caraffi, IBM Italy, IT Architect, Technical Sales & solutions System z Information Management
  • -IDZ-2599A NoSQL and DB2 for z/OS - Receiving Agility from a Trusted Enterprise Database
    A new era of applications focused on mobile devices and systems of engagement are becoming increasingly important in large enterprises. Often, NoSQL database technologies are becoming that system of engagement, because they make rapid development with flexible schemas easily achievable. JSON and JavaScript are core enabling technologies. This session will cover how you can use NoSQL technologies such as JSON and JavaScript within your DB2 environment so that you can have both the flexibility and agile development models along side your enterprise data management requirements.
    Speaker: Skyla Loomis, IBM, Program Director, Optim Tools Development; Bill Bireley, IBM, Senior Software Engineer
  • -IDZ-3268A Oracle SAP Winback to System z and DB2
    The utility company in Brazil was looking for upgrading their SAP and Oracle environment, but, after considering IBM as a player, went throughout deep analyses and decided for full winback solution, migrating their SAP Oracle and SUN platform to IBM System z and DB2 z/OS.
    Speaker: Paulo Ribeiro, COPASA, Senior IT Specialist
  • -IDZ-3511A DB2 for z/OS and Profiles: Granular Parameters and More
    What are DB2 Profiles? Introduced in DB2 9 for z/OS and extended in DB2 10 for z/OS, Profiles provide a variety of exciting capabilities: ZPARMs at a more granular level than the subsystem, modeling production in test, and application specific behavior all available by means of online changes.
    Speaker: Mark Rader, IBM, Certified I/T Specialist
  • -IDZ-3640A Big Data Strategies with DB2 for z/OS
    IBM DB2 for z/OS holds massive amounts of data and has become pivotal to the success of big data projects so data warehouses and analytics rely on much of this data. But other forms of information and new analytics are an essential part of the decision making process. The System z platform with its OLTP, analytics and accelerators make it the logical place to start your successful big data projects. Attend this session and learn how the combination of DB2 or z/OS and InfoSphere BigInsights are helping to further lower risks and costs for businesses a great entry point for your big data initiatives - as well as real life examples of organizations using DB2 for z/OS and the Information management portfolio
    Speaker: Mark Simmonds, IBM, IBM Enterprise Architect and Senior Product Marketing Manager; Harry Batten, IBM, IBM System z Data Serving Strategy Manager

General sessions

  • -IDZ-1476A DB2 for z/OS Trends & Direction and Technical Overview
    IBM DB2 Version 11 is the latest release of DB2 for z/OS. This release addresses many key customer requirements, and this session will review the key features. It will also present the latest news on DB2 10 and future development trends.
    Speaker: Jeff Josten, IBM, DB2 for z/OS Architect; Joachim Limburg, IBM, DB2 for z/OS Development Director
  • -IDZ-1544A Exploiting DB2 11 for z/OS - Where do we start?
    Every new release of IBM DB2 for IBM z/OS has a wealth of new features and functions. This presentation will filter through the long list of exciting new features in DB2 Version 11 and provide details on those features that you should consider first as you begin planning on the exploitation of this newest version of DB2 for z/OS. Our focus will be on those features that deliver big returns for the broadest functional areas. We'll cover topics including: Performance improvements, improving efficiency, reducing costs, no application changes, continuous availability features, improved autonomics (which reduces costs and improves availability), enhanced business analytics and simpler, faster DB2 version upgrades.
    Speaker: Randy Ebersole, IBM, DB2 z/OS Technical Specialist
  • -IDZ-1651A Archive Transparency Support of DB2 11 for z/OS
    In database system, querying and managing tables that contain a large amount of data is a common problem. The cost and performance of large table are the key customer pain points. One known solution is to archive the cold data to a different table. However, there are also many challenges on the ease of use and performance. The new archive transparency support in DB2 11 provides cost effective archiving of warm and cold data with easy access to both within a single query, which give developers an efficient and user friendly interface to manage data with different temperatures. Through this presentation you will learn how these new features can improve performance and change your operational database and data warehousing designs.
    Speaker: Xiaohong Fu, IBM, Software Development; Steve Chen, IBM, DB2 z/OS architect, STSM
  • -IDZ-1817A IBM DB2 for z/OS Migration - Query Performance Considerations
    The IBM DB2 for z/OS Optimizer is continually evolving with each release, and for static SQL, REBIND is recommended to take advantage of new optimizations. But how do you minimize your exposure to access path regression for static SQL? And then there are the RUNSTATS enhancements that came in DB2 9 and then in DB2 10. Can you model the potential impact before you get to production? This presentation outlines how best to navigate and exploit these RUNSTATS enhancements, to make the most of plan management and do proactive access path analysis. Whether you are migrating from DB2 V8 9 or to DB2 10, you will come away with practical tips for a more effective migration that makes full use of incremental query optimization enhancements.
    Speaker: Terence Purcell, IBM, Senior Technical Staff Member; John Campbell, IBM, IBM Distinguished Engineer
  • -IDZ-1817B IBM DB2 for z/OS Migration - Query Performance Considerations
    The IBM DB2 for z/OS Optimizer is continually evolving with each release, and for static SQL, REBIND is recommended to take advantage of new optimizations. But how do you minimize your exposure to access path regression for static SQL? And then there are the RUNSTATS enhancements that came in DB2 9 and then in DB2 10. Can you model the potential impact before you get to production? This presentation outlines how best to navigate and exploit these RUNSTATS enhancements, to make the most of plan management and do proactive access path analysis. Whether you are migrating from DB2 V8 9 or to DB2 10, you will come away with practical tips for a more effective migration that makes full use of incremental query optimization enhancements.
    Speaker: Terence Purcell, IBM, Senior Technical Staff Member; John Campbell, IBM, IBM Distinguished Engineer
  • -IDZ-2594A DB2 and System z Synergy
    Most software is written to run on multiple platforms. While that reduces the costs and increases the reach of the software, it also means that the software doesn't exploit any of the platforms it runs on. But IBM DB2, z/OS, and System z are different. Together, they represent the consummate integrated computing platform. Learn what has been happening lately ? and what will be happening in the future ? that will continue this trend.
    Speaker: Christopher Crone, IBM, IBM Distinguished Engineer
  • -IDZ-3392A System z: Ask the Technical Experts
    This is your opportunity to ask all your burning IBM System z questions to our leading Technical experts from IM, WebSphere, Rational, Tivoli, Security, and the hardware team gathered into one panel for your edification and knowledge.
    Speaker: Betty Patterson, IBM, Distinguished Engineer

Migration/upgrade sessions

  • -IDZ-1196A Eenie Meenie Miney Mo, With Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS?
    Choosing the correct DB2 table (Space) type is very confusing. Should I go with a segmented table space, a UTS (if so, a PBG or PBR), HASH, or maybe good old classic partitioned? How about the page size? I now have a choice of 4K, 8K, 16K, or 32K for my table space and/or index. Should I choose a multi or single table option? Should I compress the object? Choosing the data's correct type and size the first time is essential to avoid costly outages. Come learn about best practices in choosing the correct types and settings for your data.
    Speaker: John Iczkovits, IBM, Senior IT Specialist
  • -IDZ-1202A An Extensive IBM DB2 Health Check: What Will the Specialist Prescribe for You?
    If you are concerned about your IBM DB2 environment or maybe just want to validate your environment, you might be thinking about an extensive IBM ATS DB2 Health Check. In this session, you learn what happens in a DB2 Health Check and the type of results you get. You learn how management has reacted to the final analysis and how you and your company can benefit from the analysis. You will leave this session understanding why the ATS DB2 Health Check is among the best in the industry.
    Speaker: John Iczkovits, IBM, Senior IT Specialist
  • -IDZ-1213A How Republic of Turkey Social Security Jumped from DB2 8 to DB2 10
    This session describes the story of a skip migration for Republic of Turkey Social Security Institution with best practices from bottom to top. You follow the institution’s process step by step for a V8 to V10 migration. You learn how the project started, the critical factors, the pitfalls and challenges. You also see numbers and metrics that show the benefits of the migration
    Speaker: Cuneyt Goksu, VBT, DB2 SME; Surekha Parekh, IBM, Program Director, DB2 for z/OS
  • -IDZ-1660A DB2 10 for z/OS Data Sharing: New Features and Member Consolidation Considerations
    This presentation will look at the new features of IBM DB2 10 for data sharing. It will also discuss what features in DB2 10 allows us to be open for consolidating members in the data sharing group, how we would go about doing such a consolidation, as well as implications for doing so.
    Speaker: Susan Lawson, YLA, Consultant
  • -IDZ-1741A Fast Track to Optimal DB2 Performance
    Tuning the IBM DB2 application to achieve optimal performance does not need to be a complex exercise. A large majority of problems can be easily solved and the only challenge is connecting the problem symptom with its underlying causes. This presentation offers you a simple methodology to answer the challenge. It starts by offering a straightforward way to identify activities in which problem transaction proceeds and follows by concrete, targeted corrective actions. Numerous ready-to-use hints and tips are included to maximize the presentation's practical value.
    Speaker: Namik Hrle, IBM, IBM Distinguished Engineer
  • -IDZ-1972A DB2 11 for z/OS: Early Customer Experience
    State Farm Insurance participated in the DB2 11 for z/OS early support program (ESP) and gained early experience working with the new version of DB2. DB2 11 For z/OS includes new features such as Drop Column, Crossloader Support for XML, XML Update Enhancements, and many other features. This presentation takes you through our experience with installing, cloning, migrating, bench marking and verifying DB2 V11 at State Farm.
    Speaker: Darrin Leverson, State Farm Insurance, Database Systems Administrator; Kevin Harrison, IBM, Senior Software Engineer
  • -IDZ-2021A Demystifying Online IBM DB2 for z/OS Migration
    Increasingly, customers must keep their applications online and available all hours of every day. Fortunately, the IBM DB2 migration process has been designed specifically to allow the business application set to continue to run while we migrate. Some customers have perfected online migrations in their environment while others have performed an online migration without realizing that their migration was online. Still others insist that the only way to ensure a successful migration is to take a full application outage. We will discuss exactly what the migration process does. Along the way we'll talk about the factors that affect a successful migration online and how to go about mitigating any interference with an online migration.
    Speaker: Jay Yothers, IBM, STSM/DB2 for z/OS Architect
  • -IDZ-2021B Demystifying Online IBM DB2 for z/OS Migration
    Increasingly, customers must keep their applications online and available all hours of every day. Fortunately, the IBM DB2 migration process has been designed specifically to allow the business application set to continue to run while we migrate. Some customers have perfected online migrations in their environment while others have performed an online migration without realizing that their migration was online. Still others insist that the only way to ensure a successful migration is to take a full application outage. We will discuss exactly what the migration process does. Along the way we'll talk about the factors that affect a successful migration online and how to go about mitigating any interference with an online migration.
    Speaker: Jay Yothers, IBM, STSM/DB2 for z/OS Architect
  • -IDZ-2043A Migrating to IBM DB2 11 for z/OS
    This presentation will discuss migrating to V11 of DB2 for z/OS from both V10 of DB2. We will discuss the migration process and what happens when you migrate, and also discuss why some of these changes are necessary. We'll also talk about how to prepare for V11, including prerequisites and deprecated functions. Finally we'll cover what you can expect from the various modes of operation during migration. The primary focus of the content of this session is on the person or persons who plan, install, and execute the migration process typically, systems programmers and database administrators.
    Speaker: Jay Yothers, IBM, STSM/DB2 for z/OS Architect
  • -IDZ-2043B Migrating to IBM DB2 11 for z/OS
    This presentation will discuss migrating to V11 of DB2 for z/OS from both V10 of DB2. We will discuss the migration process and what happens when you migrate, and also discuss why some of these changes are necessary. We'll also talk about how to prepare for V11, including prerequisites and deprecated functions. Finally we'll cover what you can expect from the various modes of operation during migration. The primary focus of the content of this session is on the person or persons who plan, install, and execute the migration process typically, systems programmers and database administrators.
    Speaker: Jay Yothers, IBM, STSM/DB2 for z/OS Architect
  • -IDZ-3757A Improve the quality and efficiency of your DB2 for z/OS migrations with the right tools and best practices
    Significantly improve your DB2 for z/OS version to version migration experience by reducing the amount of effort required and improving the quality of the migration overall. Learn how to leverage the DB2 Cloning Tool for z/OS to easily create cloned DB2 migration test systems, and then learn how InfoSphere Query Capture and Replay for DB2 for z/OS helps you build a better benchmark to validate application behavior and performance before and after the migration. Also, learn how to find key problems earlier in the test cycle using realistic testing and significantly reduce your worries of last minute surprises in production. We will cover experiences from the DB2 11 Beta Program.
    Speaker: Skyla Loomis, IBM, Program Director, Optim Tools Development; Reggie Culpepper, Rocket Software, Product Specialist
  • -IDZ-3766A Early Customer Experiences with DB2 11 for z/OS
    This session will highlight experiences from the IBM DB2 11 for z/OS beta program.
    Speaker: Terrie Jacopi, IBM, DB2 for z/OS Product Management Director

Performance/scalability sessions

  • -IDZ-1044A Avoiding IBM DB2 Performance Problem Management Records
    Root cause analysis of presumed or actual IBM DB2 performance issues can be difficult in today's diverse environments. Everything from CEC capacity, LPAR utilization, real or virtual storage, Workload Manager (WLM) settings, PARMLIB members, and DB2 parameters can play a part in performance degradation. But are there tools that can quickly guide you in the direction of the root cause? Many person hours have been wasted studying the effects of a system slowdown instead of the root cause. This session goes through the tools and methodologies to help you narrow down the source of the problem on your system so that you can take action or engage the necessary resources to eliminate the issue.
    Speaker: Adrian Burke, IBM, DB2 SWAT team
  • -IDZ-1147A A Whole Yotta IBM DB2 Log
    The essential feature in IBM DB2 11 is extending the log relative byte address (RBA) to 10 bytes. More users are exhausting the 6-byte RBA, some in 2 months. Other users approach the limit more quickly, requiring manual recovery actions to reset the RBA to zeros. Without data sharing, DB2 goes down for a multiday outage, while every RBA in every DB2 object is reset to zero. For data sharing, the 6-byte log record sequence number (LRSN) can cause a DB2 member to ""spin,"" to guarantee unique updates, and burn an extra processor. Increasing both settings allows logging up to 1 yottabyte. Conversion to the new log involves changing the format of DB2 pages. In this session, you learn how users in DB2 11 can convert nondisruptively and over time."
    Speaker: Judy Ruby-Brown, IBM, Executive I/T Specialist
  • -IDZ-1268A The Present and Future of Large Memory in IBM DB2
    With the flattening of Moore's Law, processor speeds will not serve as a significant source of performance improvement in coming years. Database systems are looking to use large real memory to avoid I/O latency and processor overhead. IBM DB2 10 and future releases of DB2 are looking to use large real memories and IBM z/OS features, such as large page sizes and flash memory. This session highlights the potential performance benefits of large real memories and how the DB2 development team plans to exploit such opportunities.
    Speaker: John Tobler, IBM, Senior Technical Staff Member;Michael Schultz, IBM, Software Engineer
  • -IDZ-1270A What Happened to My IBM DB2 Server? The Top Missteps in High Availability
    IBM DB2 and IBM z/OS provide unmatched availability to meet the demands of enterprise applications. When properly configured, DB2 can meet even the most stringent 24x7 availability requirements. This session covers the key configurations and features that are needed to achieve high availability. Real-world examples are provided that illustrate potential pitfalls. This session addresses such areas as specialty engine configuration, Workload Manager definitions, extended common service area (ECSA) management and real storage control.
    Speaker: John Tobler, IBM, Senior Technical Staff Member; Nigel Slinger, IBM, IBM Distinguished Engineer
  • -IDZ-1622B How to Design For High Volume Concurrent Insert
    This session is designed to introduce and discuss the most common use cases for high volume concurrent insert, share the associated IBM benchmark results, and provide recommended best practices in term of physical database design and tuning advice. The uses cases are: random insert and delete, insert at the end with and without append option, ""MEMBER CLUSTER (MC00),"" and insert with sequential key (such as timestamp).
    Speaker: John Campbell, IBM, IBM Distinguished Engineer;Ping Laing, IBM China , DB2 for z/OS Performance
  • -IDZ-1760A Exploiting DB2 for z/OS CPU-Saving Technology
    It's a fact that every new release of IBM DB2 for z/OS provides multiple new capabilities that you can use to boost system and application performance. However, at many sites, the performance-enhancing features delivered in recent DB2 releases are not being fully exploited. That's leaving MIPS on the table. In this session, attendees will learn how they can put performance-tuning technology introduced in the last three releases of DB2 for z/OS -- Versions 8, 9 and 10 -- to work for their organizations. Topics covered will include buffer pool tuning techniques, dynamic statement caching, table-controlled range partitioning, index INCLUDE columns, hash-organized tables, index-on-expression, and high-performance DBATs.
    Speaker: Robert Catterall, IBM, Consulting DB2 Specialist
  • -IDZ-1760B Exploiting DB2 for z/OS CPU-Saving Technology
    It's a fact that every new release of IBM DB2 for z/OS provides multiple new capabilities that you can use to boost system and application performance. However, at many sites, the performance-enhancing features delivered in recent DB2 releases are not being fully exploited. That's leaving MIPS on the table. In this session, attendees will learn how they can put performance-tuning technology introduced in the last three releases of DB2 for z/OS -- Versions 8, 9 and 10 -- to work for their organizations. Topics covered will include buffer pool tuning techniques, dynamic statement caching, table-controlled range partitioning, index INCLUDE columns, hash-organized tables, index-on-expression, and high-performance DBATs.
    Speaker: Robert Catterall, IBM, Consulting DB2 Specialist
  • -IDZ-1790A Reduce Costs by Tuning DB2 to Reduce Your Rolling Four-Hour Average
    Variable workload licensing can be a powerful mechanism to reduce your mainframe software costs. But are you taking full advantage of the opportunities that exist to lower your monthly software bill? Do you know how the rolling four hour (R4H) average impacts your bill and what you can do to lower that average?
    Speaker: Craig Mullins, MULLINS CONSULTING INC, President & Principal Consultant
  • -IDZ-1813A What's New from the Optimizer in DB2 11 for z/OS?
    Learn what is new from the optimizer to improve query performance in IBM DB2 11 for z/OS.
    Speaker: Terence Purcell, IBM, Senior Technical Staff Member
  • -IDZ-2024A IBM DB2 11 for z/OS Performance
    Come to hear the exciting performance improvement from IBM DB2 11 for z/OS. As with DB2 10, DB2 11 development has been focusing on performance. The DB2 performance team in Silicon Valley Lab will discuss how various performance items benefit both system and query performance and share the promising preliminary performance results with DB2 11. The session will set the right expectation for your DB2 11 migration plan. The session will include various internal measurements as well as the early support program (ESP) customer’s experience.
    Speaker: Akiko Hoshikawa, IBM , STSM, DB2 performance ;Brian Baggett, IBM, Senior Software Engineer
  • -IDZ-2398B Buffer Pools and Group Buffer Pools Enhancements in IBM DB2 10 and 11
    IBM DB2 Buffer Pools and Group Buffer Pools play a key role in DB2 performance. This presentation will cover Buffer Pools and Group Buffer Pools enhancements in DB2 10 and 11. You will learn the design trade-off of using new tuning parameters for Buffer Pools and Group Buffer Pools to maximize DB2 performance.
    Speaker: James Teng, IBM , Distinguished Engineer
  • -IDZ-2508A Continuous Availability and Scalability with DB2 for z/OS and Websphere
    Mission critical applications are deployed on Websphere accessing DB2 z/OS Data Sharing Group. High Availability (HA) features and tuning knobs at each layer in this multi-tiered environment are meant to complement each other, but customers find it difficult to achieve end-to-end optimal configurations - leading to unplanned application outages that could have been easily avoided. In this session, we will bridge the gaps from the application to the database through deep dive on tight integration of HA technologies of DB2 and WAS. Topics drawn from customer engagements in different industries will include best practices, real experiences, typical pain-points and latest HA features.
    Speaker: Pallavi Priyadarshini, IBM, Tehnical Manager, DB2 Connect;Maryela Weihrauch, IBM, Distinguished Engineer
  • -IDZ-2972A Partitioning and Indexing - Query Performance Considerations
    When is a partitioned index considered a PI as opposed to a DPSI (data partitioned secondary index)? When can I use DPSIs? Knowing the answers to these questions can help you to identify how to choose partitioning columns to balance data maintenance and query performance. This presentation will outline how the IBM DB2 optimizer processes these indexes, and what has been delivered in DB2 11 for z/OS to improve query performance for indexes on partitioned table spaces.
    Speaker: Brian Baggett, IBM, Senior Software Engineer;Terence Purcell, IBM, Senior Technical Staff Member
  • -IDZ-3270B Exciting New SQL PL and SQL Features of DB2 11 for z/OS
    IBM DB2 11 for z/OS Early Support Program has been announced. This is your opportunity to hear about the new SQL PL (SQL Procedural Language) features for native SQL procedures. Simplify your application logic by learning about the new SQL being introduced in DB2 11. Specific examples will be presented to help you implement the new features right away. Due to IBM confidentially agreement this is not the full detailed abstract, which will be discussed with Surekha Parekh, IBM IOD liaison.
    Speaker: Maryela Weihrauch, IBM, Distinguished Engineer;Meg Bernal, IBM, Senior Software Engineer
  • -IDZ-3270C Exciting New SQL PL and SQL Features of DB2 11 for z/OS
    IBM DB2 11 for z/OS Early Support Program has been announced. This is your opportunity to hear about the new SQL PL (SQL Procedural Language) features for native SQL procedures. Simplify your application logic by learning about the new SQL being introduced in DB2 11. Specific examples will be presented to help you implement the new features right away. Due to IBM confidentially agreement this is not the full detailed abstract, which will be discussed with Surekha Parekh, IBM IOD liaison.
    Speaker: Maryela Weihrauch, IBM, Distinguished Engineer;Meg Bernal, IBM, Senior Software Engineer
  • -IDZ-3409A DB2 10 for z/OS Performance Measurement at Wells Fargo
    Wells Fargo has a number of production DB2 data-sharing groups migrated to IBM DB2 10 for z/OS this year. This presentation will explore the general Wells Fargo DB2 environment, then DB2 10 migration schedule and sequence. It will also cover the migration process and result. The session will emphasize the before and after comparison between the data sharing groups, with a discussion of what measurements are used and how they are used. DB2 accounting and statistics data is summarized for the comparisons for each group.
    Speaker: James Collins, Wells Fargo , Operating Systems Engineer;Akiko Hoshikawa, IBM , STSM, DB2 performance
  • -IDZ-3497A IBM DB2 for z/OS Data Sharing Technical Review
    DB2 Data Sharing relies on the Lock Structure and Group Buffer Pools. Come learn what they do and how to monitor their behavior. This session also addresses how your infrastructure changes as your workload grows, and what options are available to facilitate these changes.
    Speaker: Mark Rader, IBM, Certified I/T Specialist;Surekha Parekh, IBM, Program Director, DB2 for z/OS
  • -IDZ-3735A Next Generation DB2, Getting modernized to run continuously!
    Publically traded companies strive to raise stockholder confidence and awareness to the bottom line. Goals need to exist across the business portfolio with Information Technology leading the way to achieve increased business reliance and profit.Achieve continuous availability for the data server environment by adopting the best that z/OS Sysplex and data sharing have to offer through exploitation of hardware, software and process. You will learn how FedEx is reducing our complexity and variation of the mainframe investment, optimizing the latest hardware adoption strategies, while building the ultimate continuous availably data server platform to drive increased profits from mainframe architecture.
    Speaker: Rob Crane, Fedex, Database Architect;Jim Reed, IBM, Program Director
  • -IDZ-3736A I Didn't Know DB2 Did THAT!
    This session is full of interesting facts about wonderful things that DB2 does internally for us. It covers how DB2 works, as well as little-known facts that you can use to help DB2 work better. The session covers facts such as what a latch is and how latch suspensions can happen a) when trying to load a package into the EDMPOOL, b) during a GET PAGE request, and c) prior to the Data Manager addressing a page. Also covered are the mystery of SIX locks; how newly INSERTed rows get into CURSOR result sets and how to avoid this issue gracefully; and unusual uses for static and dynamic scrollable cursors (other than scrolling).
    Speaker: Bonnie Baker, Bonnie Baker Inc, President
  • -IDZ-3756A SQL Cost Optimization from the Ground Up
    Sheryl will present discoveries and recommendations from very recent SQL performance review assignments. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues discussed include outrageous misuse of SQL, useless index design, access paths gone wild, Stage 2 predicates, excessive sorting, extreme delayed filtering, and lack of implementation of powerful SQL features! Objective 1: Show remedies for expensive SQL never seen before in Sheryl’s career Objective 2: Show remedies for poor index design lacking filtering, sequencing & selecting columns Objective 3: Discover access paths so wild they are nearly impossible to decipher
    Speaker: Sheryl Larsen, IBM, Technical Solution Architect
 

2 of 6 pages | Previous | Next

 

Register now

RedMonk session

RedMonk session

RedMonk analyst Stephen O’Grady and Dan Wardman, IBM Vice President, lead a discussion on the benefits of big data and analytics on the System z platform.

See Featured Session
IDW-3357A

Experts panel

Experts panel

Ask the System z Experts: System z software technical experts answer your questions.

Client session

FedEx

Learn how FedEx builds investor confidence by optimizing its mainframe environment for continuous availability.

See Featured Session
IDZ-3735A