Search

1 to 10 of 27
Sort by

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
Are you making the most of your Profile Tables for Db2 z/OS?

With the ever increasing number of features and functions being added to Db2 for z/OS it’s easy to overlook the finer points of some of those features. Take in point the “Profile Tables”. You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set...


Blog Entry
SQL Tuning for Db2 - Where to Start by Eddy Coppens

SQL Tuning for Db2 - Where to Start by Eddy Coppens Even on the school benches I noticed that my teachers where not well taught themselves when it came to SQL. They just copied the text from their books onto the school board not giving us much insight on the matter. Once working for a...

Eddy Coppens's profile image

Blog Entry
The Db2 Parallel Universe

DB2/LUW is a relational database the can be used for many types of applications, from operational systems running very high number of users and transaction to data marts and large data warehouses. DB2 is particularly good at running complex query and analytical processing on a variety of...


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
“Guilty Until Proven Innocent”

The evolution of technology has driven the necessity for highly available systems and applications. Customer loyalty is directly related to their user experience which includes application functionality, performance and availability. Customer interfacing applications are often held to System...


Blog Entry
Some of my favorite tunings tips and tricks for DB2 by Joe Geller

Joe Geller discusses some favorite tuning tips for Db2 in this video recorded at IDUG EMEA in Lisbon last month. Enjoy! https://youtu.be/emVZ7eV07XQ

David Simpson's profile image

Blog Entry
Introduction to Db2 for z/OS System Profiles

System profiles are available as of Db2 for z/OS version 9, but they are still not widely used and known. However they represent quite a strong Db2 capability that can help you with a variety of needs such as managing and monitoring Db2 connections, modelling production environment, tuning...

Denis Tronin's profile image

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
SAP and DB2: Where are they headed?

When Oracle bought Peoplesoft, Siebel, and JD Edwards, an opportunity arose for IBM and SAP to work together to provide a superior ERP offering. SAP sales representatives received compensation for selling DB2, and many large companies migrated from Oracle to DB2. SAP and IBM have held joint...

Martin Hubel's profile image