I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. During that time, I’ve collected a lot of knowledge that makes my job easier and gets easier and gets the answers to the developer’s questions in a timely fashion.
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.