The latest technical blogs from the Triton team.
Implementing a Connect Procedure to Enhance Database Security
Introduction Introduced in DB2 v9.7 Fix Pack 3, the CONNECT_PROC database configuration parameter allows you to specify a stored procedure that will be executed when a user attempts to connect to the database. This functionality affords the DBA a wide
Client Experiences: How DB2 Migration Affects Decimal Type Conversion
Recently, I assisted a client migrating their DB2 databases from v9.7 to v11.1. I intentionally say “migrating” and not “upgrading”, even though three major releases were jumped, because the existing databases were located on Z-Linux servers (big endian) and the
Performance differences between upper-case (XQuery) and UPPER scalar function
I thought I’d share a recent performance issue I had with one of our customers. We’re in the Pre-Production testing stage of a project and our responsibility is a series of Stored Procedures to manage the INSERT, UPDATE and SELECT