Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Finding the access path for Columnar queries #3

Published March 13th, 2018 - by

In the first blog in this series ( Finding the access path for Columnar queries ) I was griping about not being able to see any detail in the explain plans for what DB2 is doing when you see a table scan (TBSCAN) of a column-organized table. I mention that each columnar table will have 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

« Previous Page Next Page »

Tag Archives