This presentation from the IDUG EMEA 2016 will provide an overview of DB2 LUW statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.
Investigating performance problems doesn’t have to be hard. There are some basic steps you can take to find common bottlenecks in your system – ‘performance first aid’ if you will. We’re going to look at some of these basic problems and how to find them, using monreport.dbsummary & friends.
DB2 for LUW has undergone a lot of changes to become more “cloud friendly”. This article focuses on new DB2 11.1 features that enable direct use of Amazon S3 cloud storage, and offers considerations about security and cost when integrating some aspects your database with the cloud.
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.