DB2 11.1 for LUW introduced built-in SQL functions for regular expressions, a long-awaited enhancement that effectively supersedes a couple of popular workarounds for regex processing in DB2 SQL. This article describes the REGEXP functions and explains what makes them better than older workarounds.
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
DB2 11 for LUW includes a broad set of enhancements to BLU Acceleration, taking the columnar in-memory database technology to a new level of maturity, performance, and scalability. Matthias Nicola from IBM provides an overview of new features and improvements in BLU Acceleration in DB2 11.1
This article is about DBI Software’s pureFeat™ Performance Management Suite for IBM DB2 LUW. For the past four consecutive years, Database Trends and Applications Magazine (DBTA) has honored DBI pureFeat as one of its Top 100 Trend Setting Products.
Statistics event monitors are an extremely useful way to get periodic monitoring of basic metrics on your system. They're just well-disguised behind a somewhat misleading name.