Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
A singleton SELECT - is this always the best solution for readability and performance? The article discusses a simple scenario, that shows that a singleton SELECT can result in surprising application behavior if not used properly.
A good application should be a good citizen in the environment it is living in. Applications must also cope with situations where some of the actions (like updating rows) may fail because of other applications doing the same task.