DB2 Application Environment

DB2 offers a rich application development environment that allows developers to build databases supporting requirements for e-business and business intelligence applications. 

Many of these tools are integrated with the database; the major tools, especially those that can be used with DB2 for z/OS, are reviewed next.

• DB2 Application Development Client is used for creating, testing, and debugging stored procedures on local and remote DB2 servers.
• DB2 Extenders enable the SQL API to access unstructured data types, including text, image, audio, video, and XML.
• DB2 Cube Views provide OLAP support in DB2 UDB, including features and functions that improve the relational database's ability for managing and deploying multidimensional data across the enterprise.
• DB2 OLAP Server provides the ability to build online analytical processing (OLAP) cubes using DB2 as the relational data store; a higher-end version of the DB2 OLAP Server is available to handle larger numbers of users.
• DB2 Data Warehouse Edition provides the ability to build data marts/warehouses by automating the processes involved in managing, refreshing, moving, and transforming data, including the ability to define the star schema model.
• QMF provides an integrated, powerful, and reliable query and reporting tool set for DB2 data. An optional QMF for Windows is available.

Created with Artisteer