(Troy Coleman) Before an application can access a page of data, it must be read into a buffer pool. If the buffer pool is full, then DB2 must delete an existing page before it can read the new one in.
Other News
ACTIVE with Locks – Now thats a problem !
(Peter Zaitsev) One of item I always look at SHOW ENGINE INNODB STATUS to see if there are any transactions spending very long time in ACTIVE state. In the perfect world if you’re running online system you should not see transactions spending more than couple of seconds in ACTIVE state.
Install Optim Performance Manager 4.1.0.1, Part 1: Install
(Thuan Bui and Lakshmi Palaniappan) IBM Optim Performance Manager is a performance analysis and tuning tool for managing DB2 systems using a web interface.
Using EclipseLink MOXy with a Metadata Repository
(Blaise Doughan) EclipseLink JAXB (MOXy) provides an XML mapping document as an alternative to using annotations. This mapping document can be provided in many different forms: resource path, URL, File, Source, etc.
Index Management for Pre-packaged Products
SQL Server Disaster Recovery Expo Coming this Friday, June 17th. Register for the Expo and gain access to the insights and experience of Eight renowned experts in SQL Server Disaster Recovery including, Kevin Kline, Sarah Barela, Alan Berry and others. There is a free track for all members. Additional content is available in a premium track for those wishing to […]
How to Remove Index Fragmentation
SelecTViews With Stephen Wynkoop Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] How to Remove Index Fragmentation Index fragmentation occurs when the contents of an index are not contiguous as it is stored […]
Upgrade SQL Server; your BI system will thank you
(Don Jones) SQL Server is one of the least-upgraded components in an enterprise. You may think your company will never get off of Windows XP, but odds are you have versions of SQL Server older than that floating around, and there are no plans to upgrade them. After all, it’s easier to leave existing
Schema.org Can Be Useful, But RDFa Will Be Hard To Beat
(Jennifer Zaino) Jay Myers, lead web development engineer at Best Buy, acknowledged that he had to make some last-minute alterations to the presentation he gave yesterday at SemTech on the practical business uses of RDFa for search engines and beyond.
Getting the right statistics
(Hemant K Chitale) Continuing with the post titled “Nested Loops and Consistent Gets” earlier today, what is the Execution Plan with statistics on more columns?
When to Rebuild Secondary Indexes on Index-Organized Tables?
(Iggy Fernandez) For my new book on Oracle indexing, I’d like to provide guidance on detecting when the block references in a secondary index on an index-organized table (IOT) need to be updated.
