Skip to Main Content
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition
book

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

by Raul F. Chong, Clara Liu
October 2013
Beginner to intermediate content levelBeginner to intermediate
784 pages
20h 55m
English
IBM Press
Content preview from DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura
Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Publisher Resources

ISBN: 9780133461930Purchase book