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...
Temporal Support of Db2 for z/OS – Part III Temporal RI By Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Background and Motivation What is referential integrity (RI)? Referential integrity (RI) is the state in which all values of all foreign keys are...
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...
Temporal Support of Db2 for z/OS – Part I Temporal Auditing Enhancements in Db2 12 Continuous Delivery Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Abstract This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS...
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...
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...
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.
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...
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 -...
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...