Paul McWilliams's Friends

View All

Gifts Received

Paul McWilliams has not received any gifts yet

Give a Gift

Paul McWilliams's Page

Profile Information

Why join "The World of DB2"?: Looking for news blogs and podcasts

What information or education would be useful to you?: Performance Monitoring and Trending

Are you a member of IDUG (International DB2 User Group)?: No

Are you a member of a Regional User Group (RUG)? If so, which one?: none

What best describes your job role?: IBM Employee / Business Partner, Other

Paul McWilliams's Videos

DB2 12 for z/OS — Continuous Delivery Documentation

Added by Paul McWilliams 0 Comments 0 Likes

Paul McWilliams's Blog

Enhanced SQL MERGE—a Db2 12 greatest hit with John Campbell

Posted on August 1, 2018 at 22:51 0 Comments 0 Likes

Back in Version 9, Db2 for z/OS introduced minimal support for MERGE statementst, only providing an upsert capability with limited functionality. Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016 Core standard, as…

Continue

Db2 for z/OS Master Classes

Posted on July 18, 2018 at 16:53 0 Comments 0 Likes

The first Db2 for z/OS Master Class to be hosted by IBM Europe was recently held at IBM Hursley. The next invitation-only session at IBM Silicon Valley Laboratory is already full, but future session are planned. For the full story, see Db2 for z/OS Master Classes.

Always get the latest news about Db2 for z/OS from the IBM lab!…

Continue

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted on May 22, 2018 at 21:25 0 Comments 0 Likes

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in New SQL pagination syntax - a Db2 12 greatest hit with John…

Continue

Fast index traversal - a Db2 12 greatest hit with John Campbell

Posted on May 8, 2018 at 17:53 0 Comments 0 Likes

Fast index traversal is one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal.…

Continue

Comment Wall (1 comment)

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

At 22:43 on November 20, 2009, Surekha Parekh said…: Welcome to the "World of DB2 for z/OS ! " It is great to have you join this exciting e-community. Please can you invite your friends and collegues. Also feel free to provide feedback on how we can improve this community.
Surekha
WW DB2 for z/OS Market Manager