Carol Davis-Mann's Blog (39)

Management Overview: DB2 Continuous Delivery Function Level Upgrades

By Julian Stuhler

Background

With the advent of DB2 12 for z/OS, IBM has moved to a more agile approach for delivering new function to DB2 customers, known as “continuous delivery”. Major new releases of DB2 will now happen more rarely, with smaller packets of new functionality being delivered via the routine product maintenance process. This allows IBM to develop and release new features much more frequently, thereby reducing “time to value” –…

Continue

Added by Carol Davis-Mann on July 14, 2021 at 11:08 — No Comments

Ansible on z/OS – 3 – Getting Started With Ansible

Introduction

In the previous blogs in this series, we’ve run through installing IBM Open Enterprise Python for z/OS and …

Continue

Added by Carol Davis-Mann on June 11, 2021 at 9:31 — No Comments

Around the World with Triton’s Digital Duo

As the world mourns the loss of the digital dance duo Daft Punk, Triton Consulting is sending its very own duo of digital pioneers Mark Gillis and Damir Wilder around the world – virtually.

IBM Champions Mark and Damir were delighted to get the call that they had been selected to present at IDUG Australasia and IDUG North America Tech Conferences.

Eagerly…

Continue

Added by Carol Davis-Mann on March 4, 2021 at 15:58 — No Comments

DB2 12 for z/OS, DRDA Applications and Application Compatibility Part Two

In DB2 12 for z/OS, DRDA Applications and Application Compatibility Part Two Gareth Copplestone-Jones provides guidance on the implementation of server-side configuration.

Server-side configuration

When considering how to manage managing Application Compatibility – APPLCOMPAT – for your distributed applications which…

Continue

Added by Carol Davis-Mann on February 24, 2021 at 17:29 — No Comments

DB2 12 for z/OS, DRDA Applications and Application Compatibility Part One

Introduction

This, the first of two articles on how to manage the Application Compatibility level for DRDA applications, provides an introduction to the subject and considers two of the ways of doing this. In the second article Gareth Copplestone-Jones will concentrate on perhaps the most promising method and discusses its drawbacks.

A very brief history of Application…

Continue

Added by Carol Davis-Mann on February 17, 2021 at 17:02 — No Comments

DB2 v11.5.4 REST API – Part One Setup and Configuration

By James Cockayne

Enabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases.  In this series we look at how to get started with the REST API from the DBA’s perspective, starting in part one with how to…

Continue

Added by Carol Davis-Mann on November 18, 2020 at 15:25 — No Comments

The final instalment - DB2 for z/OS Locking for Application Developers Part 10

This is the last article in the series by Gareth Copplestone-Jones on locking for developers, and is a wrap up of miscellaneous points arising from previous articles.

 

Row level locking

The first item under discussion is…

Continue

Added by Carol Davis-Mann on October 1, 2020 at 9:15 — No Comments

DB2 for z/OS Locking for Application Developers Part 9

In this ninth article in the series on DB2 Locking for Application Developers, which provides information about coding your application not only for data integrity, which is the principle focus of this series of articles, but also for performance and concurrency, taking into account the transaction isolation levels in effect at run time. Background information…

Continue

Added by Carol Davis-Mann on October 1, 2020 at 9:03 — No Comments

Consolidation of DB2 Editions – simplicity is the key

In the first in Triton Consulting's series of blogs on the latest DB2 release Iqbal Goralwalla takes a look at Consolidation of DB2 Editions.

Consolidation of DB2 Editions – simplicity is the key

One of the highlights in DB2 11.5 for me was the simplification of the plethora of editions. From 13 editions and several…

Continue

Added by Carol Davis-Mann on July 31, 2020 at 11:00 — No Comments

Integrating DB2 on Docker with Jupyter Notebooks

By James Cockayne

Jupyter notebooks are a popular way to query DB2 databases.  The ease of use to set up a notebook and run complex queries with rich visualisations make them ideal for quickly demonstrating concepts and data trends.  As the notebooks run Python code, this gives us the opportunity to use another tool useful for spinning up demonstration environments – Docker.  To do this we use the Docker SDK for Python – in this blog we look at how to spin…

