db2 (26)

By Mark Gillis

In his new blog, Mark Gillis explores how to modify queries on the fly using Jupyter Notebook, widgets and interactive SQL.  

 

OK, fair enough, that does sound a bit specialised and will maybe put some people off. Nothing like a good blast of technobabble to send us scurrying to the coffee machine.

What this is getting at is the ability to modify queries on the fly. It’s one of the reasons I’m quite taken with Jupyter Notebooks; the ability to provide some SQL and to run it, take a look at the result set and then tweak the original SQL and re-run it until you get the output you want.

Read the blog, Jupyter Notebooks, Widgets and Interactive SQL in full. 

 

10817154679?profile=RESIZE_710x

 

Read more…

Congratulations to John Campbell, Db2 for z/OS DE, on his Retirement! Living Db2 Legend!

John Campbell IBM DE for Db2 for z/OS will be retiring from IBM on the 5th of August 2022 after four decades working on IBM Db2 for z/OS. He has been the face of “World of Db2” for decades and I know he will be greatly missed by all of us. 

John started working on Db2 for z/OS Version 1 in the 80's, here is a brief summary of John's career with Db2 for z/OS.  John has worked with many, many Db2 customers, business partners and IBMers over the decades, this is an opportunity for everyone to say goodbye to John before he leaves IBM.

John is a living legend of the Db2 community, especially a familiar face at conferences, World of Db2, IBM and IDUG Events, supported Db2 for z/OS books, Redbooks, whitepapers etc. He will greatly be missed at events, conferences, panels etc 

John has attended and presented at nearly 60 IDUG conferences in North America, EMEA, Australia, South America and India.  He has been voted regularly as the “Top 10 Speaker" on majority of these conferences and been voted “Best "Presenter” at least 3 times and entered the IDUG Speaker Hall of Fame. He has presented many, many Db2 for z/OS webcasts over his career, I have personally worked with John for the past ten years and his webcasts have always achieved up to 1000+ registrations and which is a record for webcasts. 

He has also supported many, many Db2 regional User Groups all over the world.

I know John really wanted an opportunity to meet many of his customers, partners and Db2 family before his retirement and say "goodbye". However, with "Covid Pandemic” it does not look like it is possible, so we have arranged a virtual party.

Check out some of the highlights and memories of the last four decades Click Here

If you have any photos that you would like please upload to this community. Please send your wishes and memories, I will try and print and share in his retirement card. 

10673342488?profile=RESIZE_710x

John started working on Db2 in the 80's as started his career as IBM Systems Engineer. - here is a brief backgrpound of JC's career. JC's words 

  • Technical branch system engineer helping the early customers migrate and exploit Db2 V1R1 thru Db2 V2R3. Helped design and implement major operational and decision support systems.
  • Top system engineer in his IBM System Engineering School.
  • Lead subject matter expert for Db2 in IBM UK Country Technical Support. Major contributor to IBM Redbook projects, and UK and Intentional Conference.
  • Assignment to Db2 Lab in San Jose working as a performance analyst for Db2 V3 and V4. Technical leader in Performance Team for the design and development of Data Sharing and Type 2 Index Manager.
  • Appointed IBM Distinguished Engineer and entry to the IBM Academy of Technology in 2003.
  • Several major IBM Outstanding Technical Achievement Awards including for data sharing.
  • Technical leader of the Db2 Worldwide SWAT Team since 1999.
  • Voted best speaker at multiple major IDUG Conferences around the world, and member of the IDUG Speaker Hall of fame.
  • I hope I will be remembered for my deep technical knowledge, my enthusiasm, customer handling skills, inspiring others, and being generous with my knowledge and time in helping colleagues and customers. Most importantly as the voice of the customer and the voice of reason within Db2 Development.

 

Read more…

Join the IBM team at the IDUG North America 2022 Db2 Tech Conference in Boston on Monday July 11th for a complimentary, action-packed day created by developers, for developers. You'll have the opportunity to learn about Db2's app development and experience hands-on Db2. 

REGISTER FOR DEVELOPER DAY HERE

Date: Monday, July 11th 

10:00 AM - 3:00 PM EST

Where: In person only, Sheraton Boston 39 Dalton Street, The Fens - 5th Floor
Boston Massachusetts

 10628825881?profile=RESIZE_584x

During this time, you'll learn:

  • Training on Db2 platform
  • How to build and deploy a music recognition iOS app with Db2 Warehouse
  • How to build a movie recommendation engine with Db2 ML
  • And much more!

Agenda: 

10:00am: Why Db2
10:15am: How to download, set up, and install Db2
10:45am: Db2 Architecture Overview
11:15am: Building and deploying a music recognition iOS app with Db2 Warehouse
1:00pm: Building a move recommendation engine with Db2 ML

We are looking forward to a wicked awesome time at the IDUG NA22 in Boston, so sign up today to join us!
If you have any questions regarding this course, please email Donna Milano

