Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2

DB2 Native REST API – VB.NET Tool wDB2REST

Published June 5th, 2018 - by

Introduction Whilst working with the DB2 for z/OS REST API, I thought it would be useful to have a tool to make things easier to see what was defined, what the parameter profiles look like and maybe even be able to run the services. To that end, I’ve written one in VB.NET called wDB2REST. It’s Continue Reading

DB2 Native REST API – Python

Published March 16th, 2018 - by

Introduction Whilst I haven’t used Python for a while, it has always been the playground for geeks. With it’s C-like look and feel and it’s huge array of extension libraries there’s very little it can’t do. I was prompted to refresh my acquaintance with Python by a colleague who’d been reading this blog chain – Continue Reading

DB2 Native REST API – Creating Services from TSO / Batch

Published February 16th, 2018 - by

Introduction One of the challenges that we’ve faced working with the DB2 for z/OS native REST API is the mid-range nature of the interface when creating services. This doesn’t sit so well with the existing mainframe landscape and administration processes and the fact that Data Studio (at least up to V4.1.3) doesn’t work with it Continue Reading

DB2 Native REST API – curl

Published January 31st, 2018 - by

Introduction One of the things that we frequently want to do is to perform a quick check of the REST service that we’ve just created. In the previous blogs we’ve seen how we can do this with PHP and Java, but why can’t we just use a command line tool? Well, we can. Curl, or Continue Reading

DB2 Native REST API – Bonus Material – node.js

Published January 12th, 2018 - by

Introduction This is the 6th blog post in the (ahem) series of 5 on the DB2 for z/OS native REST interface. The previous entries are: DB2 Native REST API – Getting Started DB2 Native REST API – Creating Services DB2 Native REST API – A Sample REST Application DB2 Native REST API – Security DB2 Continue Reading

DB2 Geek Review of 2017

Published December 15th, 2017 - by

It’s been a busy and exciting 12 months at the DB2 Geek towers. Before we start the annual celebratory fun we thought we would take a look back at our most notable achievements, events and blogs of the year. What a great way to start! In January three members of the Triton Consulting team were Continue Reading

DB2 Native REST API 5 – BLOBs, CLOBs and Stored Procedures

Published December 1st, 2017 - by

Introduction In the previous blogs in this series, we’ve seen that the process of creating and consuming REST services with DB2 for z/OS V11 and V12 can be managed easily with PHP. In this blog, we’ll look at how we access LOB data, and finally how we use stored procedures to drive business logic.   Continue Reading

Client Connections in a TSA/HADR cluster- Part 4

Published June 6th, 2017 - by

In Part 1 I showed how to setup a simple TSA/HADR cluster consisting of two servers, and what happens to an active client connection in case of a failover. In Part 2 and Part 3 we saw how ACR and VIP independently affect a client’s connection in case of a failover in the cluster. In Continue Reading

DB2 Native REST API – Security

Published May 2nd, 2017 - by

Introduction In the previous blogs on the DB2 Native REST API, we’ve talked about installation of the feature, how to create and drop services, and how to drive them. In this one, we’re going to have a look at how security works with REST – both in general HTTP/HTTPS terms, and from the point of Continue Reading

Client Connections in a TSA/HADR cluster – Part 3

Published April 18th, 2017 - by

In Part 1 I showed how to setup a simple TSA/HADR cluster consisting of two servers, and what happens to an active client connection in case of a failover. In Part 2 we saw how a client with configured ACR automatically recovers its connection to the database in case of a failover in the cluster. Continue Reading

DB2 Native REST API – A Sample REST Application

Published February 27th, 2017 - by