Continue

Added by Carol Davis-Mann on July 3, 2020 at 15:18 — No Comments

DB2 for z/OS Locking for Application Developers Part 8

Welcome to part eight of this blog series on DB2 Locking for Application Developers, which is about considerations for coding your application not only for data integrity (the main focus of this series of articles), but also for performance and concurrency, taking into account the transaction isolation levels in effect…

Continue

Added by Carol Davis-Mann on June 12, 2020 at 15:02 — No Comments

DB2 for z/OS Locking for Application Developers Part 7

By Gareth Copplestone-Jones, Triton Consulting

This is the seventh article in the series on DB2 Locking for Application Developers. So far we’ve covered a lot of topics, including the ACID database transaction properties, lock size, lock mode and lock duration, transaction isolation levels and data…

Continue

Added by Carol Davis-Mann on May 20, 2020 at 15:09 — No Comments

DB2 for z/OS Locking for Application Developers Part 6

This is the sixth article in the series on DB2 for z/OS Locking for Application Developers. The primary focus of this series is to help DB2 for z/OS application developers to guarantee data integrity while optimising for performance by designing and coding applications which take into account the following : the ACID properties of database transactions; lock…

Continue

Added by Carol Davis-Mann on April 24, 2020 at 15:22 — No Comments

DB2 for z/OS Locking for Application Developers Part 5

Welcome to this, the fifth in the series on DB2 Locking for Application Developers. So far, we’ve covered a lot of ground, including the ACID properties of database transaction, the locking semantics implemented by DB2 – lock size, lock mode and lock duration – and issues such as lock contention and lock escalation, all with a…

Continue

Added by Carol Davis-Mann on April 9, 2020 at 14:45 — No Comments

DB2 for z/OS Locking for Application Developers Part 4

This is the fourth article in the series on locking for DB2 for z/OS developers. To summarize the main thrust of this series of articles, data integrity and application performance are dependent on application programs being designed and coded to take into account the locking strategy used by the DBMS. Following on from the previous articles, this one wraps up the…

Continue

Added by Carol Davis-Mann on March 27, 2020 at 17:18 — No Comments

DB2 for z/OS Locking for Application Developers Part 3

By Gareth Copplestone-Jones, Triton Consulting

This is the third article in the series on locking for DB2 for z/OS developers. To recap, data integrity and application performance are dependent on application programs being designed and coded to take into account the locking…

Continue

Added by Carol Davis-Mann on March 4, 2020 at 14:59 — No Comments

DB2 for z/OS Locking for Application Developers Part 2

By Gareth Copplestone-Jones, Triton Consulting

As we saw in the previous article, (DB2 for z/OS Locking for Application Developers Part 1) the ACID properties of database transactions (atomicity, consistency, isolation and durability) are intended to guarantee data integrity. It’s important to emphasize that data integrity is a joint…

Continue

Added by Carol Davis-Mann on February 4, 2020 at 14:37 — No Comments

DB2 for z/OS Locking for Application Developers Part 1

By Gareth Copplestone-Jones, Triton Consulting

This DB2 for z/OS Locking blog series is mostly targeted at DB2 for z/OS application developers, but is also appropriate for application designers, database administrators, DB2 systems programmers and other DB2 professionals who are concerned with data integrity and application performance. 

You might ask, what’s that got to do with locking? It’s all too easy to assume that locking just happens and that you don’t…

Continue

Added by Carol Davis-Mann on January 15, 2020 at 12:34 — No Comments

IDUG EMEA 2014 - Day 1

 

By Julian Stuhler

 

So, that’s another IDUG EMEA conference opening day in the history books – my 16th since I attended my first conference in Barcelona back in 1997. I actually arrived in Prague yesterday morning after a VERY early flight from the UK. That gave me a few hours to re-acquaint myself with the Clarion Congress Hotel (IDUG was at the same hotel 3 years ago) and enjoy my first Staropramen of…

