IBM DB2
HomeSoftware SystemsDB2Tools & Components
The tools perform a range of functions, from automatically generating utility jobs, to capturing and analyzing performance data and making recommendations to optimize queries. They’re also unique in their ability to adapt to changing conditions, prevent failure and perform a host of other self-regulating tasks for your IBM DB2 Universal Database™ or IBM IMS environment.
IBM DB2® Tools and Data Management Solutions for Linux®, UNIX® and Windows® (LUW) can help DBAs stay in control of even the most complex database environments. Revenue-maximizing tools, such as DB2 Change Management Expert, DB2 Recovery Expert and DB2 Performance Expert help DBAs handle more complex tasks that are prone to human error and can compound into larger, more costly business mistakes if not handled promptly. Other high-value tools and solutions, including DB2 High Performance Unload, DB2 Audit Management Expert, Database Encryption Expert, IBM Optim™ Data Growth Solution and Optim Privacy Solution provide capabilities that allow DBAs to be free from routine or mundane tasks so they can focus on other critical data center issues.
Tools & Components Offered:
- DB2 and IMS Tools
DB2 and IMS Tools
Robust tools to streamline database administrationIBM DB2® and IMS™ Tools provide autonomic capabilities for your data center that can optimize IT resources and reduce management complexity with minimal human intervention. The tools perform a range of functions, from automatically generating utility jobs, to capturing and analyzing performance data and making recommendations to optimize queries. They’re also unique in their ability to adapt to changing conditions, prevent failure and perform a host of other self-regulating tasks for your IBM DB2 Universal Database™ or IBM IMS environment.
These tools arm database administrators (DBAs) to compete successfully in an environment of e-business on demand, in which companies strive to be more responsive and flexible in meeting customer needs. Unburdened by repetitive, time-consuming maintenance chores, DBAs can focus on higher-value tasks, helping their companies increase their return on their data center investment.
Highlights:
- Reduce data center complexity and optimize resources through autonomic features
- Provide multiplatform support for IBM DB2 Universal Database on Linux, UNIX and Microsoft Windows
- Boost the transaction-processing power of IBM IMS through performance-enhancing capabilities
- Support cross-tool integration for more manageable database environments
- Backed by services and support from the information management market leader
New offerings further enhance the tools portfolio
New tools include IBM DB2 Data Archive Expert, which enables you to move seldom-used data to a less costly storage medium without any programming, and IBM DB2 Test Database Generator, a tool that allows you to create test data on demand without disrupting your production system. Both of these tools includeDB2 Grouper, a table grouping feature that discovers relationships between tables from definitional as well as access sources. Also new is IBM DB2 Information Integrator Classic Federation for z/OS, which provides Web and distributed applications with read/write connectivity to mainframe databases.
On the IMS side, new offerings include IMS Performance Monitor for z/OS, which provides real-time status monitoring and alerts for an active IMS subsystem. This enables you to pinpoint potential issues before they become problems.
- DB2 Cube Views
DB2 Cube Views
Significantly lower the cost and development time to produce high performance datamarts and business intelligence solutionsIBM has taken a quantum leap into the future of business intelligence (BI) architectures by enabling you to dramatically improve OLAP query performance and accelerate online analytic processing (OLAP) deployments with DB2 Cube Views.
OLAP is a core component of BI. OLAP gives users the ability to interrogate data by intuitively navigating from summary to detail data. All OLAP solutions rely on a relational database management system (RDBMS) to source and dynamically query data and to support drill-through reports.
DB2 Cube Views is the latest generation of OLAP support in DB2 UDB and includes features and functions that make the relational database a first-class platform for managing and deploying multidimensional data across the enterprise. Armed with these facilities, architects can provide OLAP solutions that can be deployed faster, are easier to manage, and can improve performance across the spectrum of analytical applications regardless of the particular OLAP tools and technologies used.
Features
With DB2 Cube Views, the database becomes multidimensionally aware by:- Including metadata support for dimensions, hierarchies, attributes, and analytical functions
- Analyzing the dimensional model and recommending aggregates (MQTs, also known as summary tables) that improve OLAP performance
- Adding OLAP metadata to the DB2 catalogs, providing a foundation for OLAP that will speed deployment and improve performance
- Simplifying the exploitation of advanced DB2 technologies such as summary table management and analytical functions
Benefits
DB2 Cube Views provides value to IT managers by:- Leveraging existing SQL skills in the deployment of data warehouse projects
- Supporting numerous tools vendors to ensure interoperability of components
- Enabling centralized management of the data warehouse and business intelligence metadata
- Reducing roll out costs of business partner tools
- Increasing overall performance of the data warehouse
DB2 Cube Views is a unique integrated approach to OLAP and improves DB2 query performance.
DB2 Cube Views:- Enables the DB2 optimizer to rewrite incoming queries to take advantage of the MQTs that DB2 Cube Views recommends
- Loads cubes, performs drill-through queries and ad-hoc analysis directly to the relational tables in DB2
- Enhances all queries that use aggregate data
- Enables applications and tools to process the dimensional data in DB2 naturally, productively, and efficiently
- DB2 Extenders
DB2 Extenders:
DB2 Universal Database Extenders can take your database application beyond traditional numeric and character data to images, voice, video, complex documents, spatial objects and beyond.DB2 Extenders add to the relational database construct by giving you the capability to add and manipulate different data types. Because these extenders are designed for these data types, they can add more function and performance than simply cramming these data types into the existing DB2 databse.
Extenders:
- DB2 Net Search Extender - Adding parallel, scalable, rich full-text search enhances your database applications with the information that your users need. With V8, DB2 Net Search Extender provides query performance and scalability by integrating caching and optimization technologies. It is most appropriate for high end e-business applications that are database intensive, since it is designed to work closely with DB2 Universal Database applications.
- DB2 UDB for OS/390 and z/OS Net Search Extender - DB2 UDB for OS/390 and z/OS Net Search Extender contains a stored procedure that adds the power of full-text retrieval to Net.data, Java, or CLI applications integrated into DB2.
- DB2 Text Information Extender - Fully integrated into DB2, DB2 Text Information Extender V7.2 uses SQL to provide a powerful and flexible full-text search functionality.
- DB2 Text Extender - Closely integrated into DB2, DB2 Text Extender provides a powerful and flexible full-text search functionality. Using SQL for linguistic functionality enables thorough searching of documents where the need is complex and the quality and precision of the search results outweigh the retrieval time.
- DB2 UDB for OS/390 and z/OS Text Extender - Closely integrated into DB2, DB2 UDB for OS/390 and z/OS Text Extender provides a powerful and flexible full-text search functionality. Using SQL for linguistic functionality enables thorough searching of documents where the need is complex and the quality and precision of the search results outweigh the retrieval time.
- DB2 UDB Extenders for iSeries Text Extender - Closely integrated into DB2, DB2 UDB Extenders for iSeries Text Extender provides a powerful and flexible full-text search functionality. Using SQL for linguistic functionality enables thorough searching of documents where the need is complex and the quality and precision of the search results outweigh the retrieval time.
- DB2 UDB Extenders for iSeries XML Extender - Provides new data types to store XML documents in DB2 databases and new functions to work with these structured documents. Managed by DB2, these documents are stored as character data or external files.
- DB2 Intelligent Miner
DB2 Intelligent Miner
Tools for data analysis, modeling, scoring, and visualization.The DB2 Intelligent Miner products IM Modeling, IM Scoring, and IM Visualization are part of the DB2 Data Warehouse Enterprise Edition. The IBM DB2 Intelligent Miner family helps you identify and extract high-value business intelligence from your data assets.
Tools:
- DB2 Intelligent Miner for Data - Use DB2 Intelligent Miner for Data to gain new business insights and to harvest valuable business intelligence from your enterprise data. You can even mine high-volume transaction data generated by point-of-sale, ATM, credit card, call center, or e-commerce activities.
With Intelligent Miner for Data, you are better equipped to make insightful decisions, whether the problem is how to develop more precisely targeted marketing campaigns, reduce customer attrition, or increase revenue generated by Internet shopping. - DB2 Intelligent Miner Scoring - Extends database capabilities and enables users to deploy data mining analytics in real-time. You can employ these in business intelligence and operational applications to better serve business and consumer users alike - by providing more informed recommendations, more personalized treatment of business and consumer customers, or by continual model improvement in response to a specific situation.
- DB2 Intelligent Miner Modeling - Discover hidden relationships in your data without exporting data to a special data mining computer or resorting to small samples of data.
- DB2 Intelligent Miner Visualization - provides data mining model-analysis via a Java-based results browser. DB2 Intelligent Miner Visualization allows experts and non-experts to view and evaluate the results of the data-mining modeling-process.
- DB2 Intelligent Miner for Data - Use DB2 Intelligent Miner for Data to gain new business insights and to harvest valuable business intelligence from your enterprise data. You can even mine high-volume transaction data generated by point-of-sale, ATM, credit card, call center, or e-commerce activities.