Attend Episode #133 to learn about DB2 V10.1 performance enhancements with guest Gopi Attaluri from the IBM Silicon Valley Lab. Mr. Attaluri will focus on Index Jump Scans, how they work, performance benefits, and “best practices”.
Tag: IBM
TechTip: Compound Dynamic SQL Statements
(David Shirey) A lot of new things came out in the IBM i Technology Refresh for 7.1 that was released this past fall. And some of those enhancements have been for DB2, the DDL-based database that’s part of the i operating system.
DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL
(Serge Rielau) The next DB2 Tech Talk is one that should be of interest to those that follow this blog.
Acronyms… and why they drive me crazy
(Willie Favero) Look out… personal, out of control, over the top rant is about to happen…
XML or JSON: Guidelines for what to choose for DB2 z/OS
(Jane Man and Susan Malaika) IBM DB2 for z/OS offers document storage support for both JSON and XML. It is not always apparent whether JSON or XML is most suitable for a particular application. This article provides guidelines to help you select XML or JSON. It includes examples of creating, queryin
DB2 for z/OS People: Wearing Your ‘Applications’ Hat Versus Your ‘Systems’ Hat
(Robert Catterall) Not long ago, a colleague of mine sent to me an e-mail message that he’d received from a person who supports DB2 for z/OS at a US-based company. In this message the IT professional wrote of some DB2-accessing application programs that were running into lock contention issues with
TechTip: Even More Nifty New Features in V2R1 DB2 Web Query
(Gene Cobb) In my last TechTip, I introduced you to several new features that have been delivered in DB2 Web Query version 2.1 group PTFs over the last year and a half. In this TechTip, you’ll learn about three more major improvements to the product: REST Web Services, an application extension named
Deployment Guide for InfoSphere Guardium
(Whei-Jen Chen, Boaz Barkai, Joe M DiPietro, Vladislav Langman, Daniel Perlov, Roy Riah, Yosef Rozenblit and Abdiel Santos) IBM InfoSphere Guardium provides the simplest, most robust solution for data security and data privacy by assuring the integrity of trusted information in your data center. Inf
WebSphere MQ 7.5 and Apache ActiveMQ 5.9 performance comparison – results (part 3)
(Roman Kharkovski) As I mentioned in my previous article, I have been busy doing performance tests of WebSphere MQ and Apache ActiveMQ (also see the video of the benchmark). Now I am ready to publish results, but only for the persistent tests.
Current_timestamp minus days
(Jack Vamvas) Question:Do you know how to write a query in DB2 that would display records based on the last month eg. Take todays date and then display last 31 days?
