Search

1 to 10 of 681
Sort by

Blog Entry
DB2 FOR Z/OS PCTFREE FOR UPDATE FOR PERFORMANCE

Nota del editor: Este artículo fue publicado originalmente en inglés . Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. El contenido de este artículo es de aplicación Db2 12 for z/OS y Universal Table Spaces (UTS) Es...


Blog Entry
July Spotlight – Db2 LUW: Types of I/O

July Spotlight – Db2 LUW: Types of I/O Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL...

Martin Hubel's profile image

Blog Entry
How Much is Enough REAL Storage

Over the years as Db2 has traded real storage exploitation for CPU and zIIP MIPS reductions, customers have become more aggressive at utilizing these techniques. Db2 buffer pool expansion, EDM and authorization cache pools, as well as persisting threads through the use of KEEPDYNAMIC and RELEASE...

Adrian Burke's profile image

Blog Entry
Off to the races: Running Runstats by Howard Goldberg

Off to the races: Running Runstats by Howard Goldberg One of the most common maintenance activities performed on a Db2 LUW database is running Runstats on tables and indexes. Accurate database statistics are vital for the Db2 Optimizer to produce the most optimal plans. The optimizer...


Blog Entry
DB2 LUW Version 11.1.1.1 Preview Features by George Baklarz

DB2 LUW Version 11.1.1.1 Preview Features It's inevitable that you see a couple of DB2 Fix Packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the Fix Packs may contain fixes (well that is what they are primarily meant for,...


Blog Entry
IDUG Tech Talk: Vital Statistics - What You Should Know About DB2 for LUW Catalog Statistics

The DB2 for Linux, UNIX and Windows query optimizer is responsible for choosing optimal query access plans, however it can't do its job properly without vital information about your data and database objects. The RUNSTATS utility has been used for years by database administrators to collect...


Blog Entry
DB2 LUW ‘Performance First Aid’ with monreport.dbsummary

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 just DB2’s built-in capabilities....

Steve Rees's profile image

Blog Entry
Understanding the DB2 LUW Backup Performance Statistics

Understanding DB2’s Backup and Restore Statistics In an effort to help customers determine where performance bottlenecks exist in DB2 backup and restore operations, DB2 has added an extremely useful entry into the db2diag.log file. It was first introduced in v 9.7 under registry variable...

Dale McInnis's profile image

Blog Entry
IDUG Tech Talk: Zen and the Art of Database Performance

Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session, we'll go through a step-by-step, decision tree-based approach for tackling performance problems. We start by identifying the core area of the bottleneck - is it time spent...

Steve Rees's profile image

Blog Entry
Designing Large OLTP Databases for Performance

I know the trend is to use NoSQL for a lot of big data storage these days, but it isn’t necessarily the best way to go for every situation. At least not yet. For highly-available high-performance transactional systems we also need a great deal of reliability. DB2 on the mainframe has been...

John Maenpaa's profile image