44 (0)870 2411 550

Tech Blog

The latest technical blogs from the Triton Consulting team. All the content and authors from our Confessions of a Db2 Geek blog can now be found here. You can also access additional educational content in our Resources section.

Table-Partitioning-The-Good-the-Bad-and-the-Ugly-IDUG-2023
Oct
12
2023 Posted by Carol Davis-Mann
Table Partitioning: The Good, the Bad and the Ugly – Live at IDUG EMEA 2023

Do you want to learn about the benefits, potential pitfalls, and how to make the most out of the Db2 feature, Table Partitioning? If so, then you won't want to miss Damir Wilder's presentation at IDUG EMEA 2023 in Prague,
READ MORE
Messing-with-JSON-data-in-Db2-Part-2
Oct
11
2023 Posted by Mark Gillis
Messing with JSON data in Db2 Part 2

In the first part of this blog, I was looking at how to get your JSON data into Db2. The next bit is what to do with it. Initially, my requirement is to process the relatively complex (read “flexible”) JSON data
READ MORE
Messing-with-JSON-data-in-Db2
Jul
28
2023 Posted by Mark Gillis
Messing with JSON data in Db2

JavaScript Object Notation (JSON) is an open standard data interchange format that has been around since the early 2000s but is gaining more and more traction these days. As such, it behoves us in the database community to ensure that
READ MORE
User-and-Group-Permissions-Part-2-Featured
Jan
10
2023 Posted by Mark Gillis
User and Group permissions for Procs, Views and Triggers – Part 2

In the first part of this blog I outlined an issue I’d come across with the conferring of Role-based permissions to Groups for certain objects. Here’s one way around it and some further observations on the underlying issue.   Possible
READ MORE
User-and-Group-Permissions-Mark-Gillis
Dec
07
2022 Posted by Mark Gillis
User and Group permissions for Procs, Views and Triggers Part 1

This is an issue that I stumbled over comparatively recently. It looked to me like a bug, but if you track down the chapter and verse from IBM, it’s “working as advertised” (see https://www.ibm.com/docs/en/db2/11.5?topic=roles-compared-groups ). The issue is that you
READ MORE
Have a Question?

Get in touch with our expert team and see how we can help with your IT project, call us on +44(0) 870 2411 550 or use our contact form…

Contact us here