(Sergio Dias) IBM Informix version 12.10.xC1 comes with striking new features and enhancements in existing features—as well as a few features or products that were removed. Understanding the new, enhanced, and discontinued features is crucial for better planning and determining which functions shoul
Tag: IBM
What to do with a Character you Cannot Query
(Ember Crooks) This post comes out of one of the more challenging technical problems I have encountered recently.
DB2 10.5 for LUW: Into the BLU… and Beyond
(Philip Nelson) It is rare that Information Management topics become discussion points in the mainstream media; however, Big Data is a popular topic that has even made it onto BBC’s “Start the Week” discussion program on BBC Radio 4: right at the heart of the establishment.
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting started
(Ajith Kumar Punnakula, Rahul Jain and Balaji Kadambi) Business applications commonly need to reuse aggregated or processed data from a set of data sources over a single series of operations. An example for this could be generation of reports for analysis and decision making. In order to support thi
Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator
(Ruiping Li) Business analytics plays a crucial role in today’s workplace. The performance and cost of the DB2 Analytics Accelerator opens up unprecedented opportunities for enterprises to make use of the data on the IBM System z platform.
DB2 Locking, Part 6: Claims, Drains, and Partition Independence
(Craig S. Mullins) DB2 augments resource serialization using claims and drains in addition to transaction locking. The claim and drain process enables DB2 to perform concurrent operations on multiple partitions of the same table space.
Determining the CPU usage of applications running in WebSphere Application Server on z/OS
(Karl Gaffney and Daniel McGinnes) When many applications are deployed and running concurrently in an IBM WebSphere Application Server environment, it is often desirable to determine which of these applications are consuming CPU resources. This is especially true if it is suspected that one or more
Performance Tuning for XML-based OLTP Systems (Temenos T24)
(Henrik Loeser) From time to time my colleagues and I get contacted on how to set up and tune DB2 for use with Temenos T24. The latter is a core banking system and in use worldwide. And it uses XML as internal data storage format which makes it an ideal fit for DB2 pureXML (both on z/OS and on Linux
Are DBAs Still Needed?
(Troy Coleman) Since IBM unveiled its big data strategy, there’s been an interesting response. Some have focused on the role of the DBA, wondering if advancements like IBM Data Analytics Accelerator for z/OS (IDAA) and Netezza, which are designed to eliminate concerns over index design when storing
IBM JSON
(Philip Howard) Readers will be aware that there has been some confusion about the support for JSON (JavaScript Object notation) documents in the latest release of DB2.
