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...
1 Comment - no search term matches found in comments.
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...
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...
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...
2 Comments - no search term matches found in comments.
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,...
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...
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....
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...
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...
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...