IBM DB2 Community

IBM DB2 Blog

Robert Catterall
Follow /30 Jun 2017 at 10:38pm / IBM DB2 Blog

DB2 12 for z/OS SQL Enhancements: Piece-Wise DELETE

DB2 12 for z/OS, which became generally available in October of 2016, delivered a number of key enhancements pertaining to SQL statements. Over the course of a few blog entries, I'll describe some of my favorites among these enhancements. This first...
161 0 /
Robert Catterall
Follow /25 May 2017 at 5:48am / IBM DB2 Blog

DB2 for z/OS and Data-as-a-Service and Database-as-a-Service

______-as-a-service is all the rage in IT these days, and understandably so -- the "service-ization" of information technology capabilities and interfaces will be transformational; indeed, transformations have already occurred or are underway...
236 0 /
Deepak Vohra
Follow /2 May 2017 at 11:15pm / IBM DB2 Blog

What's New in IBM DB2 LUW 11.x: DB2 on Cloud for Bluemix

By Deepak Vohra The new IBM DB2 11.x collaboration features are provisioned by IBM’s cloud platform called Bluemix. IBM’s Bluemix provides several IaaS (Infrastructure as a Service) and PaaS (Platform as a Service) cloud services. IBM’s...
515 0 /
Robert Catterall
Follow /30 Apr 2017 at 7:21pm / IBM DB2 Blog

DB2 for z/OS: Something You Might Not Know About Large Page Frames in a Post-DB2 10 Environment

I well remember the first time I saw it. August, 2016. I was looking at output from the DB2 for z/OS command -DISPLAY BUFFERPOOL(ACTIVE) DETAIL, issued on a DB2 11 system, that a client had sent to me for review. I appreciated the fact that I could see...
287 0 /
Robert Catterall
Follow /26 Mar 2017 at 10:45pm / IBM DB2 Blog

DB2 for z/OS: Running REORG to Reclaim Disk Space

Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inserts and/or for updates ); to remove the AREO* status...
415 0 /