All Blog Posts (331)

Function level V12R1M504 and e.g. archive tables

V12R1M504:

With APPLCOMPAT V12R1M504 on e.g. SPUFI or DSNTEP2, one can no longer create segmented or classic partitioned table spaces. See knowledge center for this restriction.

A small marginalia is behind this restriction, if this is combined with another…

Continue

Added by Peter Hartmann on July 19, 2019 at 9:57 — No Comments

RUNSTATS sampling enhancements

Introduction:

One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.



The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy…

Continue

Added by Peter Hartmann on July 17, 2019 at 10:38 — 1 Comment

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 — 5 Comments

Transferring ownership of Db2 objects in Db2 12

In Db2 12, you can transfer the ownership of database and system objects online if you are the owner of the object or have SECADM authority. You can use TRANSFER OWNERSHIP statements to transfer ownership of an objects to another authorization ID or a role, without any application changes.

For the full story on this new SQL capability, see the new Db2 12 GA feature series post, Transferring ownership of Db2…

Continue

Added by Paul McWilliams on July 12, 2019 at 22:38 — No 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

New blog post: PBR table spaces with relative page numbers - a Db2 12 Greatest hit

Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.



Read the full story in the Db2 for z/OS News from the Lab blog:

http://ibm.biz/BdzPr4…


Continue

Added by Paul McWilliams on June 12, 2019 at 19:30 — 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

Announcing a NEW IBM Redpaper: IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery

 IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery

An IBM Redpaper publication

 

Published: May 14, 2019 ISBN: 073845768x

Explore online at: http://www.redbooks.ibm.com/abstracts/redp5536.html?Open

Authors: Ute…

Continue

Added by Patricia Zakhar on May 22, 2019 at 14:47 — No Comments

New blog post: Simplified application compatibility for IBM Data Server Drivers and Db2 12 function levels

In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activating new application…

Continue

Added by Paul McWilliams on May 9, 2019 at 23:32 — No Comments

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

Unraveling the Mysteries of Insert Algorithm 2

Get some valuable insights on the uses and benefits of insert algorithm 2, including how-to information for monitoring and troubleshooting this performance feature.

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

Added by Eric Radzinski on March 26, 2019 at 0:22 — 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

Announcing Db2 12 function level 504

We're proud to announce Db2 12 function level 504!



Function level 504 (activation enabled by APAR PH07672) introduces the following new capabilities in Db2 12 for…

Continue

Added by Paul McWilliams on March 6, 2019 at 18:26 — 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

Monthly Archives

2019

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

RUNSTATS sampling enhancements

Posted by Peter Hartmann on July 17, 2019 at 10:38 1 Comment

Introduction:

One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the…

Continue

Videos

  • Add Videos
  • View All

IDUG Conference News

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

IBM System Magazine

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service