All Blog Posts (398)

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 for z/OS Upcoming Webcasts 2021 - Register With one click!

Db2 for z/OS Upcoming Webcasts 2021  - Register With one click!

Check out upcoming Db2 for z/OS webcasts and register with one click today - secure your place…

Continue

Added by Surekha Parekh on February 24, 2021 at 17:10 — 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

*NEW* Db2 12 Technical workshop, REGISTER NOW LIMITED PLACES

Get a head start by registering for this *NEW* Db2 12 Technical workshop, Hosted by John Campbell - IBM DE and Anthony Ciabattoni from the IBM Db2 SWAT Team.

Secure your seats today http://ibm.biz/Db212TechnicalWorkshop

Feb 9th and 10th…

Continue

Added by Surekha Parekh on January 21, 2021 at 18:42 — 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

What year was IBM Db2 invented?

What year was IBM Db2 invented? Submit your answer here

We are running Db2 trivia quizzes on LinkedIn please can you vote and also like and share this post. We are just  having some fun over Covid lock down period. If you have some good Db2 trivia questions please email to…

Continue

Added by Surekha on November 17, 2020 at 18:44 — No Comments

Deploying AI in the Enterprise

Please, have a look at our new book "Deploying AI in the Enterprise". Here is the springer.com Link.

Regards, Eberhard.

Added by Eberhard Hechler on October 6, 2020 at 17:39 — 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

Does your data infrastructure remind you of a fruit smoothie?

Stuck at home and trying to stay heathy got me thinking about fruit smoothies. It sounds like a good idea until you start making one and realize there are lots of ingredients that all need to be prepared. It got me thinking, how some of my client’s data infrastructures are kind of like making a fruit smoothie – lots of effort is needed to blend different components together to get a good result.…

Continue

Added by Jonathan Sloan on September 17, 2020 at 19:33 — 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

Latest LOAD Likes!

Introduction:

Assume the following scenario:

  1. Application delivers files as LOAD input for a partitioned table space which contains already data. The files have a naming convention, e.g. name.IN01, …IN02 etc., which means records from file IN01 go into partition 01 etc. Unfortunately, some records are not assignable by the application, so there is an extra file named IN99 with…
Continue

Added by Peter Hartmann on July 29, 2020 at 13:37 — No Comments

Db2 Analytics Accelerator - Migrating to 7.5 best practices webcast

Register here http://ibm.biz/accelerator_webcast  To many IBM Z customers, the Db2 Analytics Accelerator has become as essential as Db2 for z/OS itself.

If you are a Db2 Analytics Accelerator customer, you are aware of how indispensable it has become to your organization. If you aren’t already a Db2 Analytics Accelerator customer, you might be a bit curious as to the latest capabilities that have recently been…

Continue

Added by Jonathan Sloan on July 28, 2020 at 18:45 — 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

IBM Db2 AI for z/OS 1.3 is here!

Announcing IBM Db2 AI for z/OS 1.3 – the evolution continues -- moving enterprise relational databases into the future!


To always get the latest…

Continue

Added by Paul McWilliams on June 23, 2020 at 16:28 — 2 Comments

IBM announces Db2 for z/OS Data Gate general availability

Check out http://ibm.biz/Db2DataGate Timely, cloud 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…

Continue

Added by Jonathan Sloan on June 19, 2020 at 14:11 — No Comments

IBM Db2 Administration Tool for z/OS - Hints and Tips Webcast

TITLE:  Things I wish I knew about the IBM Db2 Administration Tool for z/OS

Date:  Tuesday, June 23rd

Time:  11: 00 AM EST

REGISTRATION URL: https://bit.ly/2ULEH8r



If you are a Db2 for z/OS Database Administrator, Developer or System Programmer, you probably use the Db2 Administration Tool daily and often.  Are you aware of all its features and functions?  As…

Continue

Added by Calene Janacek on June 16, 2020 at 17:45 — No Comments

Can IBM Z and Db2 for z/OS play a role in your Hybrid Cloud infrastructure?

With all the hype around new technology, cloud platforms and development approaches, you might be wondering how IBM Z and the transactional data that resides on it fit into this changing landscape. Read the new IBM Z e-Book

The optimal position for today’s IT organization is to be a full-fledged partner with lines of business to drive revenue and deliver on an organization’s strategy. IT organizations need to modernize. This means…

Continue

Added by Jonathan Sloan on June 15, 2020 at 15:41 — 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

Monthly Archives

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Latest Activity

