with Tags: rid X
We’ve talked about CICS transaction performance improvements and security performance improvements. Now let’s check into the DB2 Sort Work, EDM, RID and Buffer Pools. DB2 Sort Work Pool The DB2 system work area consists of a number of DB2 DSNDB07 work...
from Blog: DB2 Performance Tuning
SergeRielau Tags: rid_bit rid to_rid rowid mon_format_lock_name mon_get_application_handl... mon_get_locks locktorow 1 Comment 2,768 Visits
DB2 provides a whole set of tools to analyze locks, but what is missing is a way to connect LOCKs easily with actual rows. So in this post I will try to fill that gap. As always we start with a simple running example. Given a PRODUCTS table with some rows in...
from Blog: SQL Tips for DB2 LUW