DateAbstractDownload
Presentation
12/05/2018Session #1:Memory for MIPS:Leveraging Big Memory to Boost Db2 for z/OS CPU Efficiency
In this session you’ll get information on how to use real storage to reduce Db2-related CPU consumption by
1) getting your buffer pool house in order (i.e., getting the most out of your buffer pool configuration without making it larger),
2) being bold – but not reckless – in asking for more memory for Db2 buffer pools to reduce I/O activity, and
3) using real storage for threads, packages, dynamic SQL, RID processing, sparse indexes and SQL sorting in a CPU-savvy way
12/05/2018Session #2:The Learning Optimizer: an Overview of IBM Db2 AI for z/OS
The brand-new IBM Db2 AI for z/OS is going to fundamentally change the access path selection story in a positive way. This session will provide an overview of what IBM Db2 AI for z/OS is, how it does what it does, and its potential to substantially improve query execution performance in diverse Db2 for z/OS environments.
12/05/2018Session #3:Attracting Developers & DB2 V11.1.4.4 updates
In this session will cover
1) The latest updates, fixes and new features in the V11.1.4.4 release of Db2.
2) Attracting Developers to Db2: Strategy, Progerss and Future

12/05/2018Session #4:The Db2 Common SQL Engine Appliance – Sailfish
This session covers Db2 RESTfull Access uisng Open Data Protocol (OData) with Db2 data sources
08/08/2018Session #1: Advanced Query Tuning with IBM Data Studio
• Know how to use Data Studio to help improve query performance
• Know the different access paths and understand how they are presented
• Understand filter factors
• Better understand how the DB2 optimizer determines access paths
• Better understand how to use and navigate Data Studio for SQL tuning
• SQL Performance and Tuning Tips for Developers:
• Learn some the top performance and tuning tips every developer should know
• Learn the top 10 steps developers should take when working on a performance problem

08/08/2018Session #2: z/OS: Access Path Stability on Db2 for z/OS – Best Practices
• Understand the history of plan management
• Plan management rebind options
• Db2 catalog support
• Rebind access path compares
• Rebind access path reuse
08/08/2018Session #3 – IBM BIGSQL
DB2 features that make it easy to store NoSQL data with the versatility you need and the security and performance you expect from Db2.
08/08/2018Session #4 – IBM Cloud Private, Container and Data Science Experience (DSX)
Introduction to IBM Cloud Private for Data: This will be an introduction to ICPD, a modern integrated data and analytics platform behind your firewall used to can Collect, Organize and Analyze data.

