(Cristian Molaro) In many situations, the speed at which analysts can understand and react to changes in a dynamic business environment is limited by the IT infrastructure’s ability to process complex queries against large volumes of data. Ideally, business analytics would be unconstrained by infras
Tag: IBM
Embrace the Change: Part 2
(David Birmingham) Part 1 of this two-part series discussed the stresses on infrastructure, people, policies, processes, and protocols when the IBM PureData for Analytics powered by IBM Netezza technology first lands on the raised floor. We may know how to play the game.
DB2 for z/OS, Distributed Workload, and Enclaves
(Craig S. Mullins) If you work with DB2 for z/OS and have to manage distributed workload… or if you are enabling zIIP specialty processors… chances are you’ve at least heard the term “enclave” or “enclave SRB” before. But do you understand what an enclave is and why it is important?
A Distributed Terminology Refresher on DB2 DDF Subsystem Parameter Settings
(Willie Favero) Today’s Fortune 500 companies are embracing distributed techniques to access mainframe data on DB2. Although online transaction processing (OLTP) workloads still dominate DB2’s local processing, more applications, such as data warehousing analytics, run remotely as distributed tasks.
Architecting and Deploying DB2 with BLU Acceleration in Your Analytical Environment
(Whei-Jen Chen, Brigitte Bläser, Aidan Craddock, Polly Lau, Cong Lin, Kushal Munir, Martin Schlegel and Alexander Zietlow) DB2 with BLU Acceleration is a revolutionary technology delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvemen
Emulate sp_Help In DB2 For i
(Michael Sansoterra) Every once in a while I get an email from an SQL developer asking something like “What tool do you use to develop SQL routines on IBM i?” Astonished is the perfect verb to describe the reaction when I reply that I normally use STRSQL or Run SQL Scripts (in System i Navigator).
WLM assisted DB2 buffer pool sizing: The story continues… Part 4
(Willie Favero) This is Part 4 or 4 of a multi-part post covering the WLM buffer pool management function.
Measure the impact of DB2 with BLU Acceleration using IBM InfoSphere Optim Workload Replay
(Patrick Titzler and Hassi Norlén) In this article, learn to use IBM InfoSphere Workload Replay to validate the performance improvement of InfoSphere Optim Query Workload Tuner (OQWT) driven implementation of DB2 with BLU Acceleration on your production databases. The validation is done by measuring
Protecting your critical data with integrated security intelligence
The world depends more than ever on highly sensitive digital information, making confidential information an increasingly attractive target for criminals. (R)
Runstats Issue With Columns Where There is a Long Common Prefix in Character Data
(Ember Crooks) This technote caught my eye when @db2_support tweeted it the other day ago. It was titled as “DB2 might choose a sub-optimal query execution plan due to distribution statistics”. The title alone intrigued me. As I read through, I thought that I needed to do a bit of investigation to b
