All Blog Posts (283)

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

Continue

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

Announcement: Db2 Analytics Accelerator Version 7.1

Today, IBM announced a new version of the Db2 Analytics Accelerator, Version 7.1, which delivers the next generation of this game changing solution. It introduces new integrated, flexible deployment options on either the recently announced IBM Integrated Analytics System and/or directly on the new IBM Z mainframe. Both of these deployment options are based on IBM’s premier analytical engine, Db2 Warehouse software. This guarantees a uniform experience, which allows you to invest once in…

Continue

Added by Patricia Zakhar on October 17, 2017 at 12:46pm — 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…

Continue

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

Improved Db2 for z/OS CHECK LOB performance

By Haakon Roberts and Ann Hernandez…

Continue

Added by Ann Hernandez on October 11, 2017 at 2:49pm — 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…

Continue

Added by Ann Hernandez on October 10, 2017 at 1: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…

Continue

Added by Judy Tobias on October 2, 2017 at 1:23pm — No Comments

Join Live Stream of Db2 Tech Conference in Lisbon, Portugal!

Unable to attend the IDUG DB2 Tech Conference in Lisbon, Portugal this year? You can still experience featured session and Db2 Panels taking place at conference and ask questions live through uStream. Login to idug.org to join live stream, and engage with IBM strategists and developers, consultants and independent DB2 users remotely!



When: October 4, 2017

Time: Begins 11:00 AM WET ( GMT + 1hrs)

Where: Live Stream from Anywhere!

Cost: Complimentary for IDUG Members (Not… Continue

Added by Roland Schock on October 2, 2017 at 9:02am — No Comments

Join Live Stream of Db2 Tech Conference in Lisbon, Portugal!

Unable to attend the IDUG DB2 Tech Conference in Lisbon, Portugal this year? You can still experience featured session and Db2 Panels taking place at conference and ask questions live through uStream. Login to idug.org to join live stream, and engage with IBM strategists and developers, consultants and independent DB2 users remotely!



When: October 4, 2017

Time: Beings 11:00 AM WET ( GMT + 1hrs)

Where: Live Stream from Anywhere!

Cost: Complimentary for IDUG Members (Not… Continue

Added by Roland Schock on October 2, 2017 at 9:00am — 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…

Continue

Added by Paul McWilliams on September 28, 2017 at 5:00pm — 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.

Introduction

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

Continue

Added by Paul Kenney on September 21, 2017 at 5:40pm — 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…

Continue

Added by Surekha Parekh on September 20, 2017 at 9:31am — 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…

Continue

Added by Paul McWilliams on September 18, 2017 at 4:00pm — 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…

Continue

Added by Paul McWilliams on September 11, 2017 at 9:00am — 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…

Continue

Added by Sekowski Pawel on September 7, 2017 at 3:57pm — 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.

http://ibm.biz/db2zos-pain-points-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!

HOT OFF THE PRESS!  

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

GET IT ON iBooks or Google Play …

Continue

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…

Continue

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

PDUG - Polish DB2 User Group becomes the largest DB2 User Group in EMEA on World of DB2

PDUG  -  The Polish DB2 User Group becomes the largest DB2 User Group in EMEA on World of DB2…

Continue

Added by Surekha Parekh on June 13, 2017 at 9:30am — No Comments

Our Journey to DB2 Autonomics

Background

This blog entry describes the journey that we recently took at the Pennsylvania Department of Transportation (PennDOT) to modernize our DB2 utility environment.  Like all journeys, there were twists and turns along the way. But we knew that we had to find a better way of running our DB2 object maintenance utilities that would replace our existing inefficient…

Continue

Added by Perry Shindle on June 9, 2017 at 7:30pm — No Comments

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

Restoring data in an Accelerator

 

This is the third part of “Backup and Recovery of DB2 Analytics Accelerator data now possible”. In this section, we explore how data can be restored from a backup in one or more accelerators.

 

The backup itself is stored on z/OS, because the backup and recovery process for IBM DB2 Analytics Accelerator should be integrated as much as possible into existing backup and recovery processes on DB2 z/OS. A question that often arises…

Continue

Added by Patric Becker on June 7, 2017 at 8:29am — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

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

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service