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