All Blog Posts (301)

Db2 for z/OS monitoring: Evaluating deadlock and timeout events on the Enhanced 3270 UI

New features are being continuously added to the OMEGAMON for Db2 Performance Expert Enhanced 3270 User Interface.  A continued investment in the 3270 UI demonstrates a commitment to synergy and integration with the entire OMEGAMON family of products. This blog describes the latest feature introduced through the version 5.4.0 service stream.

Introduction

Deadlocks and timeouts are a fairly routine occurrence in Db2 as applications…

Continue

Added by Paul Kenney on August 10, 2018 at 22:28 — No Comments

Enhanced SQL MERGE—a Db2 12 greatest hit with John Campbell

Back in Version 9, Db2 for z/OS introduced minimal support for MERGE statementst, only providing an upsert capability with limited functionality. Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016 Core standard, as…

Continue

Added by Paul McWilliams on August 1, 2018 at 22:51 — No Comments

Db2 for z/OS Master Classes

The first Db2 for z/OS Master Class to be hosted by IBM Europe was recently held at IBM Hursley. The next invitation-only session at IBM Silicon Valley Laboratory is already full, but future session are planned.  For the full story, see Db2 for z/OS Master Classes.


Always get the latest news about  Db2 for z/OS from the IBM lab!…

Continue

Added by Paul McWilliams on July 18, 2018 at 16:53 — No Comments

Register for IDUG EMEA Db2 Tech Conference 2018 - Join IDUG's 30th Anniversary Celebrations

Register Now for IDUG Malta 2018 Early Bird Discount Available

and join IDUG's 30th Anniversary celebrations !

http://bit.ly/IDUGMalta2018

#Db2 #Analytics #Cloud #ML #DataScience #Db2z #IDUGDb2 #IDUG30 …

Continue

Added by Erwin Hattingh on May 30, 2018 at 16:00 — No Comments

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in New SQL pagination syntax - a Db2 12 greatest hit with John…

Continue

Added by Paul McWilliams on May 22, 2018 at 21:25 — No Comments

Fast index traversal - a Db2 12 greatest hit with John Campbell

Fast index traversal is one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal.…

Continue

Added by Paul McWilliams on May 8, 2018 at 17:53 — No Comments

Db2 12 function level 502 now available with z/OS data set encryption support and more

We're proud to announce that Db2 for 12 for z/OS function level 502 is now available!

Function level 502 introduces support for new policy controls in Db2 12 for…

Continue

Added by Paul McWilliams on April 30, 2018 at 21:30 — No Comments

IDUG EMEA Db2 Tech Conference , Bring A Friend !

Register and BRING A FRIEND , and get 60% discount for …
Continue

Added by Erwin Hattingh on April 27, 2018 at 13:09 — No Comments

Hot off the Press - Db2 for z/OS Continuous Delivery Redbook by Chris Crone - IBM DE

Hot off the Press - Db2 for z/OS Continuous Delivery Redbook

by Chris Crone - IBM DE

Abstract

This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery,…

Continue

Added by Surekha Parekh on April 24, 2018 at 18:49 — 1 Comment

How I became a Db2 for z/OS DBA... OVERNIGHT!

I imagine my story is not entirely uncommon, but it is certainly unique to me. I was a SQL Server DBA for 7 years at Southern Farm Bureau Life Insurance, when a sudden personnel change led me to becoming our company’s new Db2 for z/OS DBA, (in addition to my role as the SQL Server DBA) literally overnight.   Because I had database experience, management thought this made sense and would not be out of my realm of knowledge or comfort.  Anyone working with Db2, z/OS, knows there is so much…

Continue

Added by Brandon Hodges on April 2, 2018 at 13:46 — No Comments

Attention All Db2 User Groups Leaders!

IBM and IDUG will again be raffling off complimentary IDUG Conference Passes to the 2018 IDUG Tech Conference in Philadelphia, PA during the week of April 29 - May 3.

If your user group is a Virtual Group on the…

Continue

Added by Judy H. Nall on March 23, 2018 at 13:00 — No Comments

Congratulations to Polish Db2 User Group - Great Job!

Thank you "@DB2_PDUG for recognizing #IBM's sponsorship, great #Db2 User Group growing from strength to strength  over 100+ members on World of Db2…
Continue

Added by Surekha Parekh on March 21, 2018 at 12:37 — 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…
Continue

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

IDUG DB2 Data and Analytics Technical Summit in Bengaluru, India March 27th, 2018

Announcing the 2018 IDUG Bengaluru 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 technology.…

Continue

Added by Sandy Flippen on March 16, 2018 at 18:00 — No Comments

Job Opportunity - Toronto (Scarborough) Area - DB2 DBA on Mainframe z/os

Hello Everybody,

My name is Brian and I’m with Keen Technology Consulting Inc. I wanted to share details of a DB2 DBA opportunity with a great client in Scarborough in the Greater Toronto Area in Ontario, Canada.

Anyone interested, please feel free to reach me at bdavies@keenconsulting.com or 416-536-5336 x 229.

Thanks!

Brian

Role: Database Administrator with focus on DB/2 and mainframe…

Continue

Added by Brian Davies on March 2, 2018 at 19:47 — No Comments

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…

Continue

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

Don't miss webcast on how to modernize mainframe development processes

Join Haakon Roberts, IBM DE, on Tuesday February 27th at 11:00 AM EST to learn more about how mainframe customers are updating their application development processes while continuing to leverage mainframe strengths that are vital to their business.
REGISTER ONLINE NOW AT http://bit.ly/Db2_DEVOPS

Added by Calene Janacek on February 23, 2018 at 17:41 — 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…

Continue

Added by Surekha Parekh on February 19, 2018 at 13:12 — 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. …

Continue

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

Monthly Archives

2018

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.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…

Continue

Videos

  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service