04/04/2018LUW-Hybrid Data Management Strategy
• Data Analytics in public and private cloud
04/04/2018LUW-Developing modern Application with DB2
• JASON
• Docker Container
• Open Data Protocol Gateway
04/04/2018ZOS- Guilty until proven innocent
This is a presentation on using accounting traces to identify performance related outages
04/04/2018ZOS- Mass Db2 Application Recovery
• The Nightmare of a Db2 Professional
08/17/2016DB2 12 Sneak Preview – TRIDUG
• Introduction
• Performance focus – traditional workloads
• Performance focus – enabling modern applications
• Application enablement
• Reliablity, availability, scalability, security
• Migration
08/17/2016Overview of IBM database Servers
• Introduction
• Databases for OLTP
• DB2 LUW for OLTP
• DB2 on Cloud
• dashDBfor Transactions
• Cloudant
• Informix
• Compose
• Databases for Analytics
• DB2 LUW for Analytics
• PureDataSystem for Analytics
• dashDBfor Analytics & dashDBLocal
• Strategy and Competition
04/13/2016Real-Time Analytics on IBM z Systems
• Trends in Analytics, Infrastructure Demands and Evolution of the IBM z System
• Predictive Analytics – Improve Quality & Timeliness of Decisions
• Traditional Analytics & Associated Issues
• Best Practice – Take Analytics to the Data; Reduce Data Movement
• The Best Real-Time Analytics Environment (Hybrid Transaction and Analytics Platform – HTAP)
• The Real Time Analytics (RTA) Process: Scoring and Business Rules for Fraud Detection and
other use cases
• RTA on IBM z System – Value Proposition
04/13/2016DB2 Security: From the Data Center to theCloud
DB2 uses the following mechanisms to secure data:
• Authentication
• Authorities and Privileges
• Trusted Contexts and Trusted Connections
• Row and Column Access Control (RCAC)
• Label-Based Access Control (LBAC)
• Native Encryption
04/13/2016DB2 Analytics Accelerator
A workload optimized, appliance add-on to DB2 for z/OS that enables the integration of analytic insights into operational processes to drive business critical analytics & exceptional business value.
04/13/2016IBM Data Server Manager
Monitoring:
The capabilities of the Optim Performance Manager and new features are rolled into the new Data Server Manager
Tuning:
The capabilities of the Optim Query Workload Tuner and new features are rolled into the new Data Server Manager
Configuration:
The capabilities of the Optim Configuration Manager and new features are rolled into the new Data Server Manager
Administration:
The capabilities of the Data Studio and new features are rolled into the new Data Server Manager
12/09/2015Upgrading to DB2 with the Latest Version of BLU Acceleration
Are you responsible for upgrading your database to the latest version of DB2 with BLU Acceleration? Everyone is talking about in memory computing and columnar databases to improve analytic query performance. Take advantage of a columnar data store integrated into the core DB2 engine, which has huge benefits for business intelligence workloads. In addition to BLU, there is additional new DB2 functionality. If you need a detailed step by step approach to implement the newest version of DB2, come learn about often overlooked, but important best practices to understand before and after upgrading. Satisfy your increasing demands to analyze and gain insights into your business data.
12/09/2015DB2 for z/OS Distributed Data Facility Questions and Answers
The DB2 distributed data facility (DDF) is, increasingly, the primary channel through which DB2 for z/OS data is accessed. As DB2 people deal with the growing volume and variety of DDF workloads, associated questions come to the fore. How do you effectively monitor DDF activity? How should DDF-using applications be architected? How can a DDF workload be managed and controlled? How do I secure data accessed via DDF? This session will provide answers to these and related DDF questions — questions asked by real users in the real world.
12/09/2015Modern DB2 for z/OS Physical Database Design
DB2 for z/OS physical database design has changed with the introduction, via recent DB2 releases, of new options that DBAs can exploit to improve performance, availability, and security — without requiring application code changes. This session will provide information on leveraging features related to data partitioning, table space type, data organization, LOB management, data protection, index design, data archiving, and more.
12/09/2015Scaling Up DB2 Applications with Consistent Performance in a High Concurrency Environment
As you scale up your database size, controlling the execution of a highly concurrent DB2 workload is a must in order to achieve consistent performance. This presentation will introduce you to the key tips and techniques that enable you to effectively manage the ups and downs of an enterprise scale workload with the various DB2 database offerings and achieve the promised order of magnitude improvements
08/19/2015IBM Data Server Manager
IBM Data Server Manager is a simple, scalable, and smart solution to administer, monitor, manage, and optimize the performance of DB2 for Linux, UNIX and Windows databases across the enterprise. It is easy to deploy and manage to help tackle everyday database challenges. It provides database administrators (DBAs) and other IT staff with the information they need to manage performance proactively and help prevent problems before they impact the business. Plus, Data Server Manager is cloud-ready.

Data Server Manager offers a lightweight setup option for real-time monitoring and administration. The optional repository database can record monitoring metrics for historical analysis, identify storage access patterns for capacity planning, and track configuration changes for problem determination. Automated, expert advice from a holistic view of the database and intelligent alerts based on trends and statistics help optimize application performance, reduce the need for specialized skills and lower total cost of ownership.