Read more…

IDUG North America 2022 | Boston, MA | July 11-14  REGISTER NOW

 

  10214507269?profile=RESIZE_710x

 

Registration is Open Now!

IDUG's 2022 North America Db2 Tech Conference will be held at the Sheraton Boston on July 11-14, 2022 [some optional pre-conference events could occur on July 10, 2022]. 

This year’s North America event is a hybrid conference: you can register to attend on-site or to participate online. Register now for the conference, then (if you will be participating on-site) reserve your lodging at the Sheraton Boston!

Conference Sponsorships Available... 

Connect with your customers at IDUG 2022 NA! Click here for the sponsor prospectus that explains exhibit and marketing opportunities to share your expertise with our audience. IDUG will be bringing together the global Db2 community for four days of in-person exploration and collaboration in July. Reach out to us at cyndi@teamycc.com to learn about all our opportunities.

Schedule & Speakers Announcements Coming Soon...

IDUG’s North America Conference Planning Committee (CPC) is finalizing the schedule and speakers for IDUG 2022 NA. If you have any questions about the schedule and speakers, please reach out to CPC member Chris Muncan at chris.muncan@gmail.com

 

Read more…

Tablespaces: where exactly is my data?

By Mark Gillis

This should be pretty straight-forward: you can look in the TABLES System Catalogue and find references for the data (TBSPACE), Indexes (INDEX_TBSPACE) and Large Objects (LONG_TBSPACE). But DB2 throws a few curved balls here; partitioned tables (where the data, indexes and LOBs can be in multiple tablespaces), particular types of index that don’t seem to be in the catalogues at first glance, etc. Let’s see if we can put something together that shows the complete picture.

 

Overview

I’ve got a little database with all sorts of weird and wacky objects. It’s tiny, in terms of volume, but includes row and column-organized tables, range-partitioned tables, MQTs and a bunch of other stuff. Some tables have the full “INDEX IN … LONG IN ….” Tablespace definitions but don’t actually use them, some don’t have any or all the tablespace directives. I want to be able to see the full picture, so how do I go about that?

Click here to find out. 

 10164642078?profile=RESIZE_710x

 

Read more…

In part one of this blog James Cockayne looked at what might happen to a DB2 database that was attacked by ransomware encryption.  

In part two James shares four dos and four don’ts to help protect DB2 databases from ransomware attacks.

https://www.triton.co.uk/ransomware-and-the-db2-database-part-two/

9860513277?profile=RESIZE_710x

Read more…

By Mark Gillis

There are easily accessible means of checking what your Stored Procedure needs in the way of dependent objects (SYSCAT.ROUTINEDEP, basically). So, what if you find a, or a number of, Stored Procs that are marked as needing a REBIND and then, when you do that rebind, you get an SQL0440 indicating that “something” is missing. How do you go about checking that situation out? Find out here

9756322693?profile=RESIZE_584x

Read more…

By James Cockayne

By now I’m sure everyone has heard of the malicious practice known as ransomware attacks, where miscreants break into a corporate network and encrypt data before demanding huge sums of money to provide a method to decrypt that data and make it accessible again.  The attacks tend to be insidious – sometimes the attacker is in the network for months before they gain access to the systems they are interested in, and they are known to target backup servers as well as the primary systems to cause maximum inconvenience to the target organisation. 

Find out what an attack on a DB2 Database would look like. Continue reading James Cockayne's latest blog. 

https://www.triton.co.uk/ransomware-and-the-db2-database-part-1/

 

 

Read more…

In-Database AI Client Experiences with Db2 for z/OS + Demo 

Don't  miss this live webcast on 2nd November 2021 - 11:00AM EST
Tom Ramey will highlight some of the key challenges facing Db2 for z/OS clients and how AI is a breakthrough technology, that when applied to Db2 for z/OS performance management and resiliency can have a major impact. Tom will be joined by Benny Van Straten from Rabobank and Tom Beavin from IBM.  Tom Beavin will share Db2 AI use cases and host a live Db2 AI demo.Rabobank is a Dutch multinational banking and financial services company; Benny will share first-hand experiences and lessons learnt around Db2 AI for z/OS and the power of in-database AI.

 What will you learn by attending this webcast?

  • Hear first-hand client feedback and experiences
  • Learn how Db2 AI improves SQL performance using machine learning based on unique patterns found when executing the queries in a production environment. 
  • Learn how Db2 AI automatically detects SQL access path performance regressions and automatically restores the performance back to its optimal level
  • Learn how Db2 AI automatically stabilizes dynamic queries with their optimal access path, reducing prepare overhead

    9739408684?profile=RESIZE_400x

Tom Ramey IBM WW Director, Data and AI on IBM Z

Benny van Straten IT Specialist/DB2 Rabobank

Akiko Hoshikawa IBM Distinguished Engineer

