All Blog Posts (350)

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

Do you set Db2 application performance thresholds?

Performance thresholds are not a new concept.  They’re easy to understand in principle, but why do people avoid using them?  Some users believe that performance thresholds can cause you to react to a quick fix and often make performance worse than when you started.  If you’re setting Db2 performance thresholds based on changing application conditions, you are trying to anticipate what is normal and adjust from that.  Maybe you ignore using thresholds because they can’t detect the anomalies…

Continue

Added by Calene Janacek on November 14, 2019 at 17:46 — 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

Leverage Kubeflow for Enterprise data in Db2 for z/OS

Kubeflow is known as “Machine Learning toolkits for Kubernetes”. It is an open source project dedicated to making deployments of machine learning (ML) workflows on Kubernetes simple, portable and scalable. Kubeflow Pipelines is one of Kubeflow key components which provides a platform for building, deploying, and managing multi-step workflows on Kubernetes (based on Docker containers).…

Continue

Added by Jane Man on October 11, 2019 at 16:29 — No Comments

REGISTER NOW - Complimentary workshop at IDUG EMEA 2019 in Rotterdam Db2 12 Migration

When:Sunday, Oct 20, 2019…

Continue

Added by Surekha Parekh on September 24, 2019 at 13:36 — No Comments

Db2 12 for z/OS  Technology Workshop - Migration Planning

Db2 12 for z/OS  Technology Workshop - Migration Planning 



Michael Dewert and Gareth Copplestone-Jones

When:Sunday, Oct 20, 2019 09:30 to 17:00

Where: TBD

Price: FREE

LIMITED PLACES…

Continue

Added by Sandy Flippen on September 10, 2019 at 20: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

Modernizing Applications by using API’s

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

Continue

Added by Aymeric Affouard on September 9, 2019 at 8:20 — No Comments

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 ? - Operational Decison Manager

This blog is the 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:19 — 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

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

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

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

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

IDUG Db2 Seminars in Sao Paulo (Brazil) and México DF (México)

When I joined IDUG as a volunteer a few years ago I was surprised that IDUG were not providing any Db2 education in Latin Amercia. The majority of the events and user group activities were concentrated  in North America, Europe and Australia.

As a naive Spanish speaker I had a vision to extend IDUG into Latin Amercia. I am please to inform you that IDUG are hosting two events in Latin Amercia this…

Continue

Added by Manuel Gomez Burriel on August 17, 2019 at 18:08 — No Comments

APPLCOMPAT and Advanced Triggers

If you think you know all about APPLCOMPAT, then please read this!

Introduction:

Advanced triggers introduced in V12 allow SQL PL statements and this opens “SQL only applications” to triggers. There is reduced need to call a stored procedure,…

Continue

Added by Peter Hartmann on August 7, 2019 at 11:13 — No Comments

Group Buffer Pool - Changes by PH13045

Level setting:

A Db2 group buffer pool (GBP) consist of two parts:

1) Directory entries

2) Data entries

For each data entry there must be an associated directory entry in the GBP.

A directory entry can exist without a data entry in the…

Continue

Added by Peter Hartmann on July 30, 2019 at 12:27 — 2 Comments

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 — 1 Comment

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.

Forum

Db2 for z/OS Master class with John Campbell and the SWAT team returns!

Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply

Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue

Tags: Events, MasterClass, JohnCampbell

RBS Shares their Db2 Utilities Experiences

Started by Calene Janacek in What's hot ? Oct 22. 0 Replies

Join Mark Turner, Lead Mainframe Architect and Strategist from RBS and Haakon Roberts, IBM DE as they share Royal Bank of…Continue

Tags: #Db2

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service