Inadvertently dropping a database table can be catastrophic. Fortunately, DB2 has a built-in, easy-to-use dropped table recovery feature that can save the day. With some upfront work, you can make your critical tables recoverable.

Data loss and corruption are unfortunate realities that you need to guard against proactively. DB2's built-in backup and recovery features can recover your critical data from such calamities. This 10-Minute Solution explains and demonstrates DB2 backup and restore.

Hackers are constantly trying to break into your IBM DB2 Universal Database™. This 10-Minute Solution offers an introduction to the built-in data encryption/decryption features of DB2 with step-by-step instructions for encrypting the sensitive data you persist.

If you need to store XML data in DB2, translate XML to relational data, or shred relational data into XML, the XML Extender for DB2 is an essential utility. But it's not always straightforward. Find out what it can do and what problems to expect.

DB2 creates a plan for each dynamic SQL query you run. Evaluating this plan is one of the keys to query runtime efficiency. In this 10-Minute Solution, DB2 Pro Greg Nash shows you how to use DB2's explain facility to identify and correct the planning weaknesses that are slowing your queries down.

DB2 Pro Greg Nash teaches you to use DB2's OLAP functions to refine the data, then use FETCH FIRST to minimize the results.

Learn how and where your data is stored and how to manage it for better performance.

In this 10-Minute Solution, DB2 Pro Greg Nash will examine how DB2 can keep summary tables for you and have your answers waiting before you even ask.