Tom Beavin IBM Db2 AI for z/OS Development Machine Learning and Optimization

 

Read more…

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 use the NULLID packages, the main alternative to client-side configuration (discussed in the previous article) is server-side or DB2-side configuration. Although not without its challenges, the advantage of server-side configuration is that much of the necessary configuration is done in one place, using system profiles. Continue reading part two

9524610897?profile=original

Read more…

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 Compatibility

With the release of DB2 11 for z/OS, IBM introduced Application Compatibility, which is intended to make migration from one DB2 release to another less burdensome by separating system migration from application migration, and by allowing you to migrate applications individually once system migration has completed. Application migration is managed using two controls: the APPLCOMPAT BIND option, with a default option provided by the APPLCOMPAT system parameter; and the CURRENT APPLICATION COMPATIBILITY special register.

The original announcement was that DB2 11 would support the SQL DML syntax and behaviour of both DB2 10 and DB2 11, and that DB2 12 would support that of all three. Then along came DB2 12 with Continuous Delivery and Function Levels.

Application Compatibility was extended in DB2 12 in two ways: to support function levels as well as release levels; and to support SQL DDL and DCL as well as DML. It still supports an Application Compatibility setting of V10R1.

One of the big practical issues with Application Compatibility has always been how to manage dynamic SQL packages, and in particular how to manage the NULLID packages used by DRDA clients connecting via DB2 Connect or the IBM data server clients and drivers. That’s what this article is about. Continue reading

9524610497?profile=original

 

Read more…

Node.js Application and DB2 REST services

DB2 for z/OS delivered native REST services support in the end of 2016. I wrote 2 white paper on how to create a DB2 REST service and how to consume this service from a mobile device. I start getting enquiries on how to consume a DB2 REST service from a node.js application. In the following blog, I am going to share my experience in implementing a node.js application to invoke a DB2 REST service.

https://www.ibm.com/developerworks/community/blogs/e429a8a2-b27f-48f3-aa73-ca13d5b69759/entry/Node_js_Application_and_DB2_REST_services?lang=en

Read more…

IDUG is pleased to offer these Complimentary Workshops for FREE to squeeze the most educational value out of your conference.

Sunday, Nov 13th

Certification Preparation Courses:

Pre-Certification Workshop: IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals (Exam 610 & Exam 312)  
Pre-Certification Workshop: DB2 10.1 DBA for LUW (Exam 611) and DB2 10.5 DBA for LUW Upgrade (Exam 311)

Thursday, Nov 17th

Read more…

We have decided to extend the Early Bird Registration up to and including 10th October. This means you will be able to take advantage of the low rate for a little bit longer.

Register by October 10th. Save an additional €225 using EARLYEMEA discount code.

http://www.idug.org/p/cm/ld/fid=926

 

Read more…
Unable to attend the IDUG DB2 Tech Conference in Lisbon, Portugal this year? You can still experience featured session and Db2 Panels taking place at conference and ask questions live through uStream. Login to idug.org to join live stream, and engage with IBM strategists and developers, consultants and independent DB2 users remotely!When: October 4, 2017Time: Begins 11:00 AM WET ( GMT + 1hrs)Where: Live Stream from Anywhere!Cost: Complimentary for IDUG Members (Not a member? Join today!)Session: IBM BLU for Spark an Event store for the next generation of ApplicationsPresenter: Namik Hrle -IBM FellowAbstract: This presentation provides a deep dive into he next generation of IBM data store for handling real time event applications from IoT to new Event Sourcing applications. The Store is built on the Open source Spark platform and Object storage and can ingest Millions of transactions per second and provide Highspeed analytics on transactional data in real time. Perfect for Event sourcing applications than need the velocity and volume of data this platform can handle and for Structured Data Lake applications such as Internet of things.Join Now http://ibm.biz/BdjMLk
Read more…
Unable to attend the IDUG DB2 Tech Conference in Lisbon, Portugal this year? You can still experience featured session and Db2 Panels taking place at conference and ask questions live through uStream. Login to idug.org to join live stream, and engage with IBM strategists and developers, consultants and independent DB2 users remotely!When: October 4, 2017Time: Beings 11:00 AM WET ( GMT + 1hrs)Where: Live Stream from Anywhere!Cost: Complimentary for IDUG Members (Not a member? Join today!)Session: IBM BLU for Spark an Event store for the next generation of ApplicationsPresenter: Namik Hrle -IBM FellowAbstract: This presentation provides a deep dive into he next generation of IBM data store for handling real time event applications from IoT to new Event Sourcing applications. The Store is built on the Open source Spark platform and Object storage and can ingest Millions of transactions per second and provide Highspeed analytics on transactional data in real time. Perfect for Event sourcing applications than need the velocity and volume of data this platform can handle and for Structured Data Lake applications such as Internet of things.Join Now http://ibm.biz/BdjMLk
Read more…