(Harishkumar Baburao Pathangay) How Load Utility consumes Huge Transactional Log Space Solution:
Tag: IBM
NoSQL and JSON
(Troy L Coleman) I’ve been doing some reading about NoSQL and how DB2 for z/OS will support it. This 2014 article examines the relationship between NoSQL and DB2 Java Scriipt Object Notation (JSON), and predicts that relational databases will begin to support JSON.
Modernize Your DB2 for z/OS Maintenance with Utility Autonomics
(Dean Brown, Carlos Gomes, Arthur Marais and Hennie Mynhardt) DB2 for z/OS helps lower the cost of managing data by automating administration, increasing storage efficiency, improving performance and simplifying the deployment of virtual appliances.
Influencing the DB2 Optimizer: Part 2 – Standard Methods
(Craig S. Mullins) Last week, in Part 1 of this series, we introduced the concept and the 5 high-level methods of influencing the DB2 optimizer’s access path choices. In today’s post, we will tackle the first approach, which is using standard, DB2-based methods.
Red Alert: For DB2 V10 and DB2 V11 users (2015.07.06)
(Willie Favero) It appears that in rare situations the DB2 log records could be written with invalid control information, not a good thing. A “ Red Alert” was put out today by the Red Alert subscription service for zSeries to warn customers of this serious situation.
The WebSphere Contrarian: If liberty means freedom of choice, am I free to choose the Liberty profile?
(Tom Alcott) Since it’s introduction in 2012, the IBM WebSphere Application Server Liberty profile has rapidly evolved from a development desktop focused runtime to one that is increasingly being considered for production deployment. The
DB2 Tips n Tricks Part 64 – How To Restrict Load Utility during Online Database Backup
(Harishkumar Baburao Pathangay) How To Restrict Load Utility during Online Database Backup Solution: Define Work Class for Work Type
Stopping DB2 Processes for a DB2 Fix Pack Upgrade
(Aish Khare) When upgrading DB2 fix packs, you need to make sure that all DB2 related processes have been shut down clean. In normal circumstances, you would:
DB2 11 for z/OS now has accelerator-only table functionality
(Willie Favero) Have you ever noticed that sometimes you make a statement, and no sooner is it made something comes along and negates it? Then you have to write a new blog post explaining why the first thing you said is no longer true.
Practical SQL: Partitions and MERGEs
(Joe Pluta) One of the big advantages of SQL is the fact that you can add columns to a table without worrying about the underlying access; columns that aren’t used are simply ignored in the SQL client programs. However, once you have added that column, the next trick is to populate the column correc
