I recently attended a regional DB2 user group meeting, and the subject of continuous delivery came up frequently. People were wondering about the process of adding new features being added through the maintenance stream and how to fallback if it's determined that the new features are causing a problem.
Posted: November 29, 2016 |
Long-time readers of DB2utor know that I prefer using the DB2 manuals in PDF form as opposed to the electronic versions available from the IBM Knowledge Center. After hearing rumors that IBM would no longer make documents available in PDF, I was very pleased to find the DB2 12 for z/OS manuals available in PDF form.
Posted: November 22, 2016 |
In last week's IBM DB2 Analytics Accelerator for z/OS V6.1 announcement summary, I mentioned that I'd get to the other piece of news, which is the introduction of IBM DB2 Analytics Accelerator on Cloud V1.1.
Posted: November 15, 2016 |
On Oct. 18, IBM announced the latest version of DB2 Analytics Accelerator for z/OS as well as a new product, IBM DB2 Analytics Accelerator on Cloud.
Posted: November 08, 2016 |
When a high number of inserts arrive in a non-clustered way at the end of a table space or table space partition, it's known as a "journaling pattern." While I personally haven't worked on this type of application, Dan Luksetich of DanL Database Consulting has, and he wrote this white paper about it.
Posted: November 01, 2016 |
Storage technology keeps improving, which is obviously a good thing. However, DBAs may not always be up to date on these changes and how they impact application performance. (In our defense, we DBAs have a lot on our plates!) I started writing about this two years ago, and followed up by asking the potentially contentious question, “Are REORGs Still Necessary?”
Posted: October 25, 2016 |
Following up on last week's DB12 for z/OS announcement, I want to discuss the supporting tools, which include the DB2 utilities.
Posted: October 18, 2016 |
Last week IBM announced DB 12 for z/OS and its Oct. 21 general availability. Of course there's a lot to dissect -- and I'll certainly be getting into specifics of DB2 12 features in the weeks and months ahead -- but for now, here are some of my initial reactions.
Posted: October 11, 2016 |
Following up on last week's post on real memory and in-memory index optimization, here's a little more about the upcoming DB2 12. The new release will support in-memory tables that use in-memory contiguous buffer pools.
Posted: October 04, 2016 |
Last month I wrote about the trend of increasing the amount of real storage when configuring new mainframe systems. DB2 12 (which is set for delivery in the fourth quarter of 2016) features many new performance improvements that are designed to take advantage of available real storage. One of these enhancements is called In-Memory Index Optimization -- aka, index fast traversal blocks (FTBs).
Posted: September 27, 2016 |