(Roger Sanders) This chapter introduces you to the backup and recovery tools that are available with DB2 universal database, and to show you how to both backup a database on a regular basis and restore a database if it becomes damaged or corrupted.

This two-part tutorial assists developers in developing DB2 Everyplace mobile applications using J2ME APIs and deploying the application in the J2ME Emulator using the J2ME toolkit. Part two builds an address book application to access an address book record store, perform updates to it and then syn

(Craig S. Mullins) Optimal database performance is perhaps the biggest challenge managers and administrators face as they work to ensure delivery of BI to data warehouse (DW) users. No one likes to wait for answers. Squeezing every last bit of performance out of the hardware and software to make tho

(Whei-Jen Chen) DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from MySQL to DB2 UDB Version 8.1 on Linux and how to convert applications to use DB2 UDB instead of MySQL.

(Drew Bradstock) In this tutorial, you’ll learn about using user-defined routines with the DB2 Universal Database. You’ll see how you can utilize programming logic within DB2 to simplify and speed up your applications. This is the last tutorial in a series of seven that you can use to help prepare f

(Howard Goldberg) Ever since the dot.com bust, IT departments have taken some blame for bloated budgets, missed delivery dates, and questionable returns. Leave it to Merrill Lynch to demonstrate how to get IT investments right. After developing a flexible, extensible data warehousing model, Merrill

(Sharon Lymer, Tinny Ng and David Stokes) Businesses today might not be buried in paper, but they are inundated with all sorts of digital content, from many different sources and in different formats. Employees struggle with managing the content, finding information, and overcoming technological cha

(Susan Lawson) Explore some of the more powerful features of DB2’s SQL language. Learn about the extended programming features, User-Defined Functions (UDFs), table functions, triggers, and user-defined data types (UDTs).

(Dwaine R Snow) While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally. This document is broken down into checks or ta

(Kulvir Singh Bhogal) A lot of ugly things can happen in the early morning hours when you are frantically trying to meet a deadline. For example, your mind can falter for a split second and you might accidentally drop an IBM DB2 Universal Database table. Before your stomach starts twisting in knots