(Steve Pitcher) A couple of months ago, IBM announced a DB2 10.5 offering called BLU Acceleration. With customers looking to analyze, slice, dice, puree, and chop big data from social media all the way down to traditional ERP and CRM data sources, BLU (“Big data, Lightning fast, Ultra-easy”) effecti
Tag: IBM
Minimizing Buffer Turnover Rate
(Lester Knutsen) One of the key metrics in all database systems is how effectively does the database use the computer memory for storing data to reduce disk I/O. Disk I/O is normally the slowest subsystem in a database. The demand and interest in in-memory databases is a result of the I/O bottleneck
Experiment with the JSON technology, new from IBM
(Susan Visser) JSON technology is now included in DB2. You can experiment with the JSON technology, through this Technology Preview from IBM.
Optimize DB2 10.5 for Linux, UNIX, and Windows performance using InfoSphere Optim Query Workload Tuner with the DB2 BLU accelerator feature
(Thuan Bui and Soid Quintero) The new BLU Acceleration feature in IBM DB2 10.5 for Linux, UNIX, and Windows can help improve the performance of your workload by converting row-organized tables to column-organized tables. However, the challenge is to know what tables could be converted and how much p
IBM Information Server: Integration and Governance for Emerging Data Warehouse Demands
(Chuck Ballard, Manish Bhide, Holger Kache, Bob Kitzberger, Beate Porst, Yeh-Heng Sheng and Harald C. Smith) This IBM Redbooks publication is intended for business leaders and IT architects who are responsible for building and extending their data warehouse and Business Intelligence infrastructure.
5 Steps for Migrating Data to IBM DB2 with BLU Acceleration – See more at: http://ibmdatamag.com/2013/06/5-steps-for-migrating-data-to-ibm-db2-with-blu-acceleration/#sthash.TBP5F3Zm.dpuf
(Mohankumar Saraswatipura) In the dynamics of today’s business world the success of any organization depends largely on organizational decisions made at the appropriate times. And a reliable data warehouse environment plays a pivotal role in helping drive the business decisions that can move an orga
DB2 Locking, Part 15: Tackling Timeout Troubles
(Craig S. Mullins) Many shops battle with locking issues and frequently, the cause of performance issues can be traced back to locking issues, more specifically, lock timeout issues. When you experience a timeout, it means that another process holds a lock on the data that you are trying to modify.
Migrating from Apache Tomcat to the WebSphere Application Server Liberty Profile
(Cheryl King) This article provides instructions for migrating applications and their configuration information from Apache Tomcat to the IBM WebSphere Application Server V8.5.5 Liberty Profile using two utilities (one of which is new for V8.5.5) that make migrating easy and reliable.
Sick of Oracle? Break Free!
(Frank C. Fillmore, Jr.) The Fillmore Group has been assisting customers with Oracle to DB2 migrations for the past few years.
Away With The SQL Slash Separator
(Michael Sansoterra) One potentially confusing aspect of programming SQL in DB2 for i for non-IBMers is the use of the forward slash character to qualify an SQL object with a schema. IBM i devs don’t have a problem with the slash because we recognize it as the character we use when qualifying object
