This is IBM's definitive guide to the newest version of DB2 Universal Database. It contains end-to-end coverage for every DB2 developer and administrator -- and for anyone who wants to achieve IBM DB2 certification. KEY TOPICS:Start with a detailed overview of the DB2 family of products, key DB2 concepts, and terminology. Next, walk through installing DB2, setting up DB2 clients (including ODBC support); and controlling data access through authentication, assigned authorities, and user/group privileges. Understand DB2 SQL in depth, including database objects, the Data Definition Language (DDL), reading and changing data, triggers, outer joins, OLAP SQL, table hierarchies, and concurrency. Master DB2 administration, including the physical placement of data for maximum performance; opulating DB2 tables with IBM's import and load utilities; monitoring, maintenance and tuning; logging; and effective database recovery techniques. Finally, master the basics of DB2 application development. Review each programming method and interface provided by DB2; master embedded SQL; then learn the basics of CLI, ODBC, JDBC, and ActiveX Data Objects. MARKET:For all DB2 Universal Database administrators, application developers, managers, and others interested in learning about DB2 or gaining official IBM certification.