In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11
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)