SQL check for unused indexes!
Before dropping indexes, verify that following PTF's are installed.
RA10 PSY UK76968 UP12/03/27 P F203
R910 PSY UK76969 UP12/03/27 P F203
If not installed, LASTUSED is not being updated when an index is used to enforce a referential integrity constraint.
--------------------------------------------------------------------------------
-- Check for unused indexes
-- Before dropping indexes, verify that ... weiterlesen
Archiv: Mai, 2013
30
Mai2013
With EMEA annoucement letter ZP13-0262 (april 23rd 2013) IBM has announced  "DB2 10.5 with BLU Acceleration, the multi-workload database software for the era of big data, improves performance while helping to reduce storage costs".
New and improved DB2 capabilities:
Analytics at the speed of thought: DB2's new BLU Acceleration feature is in-memory ... weiterlesen
30. Mai 2013Gernot