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...
by Craig S. Mullins | Oct 19, 2020 | in-memory, Memory, optimization, performance
A recent, recurring theme of my blog posts has been the advancement of in-memory processing to improve the performance of database access and application execution. I wrote an in-depth blog post, The Benefits of In-Memory Processing, back in September 2020, and...
by Craig S. Mullins | Sep 2, 2020 | in-memory, performance
One area that most organizations can benefit from is by better using system memory more effectively. This is so because accessing and manipulating data in memory is more efficient than doing so from disk. Think about it… There are three aspects of computing that...
by Craig S. Mullins | Mar 10, 2020 | book, Java, jdbc, LUW, performance, sql, z/OS
DBAs: are you looking for a way to help train your developers to code more efficient Db2 application programs? Programmers: do you want to understand the best practices for writing high-performing Db2 applications?Well, my latest book, A Guide to Db2 Performance...
Recent Comments