Paul McWilliams
  • San Jose, CA
  • United States

Paul McWilliams's Friends

  • Surekha Parekh

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)?
Are you a member of a Regional User Group (RUG)? If so, which one?
What best describes your job role?
IBM Employee / Business Partner, Other

Paul McWilliams's Videos

  • Add Videos
  • View All

Paul McWilliams's Blog

News about PDF for Db2 for z/OS documentation

Posted on October 18, 2017 at 10:35pm 0 Comments

The Db2 for z/OS documentation team recently changed how we deliver PDF manuals for Db2. These changes are mostly transparent to you. However, I've recently fielded several questions related to the recent process changes and more general concerns about the future of PDF manuals for Db2, and I want to respond to those questions.

But first: advantages of IBM Knowledge Center

As I hope you're aware, …


Avoid automatic binds at migration to Db2 11 or Db2 12 for z/OS

Posted on September 28, 2017 at 5:00pm 1 Comment

By Patrick Bossman and Paul McWilliams

Automatic binds of plans and packages for applications that run on Db2 for z/OS introduce avoidable risk to online and offline migrations. During and after migration, automatic binds can cause costly problems, including performance regression and even application outages.

However, you can take action before migration to…


Reduce cost and effort with new LOAD utility IGNORE options in Db2 for z/OS

Posted on September 18, 2017 at 4:00pm 0 Comments

By Patrick Malone and Paul McWilliams

Db2 for z/OS DBAs who use the LOAD utility in Db2 11 and Db2 12 can reduce the cost and effort of preparing input data sets for the LOAD utility, examining LOAD utility job output, and dealing with discard data sets, by using several new IGNORE options.

DBAs are often aware of records in input data sets that trigger…


List groups of values with the LISTAGG built-in function in Db2 for z/OS

Posted on September 11, 2017 at 9:00am 0 Comments

By Jason Cu and Paul McWilliams

In Db2 12 for z/OS function level 501, you can write efficient queries to select groups of related values and return each group as a list in a single string value, with optional separators, without writing complex recursive SQL statements. Consider the sample EMP table that is supplied with Db2. You can write a query that calls the…


Comment Wall (1 comment)

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

Join The World of DB2

At 10:43pm 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.
WW DB2 for z/OS Market Manager

Bringing DB2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service