Carol Davis-Mann posted a blog post

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 configurationWhen considering how to manage managing Application Compatibility – APPLCOMPAT – for your distributed applications which use the NULLID packages, the main alternative to client-side configuration (discussed in the …See More
6 hours ago
An event by Jonathan Sloan was featured
Thumbnail

IBM Db2 for z/OS Data Gate and IBM Cloud Pak for Data on IBM Z update at Webcast - East Coast U.S. time zone

March 9, 2021 from 11am to 12pm
Access your Db2 for z/OS Data from the cloud: Db2 Data Gate and IBM Cloud Pak for Data on IBM Z demo and updateMarch 9th @ 11:00 AM Eastern U.S. timeRegister now @ https://ibm.biz/Db2DGUpdateWoDJoin us to see a demo of Db2 for z/OS Data Gate which can help you reduce the complexity associated with delivering Db2 for z/OS data for new hybrid cloud initiatives. Db2 Data Gate allows you to keep pace with new cloud, analytics and mobile initiatives with…See More
6 hours ago
William Shipley liked Surekha Parekh's event Db2 for z/OS: The Evolution Engine - Julian Stuhler
7 hours ago
Dragica Smintic liked Surekha Parekh's event Db2 for z/OS: The Evolution Engine - Julian Stuhler
13 hours ago
A blog post by Surekha Parekh was featured
14 hours ago
An event by Surekha Parekh was featured

Db2 for z/OS: The Evolution Engine - Julian Stuhler at Webcast

March 16, 2021 from 11am to 12:30pm
Register NowDb2 for z/OS: The Evolution Engine - Julian StuhlerFor over 35 years, Db2 for z/OS has been the engine at the heart of many of the critical applications that run the world around us. From internet banking transactions to airline reservations and insurance quotations, Db2 for z/OS continues to power a huge array of today’s high volume, mission-critical enterprise applications. But how has Db2 remained so relevant…See More
15 hours ago
Tom Glaser posted events
15 hours ago
Jonathan Sloan posted an event
Thumbnail

IBM Db2 for z/OS Data Gate and IBM Cloud Pak for Data on IBM Z update at Webcast - East Coast U.S. time zone

March 9, 2021 from 11am to 12pm
Access your Db2 for z/OS Data from the cloud: Db2 Data Gate and IBM Cloud Pak for Data on IBM Z demo and updateMarch 9th @ 11:00 AM Eastern U.S. timeRegister now @ https://ibm.biz/Db2DGUpdateWoDJoin us to see a demo of Db2 for z/OS Data Gate which can help you reduce the complexity associated with delivering Db2 for z/OS data for new hybrid cloud initiatives. Db2 Data Gate allows you to keep pace with new cloud, analytics and mobile initiatives with…See More
15 hours ago
Michal Bialecki liked Carol Davis-Mann's blog post DB2 12 for z/OS, DRDA Applications and Application Compatibility Part One
Friday
A blog post by Carol Davis-Mann was featured

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

IntroductionThis, 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 CompatibilityWith the release of DB2 11 for z/OS, IBM introduced Application Compatibility, which is intended to make migration…See More
Friday
An event by Surekha Parekh was featured
Thumbnail

Business and Technical Value of Top Ten Features in Db2 12 for z/OS Continuous Delivery at Virtual Event

March 23, 2021 from 11am to 12:15pm
REGISTER NOWBusiness and Technical Value of Top Ten Features in Db2 12 for z/OS Continuous Delivery Abstract One of the most valuable resources for modern businesses is business critical data.  Data can be used to provide insight into every facet of the business from operations to market trends. Powerful data enables effective and efficient business decision making and your enterprise data is only as powerful as your ability to harness it. Storing,…See More
Friday
Carol Davis-Mann posted a blog post

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

IntroductionThis, 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 CompatibilityWith the release of DB2 11 for z/OS, IBM introduced Application Compatibility, which is intended to make migration…See More
Feb 17
An event by Surekha Parekh was featured
Thumbnail

Db2 12 agile, open and secure - Your database of choice for business critical data at Webcast

March 16, 2021 from 11am to 12:30pm
Register Now    PART 2Maria Sueli from the IBM Development Lab Following Julian, Maria Sueli from the IBM Development Lab will share with you how you can remove barriers that are holding your Db2 enterprise data captive in outdated methods and processes.  She will demonstrate how Db2 for z/OS…See More
Feb 17
Annette Zawacki added a discussion to the group Data, Analytics and AI on IBM Z
Thumbnail

Don't miss the first Db2 Analytics Accelerator Webcast of 2021

IBM Db2 Analytics Accelerator Trends and DirectionsFebruary 16 / 11:00 AM ETRegister todayPlease join IBM for a webcast where we will share the latest Db2…See More
Feb 10
Surekha Parekh updated an event
Thumbnail

28. DeDUG at virtual

February 26, 2021 from 9am to 12pm
The 28. DeDUG regional user group meeting will take place on Friday 26.02.2021 as a vitual event. Agenda and registration for this free event can be found here. We are looking forward to…See More
Feb 8
damian cotumacci liked Surekha Parekh's event Db2 12 Exploiting new functions and Migration Planning PART 2
Jan 28

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

Forum

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 1 Reply

I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i  be able to access this information?Continue

Tags: #DataAccess

Db2 is developer inclusive and preview of Db2 11.5.5

Started by Kip in What's hot ? Nov 4, 2020. 0 Replies

This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service