All Blog Posts (379)

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

Build Your Hybrid Cloud Skills with Db2 Community Edition and Openshift

There has been much interest in database containerization and their movement to Hybrid cloud. The promise of such a move is that it will provide a hybrid cloud database services with the benefits of simplicity of deployment, uniformity in management, simplified availability and the elasticity modern databases require.

Many database solutions have simply been created in the image of their standard operating system installation for the database platforms or deployed in such an…

Continue

Added by Phil Downey on May 20, 2020 at 5:43 — No Comments

Db2 11 for z/OS End of Service (EOS) data has changed

The end of service (EOS) for Db2 11 for z/OS is now changed to March 31, 2021. For the details, See Mo's recent News from the Lab blog entry.


To always get the latest news about Db2 for z/OS from the IBM lab, sign in and subscribe at:…

Continue

Added by Paul McWilliams on May 15, 2020 at 22:16 — No Comments

TODAY Data and AI on IBM Z Virtual Conference - Starting 19th May 2020! SIGN UP

Time is running out  - sign up now!  Enterprise Data and AI on IBM Z Virtual Symposium.

Check out the agenda, topics and speaker bios we have a line up of the best speakers in the industry

Learn More…

Continue

Added by Surekha Parekh on May 15, 2020 at 13:00 — No Comments

Reduce the cost of mission critical workloads. Drive greater value from IBM Z.

IBM Db2 for z/OS Data Gate offers ready access to Db2 for z/OS data without accessing Db2 for z/OS.

Reduce the cost of mission critical workloads. Simplify data delivery for new cloud, analytics and mobile applications with improved data currency. Drive greater value from IBM Z.

 

IBM Db2 Data Gate provides an integrated, resilient, standardized approach, designed to be more reliable, less complex and less expensive than customized solutions. It supports…

Continue

Added by Jonathan Sloan on May 15, 2020 at 1:36 — No Comments

Faster analytics and AI application development from IBM Z data

IBM Z is the core transaction platform for many IBM enterprise customers. IBM Cloud Pak for Data is IBM’s strategic platform for analytics and AI. It is a fully integrated data and AI platform that modernizes how businesses collect, organize and analyze data and infuse AI throughout their organizations. But what if you want to build analytics and AI applications from your IBM Z data? Are these technologies integrated, and if so, how?

 

Tom Ramey, Director IBM Z Analytics, will…

Continue

Added by Jonathan Sloan on May 15, 2020 at 1:12 — No Comments

Delivering Faster Business Value with Your Mainframe Investment

Does your organization still separate systems of record from modern systems of engagement? Do you use the standard architectural pattern of replicating data from its point of origin? You probably know actions based on replicated data can never be truly real time and can be sub-optimal. Leveraging data virtualization technology can support greater flexibility and agility which is core to modernization efforts.

 

Data virtualization has emerged as an exciting, cost effective,…

Continue

Added by Jonathan Sloan on May 14, 2020 at 17:27 — No Comments

Register for DB2 for z/OS technical sessions at Data & AI on IBM Z Technical Symposium

Register for DB2 for z/OS technical sessions at Data & AI on IBM Z Technical Symposium

IBM will be hosting this complimentary virtual event to learn how you can use IBM Z data for modern engagement, analytics and AI applications to become truly insights-driven. We have 3 great Db2 for z/OS sessions.…

Continue

Added by Surekha Parekh on April 24, 2020 at 17:30 — 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

Don’t miss out! Analytics/AI spotlighted at the Virtual Symposium for IBM Z Customers

By Patricia Zakhar and Annette Zawacki

IBM is committed to helping its customers become insights-driven and to differentiate their businesses by maximizing the value of their IBM Z data and resources.

 

To support this effort, IBM is bringing Z clients together for a three-day Enterprise Data and AI on IBM Z Virtual Symposium. During this event, IBM’s most progressive…

Continue

Added by Annette Zawacki on April 23, 2020 at 16:00 — No Comments

Virtual Db2 for z/OS Master Classes are now offered for 2020

By Dorothy Lin and Paul McWilliams.

Db2 for z/OS development is now offering two Db2 for z/OS Master Class sessions for 2020—previously scheduled  at IBM Hursely and IBM Silicon Valley Laboratory—as virtual courses.…
Continue

Added by Paul McWilliams on April 21, 2020 at 17:30 — 2 Comments

AUTOBIND - Demystified - 2

Introduction:

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

Recently there are 2 enhancements in this area. For the first enhancement refer to my blog post.

The second enhancement is described in this blog post and was introduced by…

Continue

Added by Peter Hartmann on April 17, 2020 at 7:38 — No Comments

GO Application and Db2 for z/OS REST services

A few days after I posted my first GO article (Quick Start in accessing Db2 for z/OS from a GO application), customers start to ask me for alternative since they don't want to use CLIdriver. Other option is to use Db2 native REST service. In the following article, I show how to do this step by step.…

Continue

Added by Jane Man on April 14, 2020 at 21:33 — 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

Quick Start in accessing Db2 for z/OS from a GO application

GO/GoLang is an open source programming language that is getting popular in the recent years because of its performance, memory usage, built-in concurrency mechanism, and powerful libraries, etc.

In my following blog, I am going to show you how to to connect to Db2 for z/OS in…

Continue

Added by Jane Man on April 2, 2020 at 0:53 — 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

UDF for Regular Expressions in Db2 12 for z/OS without IDAA

Introduction:

I read the great article "Pattern matching using regular expression in DB2?" by Jane Man

(https://www.worldofdb2.com/profiles/blogs/pattern-matching-using-regular-expression-in-db2).

In essence, she used the built-in XPath function fn:matches which handles regular expressions…

Continue

Added by Walter Huth on February 14, 2020 at 9:59 — No Comments

Make Non-Relational Mainframe Data accesible to Modern Analytics Applications

Extending the Value of Mainframe Data

 The vast majority of Fortune 500 companies hold large amounts of critical business data on the mainframe.  Much of this may be stored in relational structures on Db2 for z/OS.  However, there is also a wealth of data stored on non-relational mainframe data sources such as Adabas, IMS, IDMS, VSAM,  and flat files.   Take as an example a bank ATM application, or airline reservation system which may be IMS based.  IMS being a hierarchical vs.…

Continue

Added by Jim Wankowski on February 4, 2020 at 16:00 — 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

Monthly Archives

2020

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

5 Ways to Manage Stressful Situations

Started by ashley gill in What's hot ? May 10. 0 Replies

Stress is a common feeling that every human being experiences. As we all know from experience, stress can impact our life negatively and it should, therefore, be dealt with properly. Stress may be unavoidable but how it is handled is our choice.…Continue

Tags: training, corporate

Conversion of BLOB to String/ Text

Started by Jitesh Audichya in Application Development and DB2. Last reply by Jitesh Audichya Apr 24. 2 Replies

Hi All,Problem Statement:I have a field with BLOB data type in DB2 database, I want to extract this blob and convert it to Text. The text data after the conversion will be in Japanese characters. How can I write a select with the conversion from…Continue

Tags: on, DB2, conversion, text, to

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service