(Craig S. Mullins) When you design your databases you must take care to specify appropriate free space to allow for data growth.

(Ember Crooks) This is one of those blog entries that I write and I know it will be obsolete and I will show my own ignorance and cringe at it in five years, but I have to write it anyway.

(Jon Paris) In this tip I’m going to give a brief introduction to the latest addition to the RPG language. The new DATA-INTO op-code. DATA-INTO is IBM’s response to the oft-asked question: “When is IBM going to introduce JSON-INTO so we can process JSON as easily as XML?”

(John Campbell, Terry Purcell, and Paul McWilliams) In Db2 12, you can expect to see increased use of list prefetch access, and possibly more use of hybrid join access paths by design, except where Db2 previously chose a sort-avoidance access plan, such as for statements that use SQL pagination.

(Scott) 83% of our audience learned something! 17% of our audience were Arwel’s co-workers! icon_lol Arwel completed a VERY successful migration from Oracle to Db2, and then another migration to Db2 V11.1.2.2 SAP on AWS Cloud. The compression, cost savings, and performance results are simply ASTOUN

(Deepthi Nagarajan) Data is business. The pace at which an organization can process data improves its ability to react to business events in real time.

(James Reeve) Every data scientist I know spends a lot of time handling data that originates in CSV files. You can quickly end up with a mess of CSV files located in your Documents, Downloads, Desktop, and other random folders on your hard drive.

(David Shirey) OK, so maybe I misunderstood this one a bit. Honestly, when I first looked at the API’s name, I thought it was related to figuring out what language you were using, whether it was Indo-European or Slavic or something else. My mistake.

(Michael Sansoterra) Hey, Mike! Regarding Composing An XML Document From Relational Data, Part 1, I have built an XML document using DB2 and i. When I run the query, I get a worthless result set. How do I use the SQL XML functions to get a usable XML file?

(Jim Wankowski) The idea of the traditional data center being centered on relational database technology is quickly evolving. Many new data sources exist today that did not exist as little as 5 years ago.