The DB2 DWB has been completely rewritten on the Eclipse platform whereas the

The db2 dwb has been completely rewritten on the

This preview shows page 45 - 47 out of 60 pages.

The DB2 DWB has been completely rewritten on the Eclipse platform, whereas the DB2 DC used to be based on Java-Swing classes. The new architecture allows for enhanced scalability and higher productivity of this tool. Unlike the DB2 DC, the DB2 DWB is a separately installable product (and it's free). You have to download it and install it separately with a DB2 Client. The DB2 DWB is kept as a separate installation in DB2 9 so that it can be updated more frequently than the data server itself. In addition to the features offered in the DB2 8 DC (mainly the building of stored procedures using Java and SQL/PL, and user defined functions and types), the DB2 DWB includes support for: A Data Development Project where you can logically group the development of routines, SQL statements, scripts, and XQuery statements. Tools to manage the life cycle of the objects in a Data Development Project. For example, routines can be copied or dragged from the Database Explorer view to a Data Development Project in the Data Project Explorer view. (You can also copy and paste or drag-and-drop routines between projects.) A content assistant that provides context sensitive SQL statement completion within the various editors for UDF, stored procedure, and SQL statement development. For example, when you enter a schema name followed by a period (.), the DB2 DWB will automatically enumerate the objects within the schema for easy selection. ibm.com/developerWorks developerWorks® DB2 planning Trademarks © Copyright IBM Corporation 2006. All rights reserved. Page 45 of 60
The ability to import routines into a Data Development Project. Using this feature, you can create a stored procedure or user-defined function by importing source files containing the routine's code or by selecting one or more existing routines from a project within the workspace. The deployment of routines to different data servers that aren't on the same platform. You can use the Deploy Wizard to deploy your routines to a DB2 data server from either the Database Explorer or Data Project Explorer views. For example, you can create a routine on a DB2 for Windows server and then deploy it to a DB2 for z/OS platform. You can even move routines from an Apache Derby/IBM Cloudscape data server to a DB2 for Linux, UNIX, Windows, or z/OS data server. You can also specify options for the deployment, such as how to handle duplicate routine names, error handling, and so on. A comparison utility that can compare the source code and attributes between two routines, and optionally synchronize the code contained within a Data Development Project. Performance Tuning. Users can launch the Visual Explain utility for DB2 z/OS and DB2 for Linux, UNIX, and Windows within a routine's body or a stand-alone SQL statement. (Visual Explain is launched as a separate application program.) For the development of SQLJ applications with features to generate an SQLJ template file with a wizard, automatic translation and compilation,

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture