Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: IBM Champion

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 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

Finding the access path for Columnar queries #2

Published November 8th, 2017 - by

Usage Lists In my last blog ( http://db2geek.triton.co.uk/finding-access-path-columnar-queries ) I was reiterating the case for columnar data storage but bemoaning the lack of any means to see in the access path how the data is being retrieved. It merely shows as a table scan (TBSCAN) and you need to trust that what is going on Continue Reading

Finding the access path for Columnar queries

Published October 18th, 2017 - by

Columnar Data : how it works We’re probably all fairly familiar now with BLU acceleration and the advantages of storing analytical data in a columnar format. If not, and by way of a recap; what we can now do is return much smaller results sets to our analytical queries, in a highly-compressed format, thereby reducing Continue Reading

« Previous Page Next Page »