Featured Blog Posts (61)

Retrieval of current DSNZPARM and DSNHDECP settings

History:

With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and the…

Continue

Added by Peter Hartmann on July 16, 2019 at 8:04 — 2 Comments

Asynchronous cross-invalidation (XI) for coupling facility (CF) cache structures, e.g. Db2 for z/OS group buffer pools (GBP)

Description of the new feature:

When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s). This invalidation is done by the cross invalidation (XI) feature which is a key functionality of data sharing and controlled by coupling facility…

Continue

Added by Peter Hartmann on July 12, 2019 at 7:57 — No Comments

Announcing Db2 12 function level 505!

We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply…

Continue

Added by Paul McWilliams on June 26, 2019 at 18:41 — No Comments

IDUG NA 2019 in Charlotte: RUG Leaders Luncheon on Tue, 4th, June.

IDUG are pleased to once again invite all Db2 Regional User Group (RUG) leaders attending the IDUG conference in Charlotte to join us for a RUG Leaders Luncheon on Tuesday, June 4, 2019, 11:40 AM - 12:40 PM, Craft City Social Club, Charlotte Sheraton.

This is a chance to connect with fellow Db2 RUG leaders while you learn about news and updates from IDUG and IBM. 

The objectives of this session…

Continue

Added by Manuel Gomez Burriel on May 30, 2019 at 7:23 — 1 Comment

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 select improved access paths for SQL and improves application…

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 World of DB2, then your User…

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 abstracts.

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

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

User Groups

Blog Posts

Retrieval of current DSNZPARM and DSNHDECP settings

Posted by Peter Hartmann on July 16, 2019 at 8:04 2 Comments

History:

With DB2 Version 9.1 for z/OS a new system supplied stored procedure…

Continue

Videos

  • Add Videos
  • View All

IDUG Conference News

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

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service