by Craig S. Mullins | Jun 21, 2023 | I/O, Memory, optimization, performance, query
Performance is a critical aspect of any database management system, and IBM Db2 is no exception. As organizations deal with ever-increasing data volumes and complex workloads, it is crucial that Db2 environments are fine-tuned to ensure optimal performance,...
by Michael Krafick | May 23, 2023 | DB2, Education and Skills, Experiments, Featured, Guest Blogs, performance
Database performance is heavily influenced by data volume and cardinality (or how unique that data may be). It’s interesting to watch the look on someone’s face when this concept clicks. There is a look of understanding from a developer when she can extrapolate why...
by Ember Crooks | Apr 25, 2023 | DB2, Featured, mysql, performance, scaling
“Relational databases don’t scale!”. This is the claim that database experts have heard over and over again, and yet we spend our careers scaling databases. I immediately translate this in my head to either “I threw hardware at the problem and...
by Craig S. Mullins | Mar 20, 2023 | cost, Java, performance, zIIP
As a Db2 DBA, you're constantly looking for ways to improve performance and efficiency while minimizing costs. One technology that can help achieve these goals is the zIIP (IBM System z Integrated Information Processor) processor. By offloading eligible Db2...
by Craig S. Mullins | Dec 13, 2021 | design, include columns, index, performance, sql
One of the constant struggles with Db2 development, and indeed developing for any relational DBMS, is designing and creating appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data in a...
by Craig S. Mullins | Jan 7, 2021 | automation, autonomous digital enterprise, BMC, digital transformation, mainframe, operations, performance
Assuring the performance of your mainframe systems and applications is an imposing task that keeps getting more complex all the time. It makes sense to arm your IT performance analysts, DBAs, and systems programmers with modern tools so you can optimize performance...
Recent Comments