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.