08/19/2015DB2 10 and 11 for z/OS – Implementing and Using Autonomic Statistics
DB2 10 and 11 have a neat feature, automatically executing RUNSTATS on required objects. By the way, you get to choose when and how to execute RUNSTATS. The actual implementation however is not straight forward. Come to this presentation and learn how to successfully implement and review the output for this new feature.
08/19/2015DB2 11 for z/OS : Performance Topics
DB2 10 for z/OS delivered tremendous improvement that drove great value for IBM clients. DB2 11 for z/OS continues the trend by focusing on further CPU savings and performance improvement through innovations within DB2 and the synergy with System z hardware and software. Most of CPU reductions are built-in directly to DB2, requiring no application changes. Enhancements often take effect after the rebind in the case of static applications, while some enhancements require user actions such as DDL updates. DB2 11 CPU reduction can potentially provide significant total cost of ownership savings depending on the application mixture and type of transactions. In this session we will discuss some of the changes that are documented more fully in the IBM redbook SG24-8222 (by the same title), including IBM internal measurement.
08/19/2015DB2 Native Encryption
This session will cover DB2’s native encryption capabilities, including encryption design principles, key management capabilities, and encryption of backups. You will learn how to create an encrypted database, create a keystore, rotate keys, and create encrypted backups.
04/08/2015Building a Continuously Available System with DB2
Learn how to achieve near continuous availability with IBM DB2 for Linux, UNIX and Windows. In this session, the speaker examines the need for continuous availability in a database system, explains why people think they need continuous availability and then, describes what can really be done. In addition, the speaker provides tips and techniques to help you minimize any outage, delivering a near continuous availability system.
04/08/2015DB2 Backup and Restore Best Practices
This session will provide a brief overview of the recent enhancements in the area of backup and recovery. We will discuss different strategies available to backup database, and how to choose the appropriate strategy.
This will be followed by stepping through a real customer situation where backup was suffering a performance problem. A description of what approach was taken to determine where the bottleneck was, what tools were used and what recommendation was made to resolve the issue. We will end with some general guidelines that should be followed to develop a backup and recovery strategy.
04/08/2015From Virtually Constrained to Really Overcommitted
With the 31-bit virtual storage relief of DB2 10 customers no longer need to rely on the old ‘diet plan’. However the answer is not to simply open the gates for more threads to come in. Real storage usage and conservation becomes the next major bottleneck. Things like persistent thread, long running units of work, and parallelism can exacerbate the real storage usage. Understanding what to look for, and what functionality can affect your stance on real storage is key to staying ahead of the game. We will look at DB2, z/OS, and Sort product parameter settings, as well as general best practices to keep your systems running safely
04/08/2015Application-enabling features of DB2 10 and 11 for z/OS
The value of an organization’s data assets relate to the value of the applications that access the data. Data powers applications, and applications power organizational performance. In this topic, you will learn of recent DB2 for z/OS features which enable efficient and agile development of new applications. Topics to be covered include new analytics capabilities, temporal data enhancements, new SQL Procedure Language features, advances in large object management, enhanced XML support and integration with Hadoop-managed data.
12/04/2014DB2 11 Transparent Archiving – now you can purge
A very common requirement for any IT application is to archive old or less frequently accessed data. Regulatory restrictions may require data to be retained for many years, but access frequency tends to drop off dramatically as the data ages. Moving older data to a separate archive can reduce the cost of retrieving and maintaining more frequently used data, and allow slower but much cheaper storage devices to be used.
DB2 11 introduces a new feature to simplify application development for archiving data, as well as improve consistency between applications and reduce the amount of time required for testing. When defining the operational DB2 table, the DBA also defines an identical archive table and connects the two via an ALTER TABLE…ENABLE ARCHIVE statement. Once an archiving relationship has been defined, DB2 can automatically and transparently handle archiving and retrieval of data from the operation and archive tables.
This presentation provides additional detail and specifics on this new DB2 capability
12/04/2014Extended LRSN and RBA Support in DB2 11 for z/OS
The DB2 recovery log records and tracks changes made to DB2 objects and is critical for application and system restart and recovery. Prior to DB2 11, DB2 used a 6-byte log address which provide for the equivalent of 256 TB of total logging capacity. Many customers have experienced a relentless increase in transaction volumes and a growth in log record size due to use of DB2 features such as large objects (LOBs) and newer data types such as XML. Consolidation of DB2 workloads into a standalone DB2 or a smaller number of DB2 data sharing members has resulted in greater transaction volumes within each DB2 system leading to a higher rate of writing log records.
The net result is many customers are approaching the end of the DB2 log range making it necessary to reset the DB2 log RBA. Before DB2 11 resetting the log RBA requires extensive work and an extended outage. Datasharing customers process log records based on a 6-byte log record sequence number (LRSN) so there is a less disruptive option available to address this issue but even datasharing DB2s will confront this concern at some future date. DB2 11 addresses this concern by allowing for the expansion of both the log RBA and LRSN from 6 bytes to 10 bytes which provides much needed relief.
The presentation will deliver more detail on DB2 logging, the impact of the 6-byte log RBA issue and the steps required to extend log RBAs to 10 bytes in DB2 11.
12/04/2014DB2 10.5.0.4 the Cancun Release
The latest release of DB2 for LUW comes with quite a few new capabilities. Known as the “Cancun Release”, DB2 10.5.0.4 builds on the BLU Acceleration capabilities delivered in DB2 10.5 to allow clients to realize the same performance benefits of BLU for reporting and analytics but running directly in their transaction processing systems. The new Shadow Table capabilities has the potential to significantly simplify many reporting systems. Chris will explain what shadow tables are, how to use them, and how they are configured and managed. As well the 10.5.0.4 release also brings some significant enhancements to availability which will be covered in this session as well.
12/04/2014NoSQL – Is this the end of SQL?
There is a lot of buzz in the industry around NoSQL databases. Is this the end of SQL? Join Chris as he describes the NoSQL landscape, what the appeal is for developers and users of NoSQL and several popular use cases that surround all this buzz. Chris will also talk about what is happening inside of DB2 in the NoSQL space and what you should all know so that you not only understand what people in your company are talking about when it comes to NoSQL but how you can position DB2 in this new space.
06/18/2014What 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 24×7 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.
06/18/2014DB2 11 for z/OS Performance
This presentation with cover the many exciting performance improvements found in DB2 11 for z/OS. Similar to DB2 10, DB2 11 will deliver out-the-box performance improvement and cost savings. The various performance improvements available to benefit system and query performance will be shared along with performance perspectives gained during the lab testing and customers involved in the DB2 11 early support program. This session will allow you to have the right performance perspective and expectation as you embark on your DB2 migration planning.
06/18/2014Demystifying Logging & Recovery in DB2 for LUW
For many DBAs, how DB2 captures the changes to a database and can use that to recover from failures is a mystery. But with over 20% of the 100+ configurable database configuration parameters being related to logging and recovery, it’s important to understand how it all works and how you can be sure that you’re logging in an efficient matter and that you’re protected from various types of failures. Learn about logging strategies, how to properly configure the most important parameters (for feature and performance), and how to monitor the logging that is happening in your environment. Topics also include logging basics and concepts, mirrored logging, infinite logging, log archiving, types of recovery (crash recovery vs. roll forward), minimizing crash recovery time, and methods for limiting what gets logged.
06/18/2014DB2 LUW Advanced Recovery Tools Overview
This session will discuss the Advanced Recovery Tooling capability in DB2 LUW environments. Specifically, we will introduce High Performance Unload, Merge Backup and Recovery Expert and discuss how they can be used in various data management instances including data recovery scenarios. This session will impart a working knowledge, examine specific customer based use cases and include best practices.
02/04/2014At Your Service: Optimizing DB2 for z/OS for Client-Server Applications
At sites around the world, an ever-greater percentage of the DB2 for z/OS workload is related to client-server applications (i.e., applications that access DB2 data via DDF, the distributed data facility). This session will provide attendees with information that they can use to help ensure that DB2 is serving network-attached applications with optimal performance, scalability, availability, and security. There will be an emphasis on exploiting features delivered in the last few releases of DB2 for z/OS.
02/04/2014Going Native: Leveraging DB2 for z/OS SQL Procedures and UDFs
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to UDFs with DB2 10. DB2 11 has delivered additional SQL PL-related enhancements. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures and UDFs. It will also cover exploitation of native SQL procedures and UDFs to enhance DB2 for z/OS performance, scalability, and security – particularly for client-server applications.
02/04/2014DB2 PE Performance Database and Performance Warehouse for Dummies
There is a world of information that can be found in accounting, trace, and statistics data. DB2PE can produce daily reports that give us details at many levels. But if we want to track performance indicators over time, it can be difficult. With the use of the Performance Database and/or Performance Warehouse, we can store that information and report upon it, giving us a new, wider look at our performance data. We will look at the implementation and use of DB2PE for reporting and trend analysis.
02/04/2014Using the Multi-Temperature Data Feature with Fully Automated Storage Tiering
Storage groups, introduced in DB2 10.1 for LUW, provide for the logical grouping of paths on storage subsystems that have similar media attributes. And storage arrays like EMC’s Symmetrix VMAX can automatically relocate data across different performance/capacity tiers, based on data usage patterns. In this presentation, you will learn about both of these technologies and you will see how they can be used together to deliver optimum database performance.
02/04/2014This session covers the technology enchancements in DB2 10.5. Including blue excellaration, memory optimization and HADR enhancements.
12/10/2013DB2 11 for z/OS Overview
As of 10/25/13, DB2 11 for z/OS is not generally available. This new version of DB2 once again reduces CPU costs and provide new function in areas of availability, performance, security and productivity. This session provides an overview of DB2 11 features, performance measurements and migration considerations.
12/10/2013IBM DB2 Analytics Accelerator for z/OS
IBM DB2 Analytics Accelerator has drawn lots of attention from IBM DB2 for z/OS users. In many respects, DB2 Analytics Accelerator presents itself as just another IBM DB2 access path, but deep integration into DB2 and application transparency make it one of the most exciting DB2 enhancements in years. The accelerator complements DB2 by adding the industry-leading, data-intensive, complex query performance of the IBM Netezza engine. Analytics Accelerator transforms DB2 by delivering both transactional and analytical workloads. This presentation will cover how the accelerator works and new features available this year.
12/10/2013IBM DB2 Analytics Accelerator for z/OS
IBM DB2 Analytics Accelerator has drawn lots of attention from IBM DB2 for z/OS users. In many respects, DB2 Analytics Accelerator presents itself as just another IBM DB2 access path, but deep integration into DB2 and application transparency make it one of the most exciting DB2 enhancements in years. The accelerator complements DB2 by adding the industry-leading, data-intensive, complex query performance of the IBM Netezza engine. Analytics Accelerator transforms DB2 by delivering both transactional and analytical workloads. This presentation will cover how the accelerator works and new features available this year.
12/10/2013Using IBM Data Studio to Develop, Manage, and Tune DB2 for all Platforms – Part 1Tony will be discussing the latest version of Data Studio and showing how this powerful tool can be used to manage and tune DB2 database environments, as well as aid in application, function, and stored procedure development. His presentation will focus on Administration in the morning and Development in the afternoon.
12/10/2013Using IBM Data Studio to Develop, Manage, and Tune DB2 for all Platforms – Part 2
08/27/2013DB2 Row and Column Access ControlDB2 10.1 introduced Row and Column Access control, a new way of securing the rows that users can see. This session will introduce the new technology in DB2 and also contrast it to the existing Label-based access control (LBAC) that is found in prior versions of DB2.
08/27/2013Delivering real cost savings through DB2 utilities management (Craig Friske, IBM Silicon Valley Lab, Lead Developer – DB2 Utilities)• Using enhancements to minimize downtime associated with routine DB2 data maintenance• Responding to changing application needs, such as data warehousing or business analytics• Reducing elapsed time and CPU during utility processing• Support for complex data types such as XML or Large Objects (LOBs)
The IBM DB2 Utilities Suite is at the core of successfully managing any DB2 for z/OS database. Many significant new enhancements are available with the latest product enhancements that can relieve the burden of maintaining DB2 data. This presentation will cover DB2 Utilities Suite enhancements recently delivered via the maintenance stream to reduce CPU and improve availability. You’ll learn about new features that enable you to avoid running the utility altogether. During this topic, Craig will also take a look at DB2 10 enhancements that can help you get the most from your IBM DB2 Utilities investment.
08/27/2013Technology has changed dramatically over the last few years as vendors use different techniques, hardware, and software to improve query performance. DB2 has made changes over the years as well, bringing in new join techniques, better compression, improved statistics, and new SQL commands. But many of these changes gave customers incremental performance improvements, at the cost of additional administrative work and overhead. Attend this session to learn about DB2 10.5 with BLU Acceleration and how this may help dramatically change the way you approach query optimization and improve response times by an order of magnitude.
08/27/2013DB2 10 for z/OS has numerous new functions and performance features that you can take advantage of – both “out-of-the-box and some that require user actions. This session focuses on new functions that require user actions to implement, such as INCLUDE index, inline-LOB, HASH access to data, Dynamic Statement Caching, UTS enhancements, and many more. We’ll describe the expected benefit from these features, including core considerations and best practices to get the most out of DB2 10 performance functions. The session includes various measurements conducted at IBM’s Silicon Valley Labs, plus feedback from customer experiences.Download not available
12/07/2012DB2 LUW FAQ and pureScale PerformanceDownload not available
12/07/2012This session brings another installment of hints and tips, and – yes – gems of performance information, gathered from diligent lab work, and experience in the field. As always, we focus on the questions that are frequently asked – but not always easily answered. We’ll cover the performance aspects of some of the latest DB2 features, as well as demystify some long-standing issues that could be keeping you from getting the most out of your system. For example – what kind of performance impact does CPU and IO virtualization have? Is it really (really) necessary to put my transaction logs on a separate device? How do I find the longest-running transactions in my system? Will the statement concentrator really make all my package cache problems go away? What are the performance impacts of declared global temporary tables (DGTTs)? Automatic maintenance is great, but how much performance overhead does it add?Download not available
12/07/2012Monitoring tools and various DISPLAY commands make available to you a dizzying array of informational items pertaining to the performance of an IBM DB2 for z/OS subsystem and of applications that access DB2. You can wade through all that information or focus on the handful of metrics that will enable you to efficiently and effectively assess DB2 performance in your particular environment. Drawing on over 20 years of experience in analyzing and using information in monitor reports and displays, and in DB2 command output, I’ll describe in this two-part presentation the fields that contain the highest-value information and how to use it.Download not available
06/14/2012DB2 10.1 is the newest release of DB2 on the Linux, UNIX, and Windows operating platforms. This release has many new and exciting enhancements and features for both OLTP and decision-support workloads. This seminar will take you through some of these enhancements and features, including:New Adaptive Compression, resulting in over 70+% database compressions for many clients
Time-Travel Query allowing you to see your data as it is, as it was, and as it will be … great for historical reporting, auditing, and planning
Row and Column Access Control giving data-centric security and compliance on your sensitive dataStorage Temperature Data Management to better control position of data on high-performance devices>/li>New index, join, and scan techniques for improved query performance and maintenance
Additional Oracle-compatibility features for making moving your applications to DB2 easier than ever!
Enhancements to DB2 for LUW High Availability and Disaster Recovery (HADR).
Download not available
06/14/2012This session will explore some of the highlights of DB2 10, the most recent release of DB2 for z/OS, and will offer an overview of some of the technical features that are of the most interest, as well as review customer experiences. Some of the technology trends that are driving future development of DB2, will also be discussed and some thoughts about what might appear in DB2 Sequoia, the next release of DB2, will be shared.Download not available
03/23/2012This event will explore the IBM Data Studio tool, its capabilities and demonstrate how you can utilize it to achieve your company’s goals. It will show and highlight Data Studio’s functionality that can be exploited by Database Administrators as well as by Application Developers. It will include an update on what is new in version 3.1, including the additions of Optim Database Administrator and Optim Development Studio. It will also cover additional topics including SQL Tuning capabilities, Object and Change Management, Stored Procedure and Web Services development and testing, and Application Development integration.Download not available
03/23/2012Label-based access control (LBAC) is a security feature that uses one or more security labels to control who has read access and who has write access to individual rows and/or columns in a table. This presentation is designed to introduce you to LBAC and to walk you through the process used to set up LBAC protection on a table. Both row-level and column-level security will be addressed; LBAC rules and rule exemptions will be covered as well.Download not available