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...
by Craig S. Mullins | Dec 17, 2020 | check, COPY, LOAD, performance, recover, REORG, RUNSTATS, UNLOAD, utilities
Db2 utilities are the unappreciated, and often over-looked, workhorses of your mainframe Db2 environment. They perform the dirty work that has to be done to populate, organize, backup, and recover your vital mainframe data. Without them, building effective Db2...
Recent Comments