September 2017 Blog Posts (6)

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

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…


Added by Paul McWilliams on September 28, 2017 at 17:00 — 1 Comment

The 3270 UI enhanced with Thread History Information

New features are being added to the Enhanced 3270 User Interface in each release of OMEGAMON XE for Db2 Performance Expert on z/OS.  A continued investment in the 3270 UI provides more synergy and integration with the entire OMEGAMON family of products. One of the most important features introduced for version 5.3.0 is the ability to display Thread History.


In OMEGAMON for Db2, there are two types of history. The Snapshot type of history takes a sample of what is…


Added by Paul Kenney on September 21, 2017 at 17:40 — No Comments

Hot Off the Press! Db2 12 Performance Redbook - download your copy today and reduce costs!

IBM Db2 12 for z/OS Performance Topics

An IBM Redbooks publication

I know many of you have been waiting for this Redbook so the wait is over, this is a very valuable book written by some of the top experts in the industry. Download your copy today and find out how Db2 12 delivers significant business value and helps reduce costs, improves scalability which is critical in today's IT…


Added by Surekha Parekh on September 20, 2017 at 9:31 — No Comments

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

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…


Added by Paul McWilliams on September 18, 2017 at 16:00 — No Comments

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

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…


Added by Paul McWilliams on September 11, 2017 at 9:00 — No Comments

XI PDUG conference in Wroclaw - AGENDA is ready!

Agenda for the next 11th PDUG conference is ready! DB2 users and the best IBM and CA lab specialists will share their practical knowledge with us in Wroclaw (Poland) on 27-28 September. We plan two workshops on both LUW and z/OS tracks.

Link to Agenda…


Added by Sekowski Pawel on September 7, 2017 at 15:57 — No Comments

Monthly Archives












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


Db2 for z/OS Master class with John Campbell and the SWAT team returns!

Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply

Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue

Tags: Events, MasterClass, JohnCampbell

RBS Shares their Db2 Utilities Experiences

Started by Calene Janacek in What's hot ? Oct 22. 0 Replies

Join Mark Turner, Lead Mainframe Architect and Strategist from RBS and Haakon Roberts, IBM DE as they share Royal Bank of…Continue

Tags: #Db2

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service