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…

Continue

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.

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

Continue

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…

Continue

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…

Continue

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…

Continue

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

Monthly Archives

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Latest Activity

William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
yesterday
A blog post by Surekha Parekh was featured
Tuesday
Daniel Luksetich posted a blog post
Monday
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Monday
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
edmundo nascimento liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
Michael Tiefenbacher posted an event
Thumbnail

30. DeDUG User Group Meeting at virtual

September 24, 2021 from 9am to 1:30pm
Monday
Earl Dugan posted an event

Virtual New England DB2 User's Group Thursday, June 24th, 2021. at Virtual Meeting

June 24, 2021 from 9am to 12pm
Monday
Willy Unger liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Saturday
carol goldberg liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
Adrian Collett liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
ONLO posted a discussion
Jun 16
GABRIEL FAJARDO liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 15
Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 14
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
Jun 14
Carol Davis-Mann posted a blog post
Jun 11

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

Forum

ADM10501W - Health indicator "Database Automatic Storage Utilization"

Started by ONLO in Application Development and DB2 Jun 16. 0 Replies

AIX Version 6.1DB2 10.5.6Hi every body,I got the above error:MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization" ("db.auto_storage_util") breached the "upper" warning threshold of "80 %" with value "88 %" on "database"…Continue

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service