Featured Blog Posts (44)

TRIDEXDb2 for LUW - First Quarterly Meeting March 29th, 2018

Tridex 32918 LUW.doc

Location: IBM Corporation 590 Madison Ave (between 56th & 57th)

Room 1219, 12th Floor

A free day of Db2 education with speakers:

Dale McInnis

John Hornibrook

Les King

Joe Geller

See the attached flyer for the session…


Added by Joe Geller on February 27, 2018 at 7:00pm — No Comments

IDUG DB2 Data and Analytics Technical Summit in Chennai, India March 29, 2018

Announcing the 2018 IDUG Chennai Data and Analytics Technical Summit!

IDUG in collaboration with IBM are offering this great opportunity for all database professionals in India to enhance their productivity, gain new skills and influence the quality, usability and support of IBM Data Management…

Added by Sandy Flippen on March 19, 2018 at 5:32pm — No Comments

HURRY today is the last chance for you to register our DOUBLE Webcast Series - Db2 12 Migration Planning and EARLY CUSTOMER EXPERIENCES.

HURRY today is the last chance for you to register our  DOUBLE Webcast Series - Db2 12 Migration Planning and EARLY CUSTOMER EXPERIENCES. There will be a  with LIVE Q &A session  with John Campbell - IBM Db2 Guru. This is fresh content for 2018 to help you accelerate your Db2 12 Migration.

DB2 12 for z/OS Technical Overview PART 1 & 2 with live…


Added by Surekha Parekh on February 19, 2018 at 1:12pm — 1 Comment

Support for the extended LRSN and RBA format in IBM Db2 for z/OS

Some time ago, John Campbell, Michael Dewert and I published a Db2 white paper on the support for the extended LRSN and RBA format introduced in Db2 11. This paper is no longer available on the internet, so we have decided to reproduce it here as it contains valuable information for safely implementing the extended format in both data sharing and non-data sharing environments, and in particular for avoiding pitfalls which can lead to unplanned outages. …


Added by Gareth Copplestone-Jones on January 28, 2018 at 7:30pm — No Comments

Massive RUNSTATS CPU reductions when collecting Db2 for z/OS COLGROUP frequency statistics

By Koshy John and Ann Hernandez

If you are a Db2 for z/OS DBA, you know…

Added by Terry Purcell on December 11, 2017 at 4:07pm — 3 Comments

Complimentary whitepaper on Db2 for z/OS function level 501 - LISTAGG

With Db2 for z/OS continuous delivery model, new Db2 for z/OS features/enhancements are continuously delivered in service stream when they are ready. LISTAGG is one of first set of functions delivered in function level 501 since Db2 adopted continuous delivery model.

In the…


Added by Jane Man on November 24, 2017 at 6:34pm — No Comments

Improve the way you maintain IBM Z software with the IBM zServiceAdvisor

By Nigel Slinger and Ann Hernandez

If you’re involved in supporting Db2 for z/OS environments, you probably wish there were a simpler way to deal with preventive maintenance. The good news is that the IBM…


Added by Ann Hernandez on October 26, 2017 at 9:38pm — 1 Comment

Announcing Enterprise Advisor for Db2 for z/OS

By Joseph Ou-Yang and Ann Hernandez

Do you ever wish you could just ask a Db2 expert about something? Maybe about how to do something with Db2 that you've never done before? Or maybe about problems that occur during migration from an older version of Db2 to Db2 12 or Db2 11? If having an expert available sounds appealing to you, then IBM's recent announcement about…


Added by Ann Hernandez on October 30, 2017 at 7:30am — No Comments

Db2 11 for z/OS support for z/OS data set encryption

By Jim Pickel, Gayathiri Chandran, and Judy Tobias

Customers have been telling us that they lack adequate safeguards to protect data in Db2 for z/OS from viewing by unauthorized internal personnel. In Db2 11 for z/OS, we address that problem…


Added by Judy Tobias on November 9, 2017 at 3:00pm — 2 Comments

News about PDF for Db2 for z/OS documentation

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, …


Added by Paul McWilliams on October 18, 2017 at 10:35pm — No Comments

Why did over 1000 Db2 users downloaded this valuable whitepaper?

Why did over 1000 Db2 users downloaded this valuable whitepaper ?

Whitepaper: DB2 12 for z/OS The In-Memory Enterprise Database for Transactions and Analytics

This paper will provide a high-level overview of the major new features of IBM DB2 12 for z/OS from an IT Executive’s perspective, with the emphasis on the underlying business value that the…


Added by Surekha Parekh on October 13, 2017 at 6:00pm — No Comments

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 5:00pm — 1 Comment

Support for collection of more accurate real storage usage statistics

by Akiko Hoshikawa and Judy Tobias

In Db2 11 for z/OS and Db2 12 for z/OS, we introduce an enhancement that improves your ability to obtain accurate real storage usage statistics. In the past, z/OS capacity planners have experienced difficulties in determining an accurate estimate of the main memory that their Db2 subsystems used. With this enhancement, you can have…


Added by Judy Tobias on October 2, 2017 at 1:23pm — 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 4:00pm — No Comments

Db2 for z/OS Pain Points Survey

Complete the Db2 for z/OS Pain Points Survey to identify and rank the pain points you currently experience while using Db2 for z/OS. We gladly accept multiple responses from your company. Your feedback is very important to us. Thank you for taking 5-10 minutes to complete the survey.


Added by Paul McWilliams on July 21, 2017 at 8:35pm — No Comments

DB2 12 Optimizer Redbook READY! HOT OFF THE PRESS! DOWNLOAD today!


DB2 12 for z/OS Optimizer Red Book is ready for download.

GET IT ON iBooks or Google Play …


Added by IBMDB2 on July 3, 2017 at 6:56pm — No Comments

Call for presentations - PDUG conferences Wrocław 27-28 September 2017 POLAND

Presentations for PDUG conferences Wrocław 27-28 September 2017 POLAND

Only a few months have passed since the last conference and we are already planning another!

As we announced at our last meeting, our next event will take place September 27-28, 2017 in Wroclaw (IBM Global Services Delivery Center, Muchoborska 8). This will be our first visit to this city, which we are extremely happy about. But what would this conference be without…


Added by Sekowski Pawel on June 24, 2017 at 4:10pm — No Comments

Backup and recovery of DB2 Analytics Accelerator data now possible!


The IBM DB2 Analytics Accelerator for z/OS provides the ability to gain greater insights and analytics capabilities from their enterprise DB2 data.   The Accelerator allows you to run analytic queries against their existing DB2 data at higher speeds and lower costs than the same queries running natively on IBM DB2 for z/OS. This is great for data that exists…


Added by Tim Willging on May 16, 2017 at 1:27pm — No Comments

Backup and Recovery of DB2 Analytics Accelerator data now possible! Part II

Creating a backup of data stored in an Accelerator


This is the second part of “Backup and Recovery of DB2 Analytics Accelerator data now possible!”. In this portion, we cover some of the details of the backup process of data stored in an Accelerator. We will start with two main scenarios and differentiate when a backup of Accelerator data might be needed:

  • Data is loaded into an Accelerator from non-DB2 for z/OS sources and…

Added by Patric Becker on May 23, 2017 at 6:46am — No Comments

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

User Groups


  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service