October 22, 2007

DB2 9 Fundamentals Exam 730: Section 1 DB2 Planning

Last week I explained the roadmap to DB2 Certification. This week I’ll examine the first exam, 730 “DB2 9 Fundamentals.” This exam is made up of seven sections (Planning, Security, Accessing DB2 Data, Working with DB2 Data, Working with DB2 Objects, Data Concurrency and Introducing Xquery). 

Today I’m going to review the planning section, which provides a good overall understanding of the different DB2 editions. Due to the amount of information covered in the planning section, I’ll review DB2 tools, data warehousing and online analytical processing at a later time.

I highly recommend downloading DB2 9 for LUW (Linux, UNIX and Windows) before you begin preparing for the exam. You can download DB2 9 Express-C at no charge. Remember: Learning about DB2 9 for LUW is a steppingstone to taking EXAM 732 DB2 9 Database Administration for z/OS.

DB2 Editions
• DB2 Everyplace  for PalmOS or Microsoft Windows CE/Pocket PC.
• DB2 Express, an entry-level full-function, Web-enabled client/server relational database management system for Windows and Linux.
• DB2 Express-C, a special free version of DB2 Express designed for partners and developers.
• DB2 Workgroup Edition, an entry-level server intended for small business and departmental computing. Provides features of DB2 Express with the option to add features to allow for extended capabilities such as those found on DB2 Enterprise.
• DB2 Enterprise Edition, available on Linux, UNIX and Windows is intended for large and mid-sized departmental servers. Includes everything in DB2 Express and DB2 Workgroup plus enterprise features such as Storage Optimization.
• DB2 Enterprise Developer Edition, a special offering available for application developers. This offering includes everything needed to build the latest data server technologies with a reduced-price offering. The products in this offering are restricted to application development, evaluation, demonstration and testing.

DB2 Client
• DB2 9 Runtime Client, best option if you only need to provide connectivity to DB2 data servers. Doesn’t include administration tools.
• DB2 9 Client includes all of the functions found in runtime client plus GUI tools to help in client-server configuration, database administration and application development.
• Java Common Client (JCC) provides a 2 MB fully redistributable client for SQLJ and JDBC applications. However, if you’re connecting to DB2 for System i or System z data server, you must purchase DB2 Connect.
• DB2 9 Client Lite is new in DB2 9 and provides a redistributable client for CLI/ODBC applications.
• DB2 Connect provides connectivity to z/OS and i5/OS from Linux, UNIX or Windows platforms.

DB2 Extenders
The DB2 extenders provide added functions to the underlying data server that takes your application beyond the traditional numeric and character data:

• XML Extender provides data types that let you store XML documents in DB2 and adds supporting functions to work with these XML documents. (A note about pureXML: Do NOT confuse pureXML with XML Extenders! The pureXML feature enables DB2 servers to leverage a new hybrid storage engine that stores XML in native format.) 
• DB2 Net Search Extender provides high-performance text search for columns containing character large object data or XML data. This is a free add-on with DB2 9.
• DB2 Spatial Extender provides for the storage, management and analysis of spatial data (information about geographic coordinates).

I hope you’ve taken the time to download DB2 9 and start playing with it. The Control Center has a lot to offer to both the DB2 for LUW and DB2 for z/OS DBAs and developers.