Featured Blog Posts (57)

Create services for provisioning Db2 susystems (DBaaS) with the sample Db2 software services template

By Sueli Almeida and Paul McWilliams.

We recently published a sample Db2 software services template. As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2…

Continue

Added by Paul McWilliams on April 2, 2019 at 22:32 — No Comments

Enhancements to Insert Algorithm 2

Db2 for z/OS APAR PH02052 provides some significant enhancements to Insert Algorithm 2, which was introduced in Db2z 12 to provide faster INSERT throughput for unclustered INSERTs on universal table space objects that use the MEMBER CLUSTER option.

Read the full story here: https://ibm.biz/Bd2wDL




Always get the latest…

Continue

Added by Eric Radzinski on March 13, 2019 at 19:51 — No Comments

Video: Introduction to Db2 Utilities for z/OS

Got millennials?

It can be challenging to train a new generation of Db2 for z/OS users whose model of learning no longer includes days of reading long “manuals.” But they have energy, enthusiasm and lots of new ideas that you want to foster. Why not try teaching them with short videos?

Check out this Db2 Utilities video, specifically aimed at orienting someone who is new to Db2 for z/OS and knows little or nothing about Db2 Utilities.…

Continue

Added by Paul McWilliams on March 1, 2019 at 23:13 — No Comments

Want to help inform and shape the future of Db2 and Db2 tools?

Are you a user of systems…
Continue

Added by Katie Higgs on February 27, 2019 at 14:00 — 2 Comments

Announced today -- Innovations in IBM Db2 AI for z/OS! Learn More!

As the market manager of IBM Db2 for z/OS, I am really excited to share with you all some great news. Today IBM introduces new AI and machine learning capabilities with IBM Db2 AI for z/OS V1.2 - if you are at IBM THINK 2019 please can an visit us to learn more!…

Continue

Added by Surekha Parekh on February 12, 2019 at 13:30 — No Comments

Starting at 11 AM EST, 4PM GMT LIVE webcast 29th Jan with John Campbell

Starting at 11 AM EST, 4PM GMT LIVE webcast 29th Jan John Campbell - IBM Distinguished Engineer.

Title: JC's Greatest Hits, War Stories, and Best Practices Part 1

Date: 29th January 2019…

Continue

Added by Surekha Parekh on January 29, 2019 at 13:05 — No Comments

A reminder to convert pagesets for Db2 for z/OS objects to the 10-byte extended RBA and LRSN format

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert pagesets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit.…

Continue

Added by Paul McWilliams on January 8, 2019 at 19:20 — No Comments

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out the blog posts:

Continue

Added by Paul McWilliams on September 21, 2018 at 17:26 — No Comments

IBM announces IBM Db2 AI for z/OS TODAY! General Availability - September 21, 2018

IBM announces IBM Db2 AI for z/OS

General Availability - September 21, 2018

I'm very excited to let you know that today IBM Announced Db2 AI for z/OS. IBM Db2 AI for z/OS (Db2ZAI) empowers the Db2 for z/OS optimizer to…

Continue

Added by Surekha Parekh on September 11, 2018 at 15:52 — 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

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

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

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

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

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

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

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

Top Discussions 

User Groups

Videos

  • Add Videos
  • View All

IDUG Conference News

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service