Search

1 to 10 of 22
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
Temporal Support of Db2 for z/OS – Part II

Temporal Support of Db2 for z/OS – Part II Temporal Logical Transaction Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Temporal Logical Transaction Background and Motivation Transactions are omnipresent in today’s database systems, providing data integrity...

Xiaohong Fu's profile image

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
SQL Tuning for Developers – Part 2 Explain Output

Introduction In Db2 the best way for any developer writing SQL queries to know how a query is gathering the data for a result set is through the Db2 explain tool. I find too many developers do not know what to do or where to start when it comes to SQL tuning, program tuning, or application...

Tony Andrews's profile image

Blog Entry
The Key To Mastering Db2 Locking On Row-Store Tables

by: Zoltan Toth, IBM and Michael Feng, IBM A database lock is a mechanism utilized by Db2 to govern the access to a database object amongst different transactions. The following is a list of objects that Db2 usually regulates via the usage of locks: - Table - Table partition -...

Zoltan Toth's profile image

Blog Entry
A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Steve Thomas of CA Technologies presents a great introduction into the world of locks, latches, claims and drains. A must see for all developers working wit Db2 for z/OS as well as all DBAs wanting to refresh their knowledge. This session will provide an introduction to how data integrity is...

Steve Thomas's profile image