(Robert Andrews, Theo Bär, Gene Cobb, Rick Flagler, Kei Fujii, Hector Gongora, Doug Mack, Simona Pacchiarini, Septia Sukariningrum, Yu Yu Wang, Yu Zhe Zhi, Yu Zhu and Hernando Bedoya) Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes of underst
Tag: IBM
The Danger of FETCH FIRST ROW ONLY
(Ember Crooks) There are a a vast array of things you can do in SQL. But just because you can doesn’t always mean that you should.
Check out Clabby Analytics on IBm BLU Acceleration!
(Cindy Russell) This analyst finds that DB2 with BLU Acceleration for in-memory computing delivers consistently higher performance at a lesser cost. Read for yourself.
WebSphere Adapter for Flat Files – a technical deep dive, Part 1: How to configure for inbound processing
(Susann Fritzsche and Katrin Hagemann) This 2-part article series describes a customer solution that extensively used the inbound and outbound processing of WebSphere Adapter for Flat Files. Part 1 explains how to sequence and order the files and the different possibilities to configure the polling
A Follow-Up on Drop Column Support
(Troy Coleman) When I recently wrote about the new DB2 11 drop column support, I admitted that I couldn’t understand why this was such a highly requested feature. A commenter provided some insight.
DB2 Tech Talk: Leverage Optim Workload Replay for DB Environment Change
(Cindy Russell) IBM InfoSphere Optim Workload Replay can significantly improve your database testing experience and help you successfully manage change in your database environments, whether you are adopting BLU Acceleration, upgrading DB2, or making the move to DB2.
APAR Friday: Apply a PTF, get improved performance
(Willie Favero) Today’s fix is a pretty straight forward one. You all know how fast log apply helps improve recovery times for a table space, right?
DB2 10 (and beyond) for z/OS: Being Smart About More RELEASE(DEALLOCATE)
(Robert Catterall) By now, a lot of you probably know that a really important action to take, once your DB2 subsystem is at the Version 10 (conversion mode) level, is to rebind your plans and packages. Taking this action delivers several benefits:
Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform
(Chuck Ballard, Jason Arnold, Rich Briddell, Heverson Campelo, Cecile Madsen, Jayanti Mahapatra and Eduardo Pingarilho) With ever-increasing workloads on production systems from transaction, batch, online query and reporting applications, the challenges of high availability and workload balancing ar
DBA Rules of Thumb – Part 12 (Be a Packrat)
(Craig S. Mullins) Today’s post in the DBA Rules of Thumb series is short and sweet. It can be simply stated as “Keep Everything!”
