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 |
The application development landscape on the mainframe -- which for me is really z/OS -- continues to evolve. Now businesses that are moving to cloud and mobile applications use not only Java, but also Perl, PHP, Python, R and TCL. These open source languages are very powerful because they can facilitate certain types of processing through a minimal amount of coding.
Posted: September 20, 2016 |
In my job with IBM, I spend a lot of time at customer sites. During these visits, I’m seeing an increasing number of young IT professionals who are just starting their careers on z/OS.
Posted: September 13, 2016 |
Software development on z/OS has traditionally adhered to tried and true practices to ensure that poorly constructed application code does not make it into production. In many shops we call these change control people the “gatekeepers.” Nothing gets past these individuals. Developers must rigorously test their code before an application or update goes live. Beyond that, fallback procedures must be devised in case there's a problem once the code is moved into production. On top of that, changes to production systems are subject to a strict schedule to ensure that no critical business event are interrupted.
Posted: September 06, 2016 |
In November 2015 I wrote about the launch of DB2 12 for z/OS ESP, citing all the various enhancements DB2 has made by exploiting significantly greater amounts of available memory. Well, it isn't just DB2 12 that will benefit from additional memory to reduce CPU cost.
Posted: August 30, 2016 |
DB2 11 introduced a powerful feature that allows you to set special registers for remote applications by creating a profile in the profile tables. Information on the install jobs used to create these tables, as well as rules for inserting rows into the tables, can be found in the DB2 Administration Guide or the IBM Knowledge Center.
Posted: August 23, 2016 |