Featured Blog Posts (76)

Call for speaker closes 18th January! IDUG Db2 Data and Al Technical in Chennai, India 2020

Latest Updates

Continue

Added by Surekha Parekh on January 13, 2020 at 16:22 — No Comments

Call for speaker closes 18th January! IDUG Db2 Data and Al Technical in Bengaluru, India 2020

Latest Updates

  • Call for Presentations is OPEN
  • Registration is …
Continue

Added by Zeljen Stanic on January 13, 2020 at 16:17 — No Comments

2020 Db2 User Group Events - Please add to World of Db2 Calendar

Dear Db2 User Group leaders and extended community

If you manage or are involved  with Db2 User Groups or Db2 for z/OS event planning, IBM are working on our 2020 plans and speaker support.

Please can you add your 2020 Db2 User Group events on the World of Db2 so that we can review your requirements and plan in advance speaker support. In collaboration with IDUG Db2 User Community we will also offer User Groups a complimentary IDUG Conference Pass for you to…

Continue

Added by Surekha Parekh on December 16, 2019 at 15:03 — No Comments

Db2 for z/OS support of z15 and z/OS 2.4

Toleration:

Is maintenance needed in Db2 for z/OS (V11 or V12) for a migration to

- the current hardware z15

- or the current operating system z/OS 2.4 ?

As of today there are no APARs/PTFs needed to tolerate such a migration.

Exploitation:

The following…

Continue

Added by Peter Hartmann on November 19, 2019 at 7:55 — 2 Comments

The Db2 for z/OS News from the Lab blog has moved!

Perhaps you've seen news about the sunset of the IBM developerWorks community platform at the end of 2019. I am happy that I can now share how you can continue following the latest news from the IBM experts who design, build, test, and support Db2 for z/OS, here in the new Db2 for z/OS Community.



Don't miss any Db2 for z/OS News from the Lab blog entries. Join the new community and subscribe today! For the full story, see:…

Continue

Added by Paul McWilliams on December 11, 2019 at 23:49 — No Comments

LAST Db2 for z/OS webcast series in 2019 by John Campbell! REGISTER NOW!

LAST Db2 for z/OS webcast series in 2019 by John Campbell! REGISTER NOW!

Title: Strategies of Managing Universal Table Spaces (UTS) for Optimal Performance

PART 1. Date: Tuesday, November 12, 2019

http://ibm.biz/BdzaRx

PART 2  REGISTER NOW Wednesday November 13th 2019…

Continue

Added by Surekha Parekh on November 1, 2019 at 12:02 — No Comments

Get hands-on with Data and AI on IBM Z Technology

  • Do you want to try out software when it is convenient for you?
  • Would you like to do some initial learning about a technology before engaging with a sales person?
  • Would you like to some initial get hands on experience with a product without having to download or install…
Continue

Added by Jim Wankowski on September 5, 2019 at 15:18 — No Comments

Db2 and JCL 72 characters

Introduction:

Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another. If the result row fits into one JCL line with a length of 72, then all is fine. If the line must be split, then the question comes up: How to split?

Here is a solution for commands (like REBIND PACKAGE), SQL (like ALTER TRIGGER) or…

Continue

Added by Peter Hartmann on August 28, 2019 at 18:39 — 1 Comment

Is there a future for Analytics on IBM Z ? - Machine Learning on z/OS

This blog is part of a multi blogs story published by Aymeric Affouard, Guillaume Arnould, Khadija Souissi and Leif…

Continue

Added by Guillaume ARNOULD on September 9, 2019 at 8:20 — No Comments

Is there a future for Analytics on IBM Z: BM Db2 Analytics Accelerator

This blog is part of a blog series around Analytics on IBM Z and has been created by 

Leif PedersenAymeric AffouardGuillaume Arnould and…

Continue

Added by Khadija Souissi on September 10, 2019 at 8:43 — No Comments

Is there a future for Analytics on IBM Z?

In a series of blogs, written by Aymeric AffouardGuillaume ArnouldKhadija Souissi and Leif…

Continue

Added by Leif Pedersen on September 9, 2019 at 8:15 — No Comments

Leveraging your Db2 Skills with Big Data

The Challenge

The idea of the traditional data center being centered on relational database technology is quickly evolving.  Many new data sources exist today that did not exist as little as 5 years ago.  Devices such as active machine sensors on machinery, autos and aircraft, medical sensors, RFIDs as well as social media, and web click through activity are creating tremendous volumes of mostly unstructured data which cannot be…

Continue

Added by Jim Wankowski on September 4, 2019 at 19:30 — No Comments

AUTOBIND – Demystified – 1

Introduction:

AUTOBIND is a very useful automation instrument inside the Db2 engine.

Suppose you change the definition of the table or index and these changes have impact on the dependent package, the static SQL package is marked as invalid,…

Continue

Added by Peter Hartmann on August 20, 2019 at 19:29 — 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 — 6 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

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

Forum

z/OS DB2 V11 to V12 and CICS?

Started by Tom Burkholder in What's hot ? on Friday. 0 Replies

Hello DB2 users...I apologize in advance if this is not the place to post this question; however, I thought I would sign up and give it a try.  My background is with systems support and middleware (z/OS, MQ, WebSphere, distributed DB2 jdbc configs)…Continue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service