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.


IDUG Db2 Tech Conference coming to San Paulo, Brazil and Mexico City! Register Now

Started by Surekha Parekh in What's hot ? on Thursday. 0 Replies

For the first time IDUG is hosting two events in Latin America. These seminars will bring together Db2 professionals from around the world for expert-led technical sessions and networking opportunities. This is your chance to connect! …Continue

Tags: Education

MSSQL linked server attaching to DB2 LUW

Started by Mike Jett in Application Development and DB2 on Thursday. 0 Replies

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB.  I have not been able to figure out how to add additional catalogs(DB's).  Is it possible to use just one…Continue

Tags: server, linked

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service