This one-stop webcast channel makes it fast and easy to build and extend your technical skills on the IBM DB2 product family.  IDUG has joined forces with IBM to bring together a wide array of learning sessions on technical product features, related products, new product developments and more.

TEST - Integration Registration Test

Need to get started using DB2 quickly and at a low cost? Need BI and Data warehousing in-memory computing fast? 

This webcast will explain two different IBM cloud solutions that can help get you up and running quickly and cost-effectively:

DB2 on the Cloud is available in several pre-installed, pre-configured editions of DB2 to support needs that range from a small workgroup to advanced enterprise data applications. These environments can meet a variety of needs including development, test, online transaction processing and more. 

BLU Acceleration for Cloud, recently released as a public technology preview, is designed to provide self-service BI or data warehousing in a simple agile cloud-based in-memory computing solution. It includes an option to use BLU Acceleration with Cognos BI so that you can get insights from your data very quickly and affordably. 

Attend this Tech Talk to learn more about these exciting cloud implementations and how they can work to provide data insights at the speed of business.

Use DB2 on the Cloud or BLU Acceleration on the Cloud

Rapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (Java™ Script Object Notation) has proven to be a key technology for mobile, interactive applications because it reduces overhead for schema designs and eliminates data transformation needs. 

New DB2 JSON capabilities enable developers to use the JSON-oriented query language, created by MongoDB, to interact with data stored in IBM DB2 for Linux, UNIX, and Windows databases. 

This driver-based solution embraces flexible JSON data representation within a proven, reliable enterprise-class relational database. The DB2 JSON capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. 

Learn about all of these DB2 JSON features and how you can leverage them to deliver data to your next-generation of applications.

DB2 Tech Talk: Build Next-Gen Applications with DB2 JSON Capabilities

There are three sections of this presentation, each of which focus on DBAs, Developers, and Managers. There are far more than 10 things you need to know. However, these are the things that should be the most important to know first. The presentation is in reference to DB2 for z/OS but most everything presented can apply to both DB2 for z/OS and DB2 for LUW.

IDUG Tech Talk: Top Ten Things Your Need to Know, DBAs, Developers, and Managers

David gives us a walk-through on the setup of WLM to manage the CPU capacity for two separate applications in a single DB2 for LUW database. You'll learn how to dedicate a fixed percentage of CPU, ensure predictable performance and resource utilization, and

IDUG Tech Talk: "Sandboxing" Workloads using the WLM Dispatcher for Consolidated

Everyone is talking about in-memory computing and columnar databases to improve analytic query performance. What makes BLU Acceleration different and unique?  Learn the advantages of BLU Acceleration compared to other vendors offerings in the market.  Chris will cover Oracle, Microsoft, Teradata, Vertica, SAP HANA and other vendors to describe what they have and what they don't have compared to BLU Acceleration. 

Join Chris for this fact-based discussion that will provide a true comparison of the vendor solutions beyond the hype.

DB2 Tech Talk:  BLU Acceleration Competitive Advantages for In-memory Computing

In this presentation Melanie delivers solid information about advanced performance analysis and tuning of DB2 utilities. She also provides a significant number of tips and tricks to get your utilities humming. Utility problem determination is also covered. Melanie is one of the premier authorities on DB2 for LUW tuning, and so this is a "must view" presentation.

IDUG Tech Talk: DB2 LUW Advanced Utilities Problem Determination Tips and Tricks

SQL is an essential aspect of most data applications in production today.  DBAs and Database developers must be in tune with the current state of the technology to help make the most of your organization's data applications.  

In this Tech Talk,  Rick Swagerman will be hosting and presenting.  Rick is the DB2 for LINUX, UNIX and Windows Language Architect, and will discuss the latest aspects of SQL in DB2, the SQL standard and more:

- Learn about new SQL advances in DB2 10.5, such as expression-based indexes, extended row size, pipelined table functions, weak types and type constraints

- Understand what's new with the overall SQL standard

- Find out about the IBM SQL Language Council and how it defines new SQL and helps you know about SQL compatibility

- Pick up some tips and techniques in applying the SQL in DB2 to your applications

Join us for this tech Talk to advance your understanding of SQL as it relates to DB2 10.5.

DB2 Tech Talk: SQL Refresher on DB2 10.5, SQL Standard Update and More

Terry Purcell of IBM SVL Optimization Team gives his IDUG presentation introducing you to the enhancements his team made to the optimizer for DB2 10 for z/OS. Details are giving and examples of where each new optimization technique can and will be applied.

IDUG Tech Talk: DB2 10 for z/OS Optimization Enhancements

DB2 BLU Accelerationis an in-memory computing technology that is designed to handle data-intensive analytic workloads. It extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the available memory.

BLU Acceleration introduces a new column organization for table storage along with parallel data analysis and added compression. 
Learn about the use InfoSphere Optim tooling to allow for faster and easier adoption of BLU Acceleration:
- Monitor the system performance before the adoption
- Capture of the workload on the pre-adoption DB2 system
- Recommend which tables are the best candidates to convert to columnar organization and obtain estimates on how much improvement you can expect
- Automatically apply the conversion to adopt the new technology
- Re-monitor and validate the results after conversion.

This webcast will demonstrate an end-to-end scenario of how the tools can be used to make the adoption of BLU Acceleration technology faster and easier.

DB2 Tech Talk: Adopt BLU Acceleration in DB2 10.5 the Faster Easier Way

Get a brief JSON technology overview in this Tech Bit.  Presenter Bill Bireley is a Java / JSON technology expert from IBM labs and he overviews this new technology.  Bill also describes the JSON technology preview available on IBM developerWorks so you can try it.

