(Ember Crooks) I mostly like and use DB2Œs Self Tuning Memory Memory Manager (STMM) for my OLTP databases where I have only one DB2 Instance/Database on a database server. I do have some areas that I do not let it set for me.
Tag: IBM
Using the New Compatibility Mode
(Troy Coleman) In May when I posted a summary of new DB2 11 features, I mentioned that the latest release allows applications with SQL or XML to be run in compatibility mode. Since this is an important feature that will help customers much more quickly migrate to DB2 11, I’ll provide some detail.
Explore the eXtreme Scale-based caching service options in IBM PureApplication System
(Cheng-Chieh Cheng) Caching services are a popular solution to address performance and scalability issues for cloud enterprise applications. Explore three caching options available with the IBM PureApplication System cloud system: One built-in, one based on WebSphere eXtreme Scale that uses a virtua
‘IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop’ #IDUG Europe
(Frank Fillmore) From November 9 – 14 I will be visiting one of the most charming cities on the planet when I attend the International DB2 Users Group (IDUG) conference in Prague, CZ. I will present “IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop”.
DB2 Tips n Tricks Part 38 – Limitation on Monitor Metrics by Dynamic SQL Snapshot
(Harishkumar Baburao Pathangay) How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect Solution:
Securing IBM Integration Bus on z/OS without changing the integration node configuration
(Pabitra Mukhopadhyay) This article shows you how to configure AT-TLS for IBM Integration Bus message flows on z/OS, including the policy agent and TCP/IP stack configuration on z/OS. Simple HTTP-based message flows let you quickly test the setup from a distributed system such as Windows server.
APAR Friday: Accelerator, SQLCODE, SYSTS UPDATE SP, and PKGREL COMMIT
(Willie Favero) The first three APARs all have something to do with the DB2 Analytics Accelerator for z/OS. Even though the Accelerator is a for-cost option, it’s still pretty cool and gaining more and more popularity.
On the Importance of Metadata
(Craig S. Mullins) The importance of metadata is rising – and many organizations are beginning (or starting again) to embrace metadata as a means to better understanding their data. This is driven by requirements imposed on organizations such as regulatory compliance, but also on the desire to bette
5 More DB2 SQL Performance Tips
(Dave Beulke) Writing good DB2 SQL is always difficult because it is dependent on the database table design and the various table indexes available coming together with the purpose of the processing module.
IBM DB2 with BLU Acceleration
(Whei-Jen Chen and Shawn G. Tooley) Available with the IBM DB®10.5 release, BLU Acceleration delivers unparalleled performance improvements for analytic applications and reporting using dynamic in-memory optimized columnar technologies.