Introduction In previous blogs in this series, we’ve seen how to install and configure the REST API, and how to create and delete services within it using PHP. This blog will focus on a simple REST application that displays information based on the IBM supplied sample data. Application Overview The Spiffy Computer Company (blame IBM Continue Reading

DB2 Native REST API – Creating Services

Published February 10th, 2017 - by

Introduction In the first blog in this series, we discussed how to enable the native REST API in DB2 for z/OS. In this edition, we’re going to focus on how we go about creating new services and what methods we used to do this. In doing so, we’re going to be using PHP – which Continue Reading

If it ain’t broke, don’t fix it

Published January 31st, 2017 - by

Ever heard this expression? One of my least favourites. Flip it over and express it the other way around: Wait until it breaks and then try and fix it I don’t think that is something you seriously want to consider in a Production environment and yet it is something we come across as database support Continue Reading

DB2 Native REST API – Getting Started

Published January 17th, 2017 - by

Introduction With DB2 for z/OS customers expanding their business presence into the mobile client world, solution developers are seeking more efficient ways to leverage existing data and business logic to support this. The REST (Representative State Transfer) native API implemented in DB2 is a light weight interface using HTTP POST / GET request handling to Continue Reading

SQL Query Tuning Exercise

Published November 16th, 2016 - by

In this exercise we shall look at several different methods of tuning a poorly performing SQL query. The Problem The Original SQL Query The Original Access Path So, where is the problem? Looking at the Access Path chosen by the DB2 Optimizer, all looks well – all tables are either accessed via indexes, or not Continue Reading

DB2 11 for z/OS Comes of Age

Published March 2nd, 2016 - by

It’s easy to think of DB2 11 for z/OS as still being the new kid on the block, but it actually became Generally Available back in October 2013 – Miley Cyrus was getting plenty of airtime with Wrecking Ball and the movie Gravity was expertly inducing vertigo in audiences all around the world. New releases Continue Reading

RUNSTATS versus Actuals

Published June 10th, 2015 - by

Now and again we get a slightly panicky call from one of our clients as they attempt to execute some part of their application and it takes far longer to run than it should, or than it did the last time it was executed. Our first question is usually “have you run REORGs and RUNSTATS Continue Reading

Pivoting and Unpivoting data with pureXML

Published May 15th, 2015 - by

I am sometimes presented with data that, although stored in the relational database, still needs some ‘massaging’ to be meaningful. An issue that would fall into that category would be where a set of values has been stored in a string; in order for this to be usable I really need to “unpivot” it so Continue Reading

Enumerating DB2 Subsystems

Published November 27th, 2014 - by

Introduction Every site has this challenge and we all find different ways around the problem: How can I generate a list of DB2 subsystems defined to my current LPAR and whether they are active or not? It may be that you want to know exactly that but more commonly this is the sort of thing that Continue Reading

Considerations to use DB2 HADR with TSM

Published May 19th, 2014 - by

  Starting with version 6.1 TSM now uses DB2 as its backend database engine. It is a normal DB2 instance, but very tightly controlled by IBM support. After installation one cannot change any parameter in the TSM DB2 instance without permission from IBM support.   As part of normal DB2 engine TSM can use the Continue Reading

Nanu, Nanu, DB2 calling you!

Published January 30th, 2014 - by

By Klaas Brant Do you remember the Mork and Mindy show? Mork made a connection with Orson using his famous sentence “Nanu, Nanu, come in Orson” in order to report what was going on. If this does not sound familiar it simply means you are not as old as I am! The reason I bring it up Continue Reading

New Podcast! IBM DB2 Analytics Accelerator for z/OS

Published November 25th, 2013 - by

Join Julian Stuhler and Cristian Molaro in our latest DB2 Geek podcast where we take a look at the IBM DB2 Analytics Accelerator for z/OS.   “The IBM DB2 Analytics Accelerator for z/OS has the potential to be a revolution in terms of performance and cost savings” Cristian Molaro, Independent DB2 Consultant.     For Continue Reading

Time Travel Gotchas – Part 2

Published October 28th, 2013 - by

  See http://db2geek.triton.co.uk/time-travel-gotchas-part-1/ for Part 1 of this blog   Access paths   You will have noticed that my previous example also built the history table as a Multi-Dimensional Cluster (MDC). That doesn’t give any benefits in terms of space management but does address a problem with the access path. It’s not the only way; Continue Reading

DB2 11 for z/OS – An IDUG Technical User Perspective

Published October 8th, 2013 - by

Yet another DB2 11 for z/OS white paper has been released! In March 2013 the IDUG DB2 11 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants (including me). Working alongside IBM’s formal Early Support Program (ESP), the Editorial Committee gained valuable insight into exactly what makes the Continue Reading

When worlds collide – Running DB2 workloads in a Linux for System z Environment

Published September 23rd, 2013 - by

Many large system z environments have begun to look at the possibilities of running non-z/OS workloads on their System z environments in recent years. Smaller organisations  may not already posses a System z server, but are starting to consider IBM’s Enterprise Linux Server, a dedicated Linux server based on System z technology. I’ve just posted Continue Reading

Time Travel Gotchas Part 1

Published July 29th, 2013 - by

Time Travel query offers a quick and intuitive way of querying your data for historical scenarios, as well as the traditional current picture. There are a number of good articles out there showing how to enable the feature and some suggestions on how to use it. But like nearly every option, it’s got pitfalls and Continue Reading

Assembler : Getting DB2 Traces Started to OPn

Published July 29th, 2013 - by

In the previous post I talked about getting our assembler monitor connected to DB2 for z/OS with the intention of getting some statistics traces running and gathering the data cut by DB2. This time we’re going to look at how we actually got the traces running.   As you’ll know from your extensive reading of Continue Reading

RCAC: Usage Considerations Part 3

Published June 3rd, 2013 - by

In the previous two blogs (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1  and http://www.triton.co.uk/confessions-of-a-db2-geek/article/66/RCAC:-Usage-Considerations-Part-2  ) we were discussing the Column Mask and Row Permissions as two separate entities, with potentially different impacts to your database. I’m now going to try and demonstrate some of the issues that can occur when you have the two features enabled on the same table. I’m Continue Reading

Assembler : Getting Connected to DB2

Published May 7th, 2013 - by

At the end of another week of chasing my tail and trying not to get in too much trouble with Mrs DB2 Dinosaur, I’ve resolved to write a quick post about getting the assembler component of the DB2 monitor connected to DB2. Whilst this is fairly well documented in the manuals, we have a slightly Continue Reading

RCAC: Usage Considerations Part 2

Published April 3rd, 2013 - by

In the previous blog (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1 ) we were discussing the Column Mask part of the RCAC feature. To recap, there are 2 parts to RCAC • Column masks : which over-write or obscure returned values with specified alternatives • Row permissions : which only return the rows of data that you are permitted to see Continue Reading

DB2 10.1 RCAC: Hints & Tips Part 1

Published February 28th, 2013 - by

  Row and Column Access Control (RCAC) in DB2 10.1 for LUW is a neat and simple means of shielding your data from users who don’t need to see it. It’s really two things melded together:   • Row permissions : which only return the rows of data that you are permitted to see • Continue Reading

Confession of the Month

Want to see your DB2 tech tip here?

Published February 12th, 2013 - by

We’d love for you to share your top DB2 hints and tips on Confessions of a DB2 Geek so email us on geeks@triton.co.uk The best tips will be featured on the site over the next few months and the winners will also receive a free limited edition DB2 Geek t-shirt.

DB2 Geek Recognised by Peers on LinkedIn

Published February 11th, 2013 - by

LinkedIn has been an excellent tool for the DB2 Geeks.  It has helped us to connect with DB2 peers across the world and we enjoy running our groups to encourage discussion and knowledge sharing. One of our top Geeks Iqbal Goralwalla has now been recognised by his peers and is in the top 1% most Continue Reading

Top 10 DB2 Geek Highlights of 2012

Published December 20th, 2012 - by

  Wow, what a year! The DB2 Geeks have certainly been busy during the past 12 months. Before we head home for the holiday season we thought we would share our 2012 highlights with you.   1 – For Triton Director and IBM Gold Consultant Julian Stuhler, 2012 began with a trip to the Silicon Continue Reading

DB2 for z/OS Connectivity Testing

Published December 3rd, 2012 - by

  One of the challenges that customers face is validating the DDF configuration of a new service before making it available to mid-range application servers. In an ideal world, we’d all have DB2 Connect available to bash a quick configuration together and use the command line processor to connect and run some simple SQL as Continue Reading

Top 10 DB2 LUW 9.7 Fixpack “Pearls”

Published August 20th, 2012 - by

  Iqbal Goralwalla, Principal Consultant at Triton Consulting, was again invited to present on the DB2Night Show webinar. A staggering 100% of the audience who watched said they learned something from Iqbal’s presentation on the subject of DB2 LUW 9.7 Fixpack "Pearls". We share these pearls of wisdom with you below, on the new commands and features Continue Reading

DB2DART – Hints & Tips for the DBA

Published January 17th, 2012 - by

The DB2 Analysis & Reporting tool or DB2DART is one of the lesser used performance tools and has traditionally been used with IBM support. However, DB2DART can be one of the most powerful tools in the DBA’s kit bag. It can help increase DBA productivity in crisis situations and earn the DBA some well-deserved brownie Continue Reading

DB2 Geek Review of 2011

Published December 23rd, 2011 - by

It’s that time of year again, I’ll soon be waving goodbye to my DB2 Geek colleagues and heading home for mountains of turkey, mince pies and the odd glass of mulled wine. However, before I leave you I thought it would be good to share my personal DB2 Geek highlights of 2011. So, here we Continue Reading

Confession of the Month

Seek the Geek Episode 1

Published June 14th, 2011 - by

How will our DBA cope with Rogue SQL and Data Corruption? What will happen when the “BIG BOSS” DB2 Version Migration is deployed? Seek the Geek to find out! if you can’t see the video above please click here http://youtu.be/EVoQdR2TYvk

To reorganise or not to reorganise

Published June 7th, 2011 - by

By Philip Carrington – Holiday Extras – A Triton Consulting Client www.holidayextras.co.uk   From my blog statistics I can see that a common question which leads people to my door is “db2 reorganisation required” or the equivalent. So here I am assuming that you have your Health Monitor service turned on and you have received Continue Reading

Confession of the Month

DB2 z/OS Quick Tuning Tip

Published May 27th, 2011 - by

Anyone who has spent any time tuning DB2 for z/OS applications will know how painful the occasional dataset open/close process can be – there’s even a specific accounting class 3 suspend counter for it. The problem is even worse when large numbers of datasets have to be opened or closed all at once, such as Continue Reading

Confession of the Month

Command line vs GUI

Published February 1st, 2011 - by

I always say that database admin is best performed from the command line with scripts. This means that admin is repeatable and the actions are recorded which in turn can improve DBA productivity.   • If you have a single database that you manage, and that’s it, this may seem like overkill, but what happens Continue Reading

Confession of the Month

Beware of over-federating

Published January 19th, 2011 - by

During a recent DB2-LDAP configuration at a client site, I stumbled upon a bizarre security exposure.   Using any DB2 client tool, it was possible to connect to the database as any user without having to get the password right! Once connected to the database, you only had access to the tables that the user Continue Reading

Confession of the Month

Big news for DB2 Workgroup Edition users

Published October 12th, 2010 - by

The hot news this week from IBM is that DB2 pureScale is going to be FREE in DB2 9.8 Workgroup Edition.  Great news for all workgroup users who will now be able to achieve levels of availability and scalability traditionally only possible in large z/OS enterprise organisations. We figure this is not only good news Continue Reading

August Announcements

Published August 17th, 2010 - by

Despite the traditional slow down as many people take a well-earned summer holiday, this month has seen a few interesting announcements from IBM which will impact many of us over the next year or two.   DB2 for z/OS V8: The End Is Nigh I’ve been spending time with a few large customers recently helping Continue Reading

DB2 pureScale – Insert Load & Replication

Published July 13th, 2010 - by

Following on from James Gill’s recent blog post about the Coupling Facility today I’m sharing with you our experiences of working with Insert Load & Replication in DB2 pureScale.  In order to test the load capacity of the IBM DB2 pureScale machine we needed some test data and lots of it!  Being somewhat familiar with Continue Reading

DB2 pureScale Coupling Facility

Published July 12th, 2010 - by

We were lucky enough to get an opportunity to spend a week in the IBM Boeblingen Labs in Germany, to get some hands on experience with DB2 9.8 – pureScale – or Data Sharing on mid-range.    The platform that we were working with was a five node configuration – two coupling facilities (CFs) and Continue Reading

Adding some zIIP to IBM DB2

Published April 28th, 2010 - by

What Can Speciality Processors Do for You? Article by Julian Stuhler for Database Journal Introduction For some time now, DB2 for z/OS has been the major user and benefactor of the zIIP engine: one of a number of System z technologies collectively known as “speciality processors”. This article provides an overview of the zIIP and Continue Reading

Triton Consulting are first to work with pureScale

Published April 26th, 2010 - by

DB2 experts, Triton Consulting are the first IBM Business Partners in Europe to work with DB2 pureScale – IBM’s latest and most important new feature for DB2 LUW.    Triton have a team of DB2 experts spending a week at IBM Labs in Boeblingen Germany on a research and development project. During their time there Continue Reading

DB2 LUW Security – DB2 Whisperings

Published January 27th, 2010 - by

DB2 Configuration Parameters – What They Whisper About Security Behind Your Back.   An article by Rebecca Bond.   I’ve always wondered what DB2 would say about security IF it could talk.  Maybe the conversation would be something like this…..   DBM DISCOVER:  “So, today she set me to DISABLE.   I know…I know…it’s for my Continue Reading