All Blog Posts (414)

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 Advanced 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 Advanced Class sessions for 2020—previously scheduled  at IBM Hursely and IBM Silicon Valley Laboratory—as virtual…
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

Reminder Db2 11 End of Service 30th Sept - Plan your Db2 12 upgrade live webcast with clients!

Live Db2 12 Migration Planning Webcast followed by Customer Q&A Panel   

Guest Speakers:- Ute Kleyensteuber - Commerzbank  and Howard Paxton - HSBC

Dates: 26th & 27th February 2020



Remember IBM has announced…

Continue

Added by Surekha Parekh on February 1, 2020 at 14:52 — No Comments

Db2 for z/OS Advanced Class sessions for 2020 are now scheduled

Update: Due to the global pandemic and resulting travel restrictions, this course is now offered as a virtual online course, and the cost to attend is also reduced to $2000. For more information, see the…
Continue

Added by Paul McWilliams on January 23, 2020 at 19:30 — No Comments

Creating a Db2 for z/OS REST service to call a SQLPL

After publishing a few blogs on Db2 for zOS REST service, I start getting questions on how to create/invoke a REST service to call a SQLPL. In the following article, I am going to show you how to create and invoke such service.…

Continue

Added by Jane Man on January 15, 2020 at 18:31 — 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

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

Monthly Archives

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Latest Activity

William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
yesterday
A blog post by Surekha Parekh was featured
Tuesday
Daniel Luksetich posted a blog post
Monday
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Monday
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
edmundo nascimento liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
Michael Tiefenbacher posted an event
Thumbnail

30. DeDUG User Group Meeting at virtual

September 24, 2021 from 9am to 1:30pm
Monday
Earl Dugan posted an event

Virtual New England DB2 User's Group Thursday, June 24th, 2021. at Virtual Meeting

June 24, 2021 from 9am to 12pm
Monday
Willy Unger liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Saturday
carol goldberg liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
Adrian Collett liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
ONLO posted a discussion
Jun 16
GABRIEL FAJARDO liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 15
Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 14
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
Jun 14
Carol Davis-Mann posted a blog post
Jun 11

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