October 2013
Beginner to intermediate
784 pages
20h 55m
English
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 ...