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.
It has always been very important to understand when any changes in your database's configuration are made – some changes can have huge consequences. This article presents a methodology for monitoring your databases' configuration and detecting when changes have been made.
Database administration refers to a set of tasks that is related to the setup, configuration and maintenance of a database and/or its software. Understanding and defining the different tasks and roles within database administration is critical; learn about best practices for a modern company.
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)