DB2 Tech Bit: JSON Technology Brief

IBM has taken query tuning to a new level with IBM Data Studio. More detail is available than ever before. However, the tool does take some getting used to, especially for folks that are used to a green screen based query tuning experience. This presentation introduces you to IBM Data Studio and gets you started tuning queries.

IDUG DB2 Tech Talk - Tuning Queries with IBM Data Studio

Today database administration is all about doing more with less. We are constantly asked to expand the role and scope of DBA responsibilities without additional resources. Learn the foundation principles that are the underpinning of highly effective DBAs and how you can use them to transform your job. You are invited on a database journey to explore some practical ways these principles have been put into practice in the largest hospital in the United States.

IDUG Tech Talk: Ten Principals of Highly Effective DBAs

Join IBM architect Aamer Sachedina for an in-depth discussion of the enhancements in DB2 10.5 that help ensure "always available" transactions.  DB2 pureScale provides two major functions: enables capacity scaling without application change; and provides an  always available environment so that  transactional workloads, queries and other tasks continue uninterrupted in case of unplanned downtime. Now in DB2 10.5, several enhancements work with DB2 pureScale to ensure the ultimate in availability and disaster recovery for transactional workloads.  

In addition to providing a DB2 pureScale refresher, Aamer will cover the new enhancements including:

• Integration with DB2 high availability disaster recovery (HADR) functionality, to provide pureScale cluster mirroring remotely or locally to a standby server, thus enabling minimal impact to critical transaction systems

• Support for rolling maintenance updates, which is the ability to maintain individual machines in the cluster without impacting the user experience

Join us to learn the technical details behind these enhancements and how they help to ensure "always available" transactions.

DB2 Tech Talk: DB2 pureScale + HADR for Always Available Transactions, DB2 10.5

Join DB2 expert Sam Lightstone for an in-depth discussion of the all-new  BLU Acceleration features in DB2 10.5 for Linux, UNIX and Windows.  BLU Acceleration in-memory computing is designed to deliver results from data-intensive analytic workloads with speed and precision that is termed "speed of thought" analytics.  

In this Tech Talk, Sam will explain the details of this ground-breaking technology such as:

•Dynamic in-memory analytics that do not require all of the data to fit in memory in order to perform analytics processing

•Parallel vector processing, driving spectacular CPU exploitation


•Enhanced columnar storage techniques, including supporting the coexistence of row-organized and column-organized tables in the same database, and even in the same workload and SQL

•Actionable compression that does not require data to be decompressed in order to be analyzed, plus intelligent pre-fetch capabilities

... and more! Join us to learn the technical details behind this exciting advancement and find out why it makes super analytics, super easy to perform.

DB2 Tech Talk: Deep Dive BLU Acceleration Super Easy In-memory Analytics

Listen to this brief webcast of the impressions these two IBM Champions have after evaluating DB2 10.5 with BLU Acceleration.

DB2 Tech Bit: Iqbal Goralwalla and Jean-Marc Blaise on DB2 BLU Acceleration

Join Distinguished Engineer and DB2 expert Berni Schiefer and host Rick Swagerman for a technical tour of the all new DB2 10.5 with BLU Acceleration in-memory technology.  You will learn about new features such as: 

•BLU Acceleration, for “Speed of Thought” analytics 
Designed to handle data-intensive analytics workloads, BLU Acceleration extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the memory. Learn about RAM data loading capabilities, plus “data skipping”; parallel data analysis; actionable compression for analysis without decompressing data and more.  

• New DB2 pureScale capabilities that enable online rolling maintenance updates and capacity growth with no planned downtime, plus new integration HADR capabilities to help ensure always available transactions. 

• SQL and Oracle Database compatibility refinements in DB2 10.5, helping to ensure fast, easy moves to DB2 as well as increased flexibility for DB2  applications.  

• Enhancements to NoSQL technologies that are now business-ready in DB2 10.5. Although not part of the DB2 10.5 announcement, we will fill you in on other No SQL technology introduction plans as well.

• New packaging editions of DB2 that that handle either OLTP or data warehousing needs.

• DB2 tools advances that support these new functions.

Join us for this Tech Talk to find out about these exciting enhancements and how they can help you deliver the data analytics your organization needs while providing tools to keep your OLTP systems in top shape.

DB2 Tech Talk: Introduction and Technical Tour of DB2 with BLU Acceleration

In this brief Tech Bit, IBM Champion Tony Winch speaks on his impressions of DB2 10.5 with BLU Acceleration.

DB2 Tech Bit: IBM Champ Tony Winch on DB2 10.5 with BLU Acceleration

This Tech Talk continues the "deep dive" on all all new IBM DB2 10 and IBM Infosphere Warehouse 10 features. Matthias Nicola from IBM labs explains the new Time Travel Query feature, which is a collection of bitemporal data management capabilities. These capabilities include temporal tables, temporal queries and updates, temporal constraints, and other functionality to manage data as of past or future points in time.  Time Travel Query helps improve data consistency and quality across the enterprise and provides a cost-effective means to address auditing and compliance issues. As a result, organizations can reduce their risk of noncompliance and achieve greater business accuracy.

The presentation will discuss:  
·  How to create and manage temporal tables in DB2 10
·  How insert, update, delete, and query data for different points in the past, present, or future
·  How to use DB2 as a time machine

Please note that this webcast is conducted at 12:30 PM ET. You may see this time translated into your local time zone.

DB2 Tech Talk: Temporal Data Management Features of DB2 10

Presented by

About this talk

IDUG DB2 Tech Channel