Articles & Content

Planet DB2

planetDB2 is an aggregator of blogs about the IBM DB2 database server

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
Brace expansion to match multiple files in BashBash has handy brace expansion powers that I’ve belatedly discovered. [crayon-5977a675a7e28542992445/] For example, you can quickly diff a file with and without a suffix:... ...
The New z/14 and Pervasive EncryptionLast week IBM unveiled the newest mainframe system--the z14. As noted in the announcement letter, the z14 is intended to provide the cornerstone for the "trust economy." ...
Db2 12 for z/OS SQL Enhancements: Result Set PaginationIn this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe... ...
How to block database connectionsDuring a recent consultation there was a requirement to block DB2 LUW database connections. The purpose was to test monitoring alerts and assess the correct response when a database connection could... ...
What the Null? Handling Missing Information in Database SystemsIn relational database systems, a null represents missing or unknown information at the column level. A null is not the same as 0 (zero) or blank. Null means no entry has been made for the column... ...
A Happy 10 YearsTen years ago this week--July 16, 2007, to be specific--this blog published its first post, on Universal Table Space. IBM Systems Magazine had asked me if I would consider writing a blog about Db2... ...
The IBM z14: There's a New Mainframe Coming!Today, July 17, 2017, IBM announced the next iteration of its stalwart mainframe hardware, the IBM z14. The news comes a little more than two years since the previous version, the IBM z13. The... ...
Best practices for lively chatbotsTJBot as lively chatbotMore and more chatbots are being developed and there are good reasons for it. Not all chatbot projects succeed. Often, missing user acceptance is stated. The dialog... ...
Chatbots: Testing ContextsWatson Conversation Tool in actionSome weeks ago I blogged about a tool I wrote for the IBM Watson Conversation Service (WCS). It allows you to manage your conversation workspaces from the... ...
The DB2 12 for z/OS Blog Series - Part 13: DRDA Fast LoadHave you ever had a situation where you needed to load data into a DB2 table, but the file with the data was not on the mainframe? So you had to PTF that data to the mainframe and then load... ...