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.
I know the trend is to use NoSQL for a lot of big data storage these days, but it isn’t necessarily the best way to go for every situation. At least not yet. For highly-available high-performance transactional systems we also need a great deal of reliability.
This is a follow-on entry to a previous one discussing how workload management and DB2 pureScale get along... it contains a first draft of a proposal for a workload management paradigm aimed at homogeneous workloads (e.g. OLTP)