Chapter 10. Maintaining, Backing Up, and Recovering Data

When working with a database, you insert, update, and delete data constantly. In the long run, you might find the performance of your queries start to degrade as more and more of these operations are performed. This chapter describes the DB2 utilities you can use to properly maintain your database to avoid these types of problems. In addition, while trying to improve the performance of your system, you might find that it would make more sense to move some data to a reporting system instead of keeping it in your day-to-day operations database, for example. DB2 has several utilities that can help you move data such as EXPORT, IMPORT, LOAD, and so on. Last, there is always some degree of risk ...

Get DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.