IBM Licensed Programs: Database Products
550 AS/400e System Handbook
• Global Explain Facility: The global explain facility offers detailed information about
the access plans chosen by DB2 DataJoiner to process multi-vendor SQL statements.
This explain information helps users in their database design by allowing them to:
– Create more efficient database designs to achieve desired performance objectives
– Model the impact of environment changes on SQL statements
– Determine ways in which the performance of applications can be improved (adding
indexes or updating table statistics)
• Global Visual Explain: Global visual explain is an easy-to-use and robust tool for
analyzing and tuning multi-vendor SQL statements. This tool provides an intuitive
graphical view of the access plan chosen by the DB2 DataJoiner global optimizer for
an SQL statement.
Additional functions include:
• Full Local Database Functionality: DataJoiner provides a full-function,
industrial-strength relational database. It can be used to store query results, develop
and manage snapshots of data from different data sources, and support concurrent
transaction processing. The local database offers full backup and recovery, logging,
and locking subsystems. DataJoiner also includes a global visual explanation facility
and a global performance monitor.
• Extensive Tool and Application Support: DataJoiner is designed to support the
1000+ IBM and non-IBM query tools and application development tools that presently
support the IBM DB2 family. A complete list of these products is provided in the IBM
DB2 solutions directory. These tools include Decision Support tools like Microsoft
Access, Crystal Reports, and Lotus Approach. DB2 DataJoiner can also work with
such application builders as Power Builder, VisualAge, and VisualGen.
• Access to Non-Relational and Relational Data through 3rd Party Gateways:
DataJoiner is designed to support all the relational and non-relational data sources
supported by CROSS ACCESS Corporation's CrossAccess Data Delivery System,
Information Builders, Incorporated EDA/SQL, and the DB2 DataJoiner generic
application programming Interface.
The following licensed products are currently included in the DB2 DataJoiner product box.
• Net.Data: OS/2, AIX, and Windows NT platforms. Businesses today want to harness
the power of the Web to reach the global marketplace. With IBM Net.Data, it is
possible to build interactive Web-sites with data from the sources that are available
today such as relational data, file data, or even Lotus Notes data. Whether building
interactive catalogs of products, allowing customers to track orders, or conducting
electronic commerce, Net.Data-driven applications can make data available to (and
from) a worldwide audience.
It is also possible to leverage existing client/server applications to the Web using existing
business logic. Embed dynamic SQL, Java applets and JavaScripts, Perl, and REXX
To Next Page
Loading...
Need help?
General