Continue

Added by Carol Davis-Mann on November 10, 2014 at 16:46 — No Comments

Join Triton at IDUG EMEA and get social with the DB2 Geek

 

With just under three weeks to go until the IDUG EMEA 2014 Technical Conference in Prague the Triton team is busy finalising arrangements for this year’s drinks reception. There will be a very familiar face awaiting your arrival this year. The one and only DB2 Geek will be making an appearance and not in the form of a stress toy! Just remember to smile and say “cheese” when you see him. We would then love you to share your DB2 Geek photos on Twitter using the hashtag #DB2Geek. You…

Continue

Added by Carol Davis-Mann on October 21, 2014 at 15:09 — No Comments

Events

Latest Activity

Jim Reed updated an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 22, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Wednesday
Carol Davis-Mann posted a blog post

Management Overview: DB2 Continuous Delivery Function Level Upgrades

By Julian StuhlerBackgroundWith the advent of DB2 12 for z/OS, IBM has moved to a more agile approach for delivering new function to DB2 customers, known as “continuous delivery”. Major new releases of DB2 will now happen more rarely, with smaller packets of new functionality being delivered via the routine product maintenance process. This allows IBM to develop and release new features much more frequently, thereby reducing “time to value” – a familiar DevOps message.To allow DB2 customers to absorb this new function in a flexible and efficient way, IBM has also delivered a comprehensive set of capabilities that allow the “function level” of the overall DB2 system to be easily progressed while insulating individual applications from the impact of any changes via the “application compatibility level” set for each program.Read Julian Stuhler's article…See More
Jul 14
Jim Reed posted an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 20, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Jul 14
A video by Surekha Parekh was featured

Db2 AI for z/OS Version 1.4

IBM Db2 AI for z/OS version 1.4 is a powerhouse of enhancements! Db2 AI for z/OS infuses more AI into your Db2 environment, making it operate smarter and mor...
Jul 5
A blog post by Daniel Luksetich was featured

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
Daniel Luksetich posted a blog post

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
Jun 23
A blog post by Surekha Parekh was featured

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!HURRY SIGN UP TIME IS HURRYING OUTSummaryDb2 for z/OS is the strategic enterprise database that has evolved and adapted to meet client needs for over 35 years. John Campbell IBM Distinguished Engineer has been one of key developers from IBM Silicon Valley Lab that has been extremely influential in driving some of the innovation around the core strengths and business value of Db2 for z/OS.We are bringing together some of our Db2 for z/OS clients so that they can share some of their "use cases" and experiences around Db2 12 upgrade journey and discuss how they are exploiting, planning to exploit the new technology to leverage  their Db2 for z/OS data to…See More
Jun 22
Daniel Luksetich posted a blog post

Traditional Db2 Development and Modern Database Development

This article is the first of a four-part series addressing Db2 for z/OS and modern development utilizing a Agile methodology and DevOps processes. In this article we define traditional versus modern development and how Db2 for z/OS, while remaining the premier database for high volume system of record applications, might be left behind when it comes to best practices involving innovation. Did you notice that “Db2” follows “Traditional” in the title of this article, but “Database” follows “Modern”? It is my opinion that Db2 for z/OS is not the first database that comes to mind when considering a DevOps development methodology. However, there is no reason why it shouldn’t be!The first thing we need to do is to identify what we mean by traditional versus modern development. In this series of articles, we will be speaking specifically of the waterfall methodology versus an Agile methodology and DevOps practices.To read the entire article please follow this link:…See More
Jun 21
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Jun 21
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 21
edmundo nascimento liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 21

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

Forum

ADM10501W - Health indicator "Database Automatic Storage Utilization"

Started by ONLO in Application Development and DB2 Jun 16. 0 Replies

AIX Version 6.1DB2 10.5.6Hi every body,I got the above error:MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization" ("db.auto_storage_util") breached the "upper" warning threshold of "80 %" with value "88 %" on "database"…Continue

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service