Nine new features of DB2 9

The db2 Tutorial we are reading is nine new features of DB2 9.

This new data server is the first to achieve seamless interaction between Extensible Markup Language (XML) and relational data without considering the data format, platform, or location. More than 750 software developers from 8 countries have made great efforts to launch Viper. They have carefully designed and debugged it, strive to make it the preferred information engine in the SOA environment .? DB2 9 has made ten significant advances, including patented "pureXML" technology, groundbreaking "Venom" Storage compression, and enhanced automated data management capabilities.

1. New XML features:
Without the need to redefine the XML data format or place it in a large database object, IBM DB2 9 allows users to seamlessly manage common relational data and pure XML data. This capability is unique to Viper and will help customers increase the practicability, speed, and multi-functionality of their information, while greatly reducing management costs related to existing data management technologies. It will also significantly reduce complexity and reduce the time it takes for common developers to create "applications that access link data and XML data at the same time.

The new XML data type allows customers to store standard XML documents in hierarchical table columns.

Supports SQL statements and XML data types in SQL/XML functions.

Supports the new XQuery language developed by the World Wide Web Consortium (W3C. IBM DB2 9 allows customers to directly call the XQuery language. The calling function can extract XML data from DB2 tables and views.

Supports the retrieval of XML data, improving the query efficiency for XML documents.

It provides support for XML in the DB2 programming language and allows applications to integrate access and storage of XML and relational data.

2. New applications and development features:

Supports application development tools and new features of native XML data storage, allowing applications to access and store XML and related data.

DB2 Developer Workbench is a comprehensive development environment that can be used to create, edit, debug, test and deploy DB2 stored procedures and user-defined functions. You can also use Developer Workbench to develop SQL applications, create, edit, and run SQL statements and XML queries.

The enhanced DB2 driver for JDBC and SQLJ complies with the JDBC 3.0 specification. It also supports SQLJ statements.

The functions and features of SQLJ statements are similar to those of most JDBC methods.

In addition, it also includes other important features: support for many new data types, DB2's unique support to z/OS? The reliable connection method, heterogeneous combination, and connection reuse of the Data Server IBM DB2 9. In addition to Visual Studio 2005, it also supports Web services, local XML data storage, and the ability to build applications and Web sites without coding. The enhanced DB2 Runtime Client supports 64-bit computing and can coexist with other DB2 products on the same computer.

3. added the automatic database management function:

Adaptive and Self-tuning memory allocation. By constantly updating configuration parameters, adjusting the buffer pool size, and dynamically allocating available memory resources, you can simplify or eliminate the configuration of the DB2 server. The DB2 UDB automatic status detection function for z/OS objects allows users to create and change object policies in the control center wizard, automate the evaluation of object Maintenance policies by enabling DB2 UDB for z/OS objects.

Automatic Storage is supported to automatically expand the size of databases in disks and file systems. It can now be used for multi-partition databases.

Automatic statistical data collection, which is automatically started when a new database is created.

The prefetchers process and page cleaner are automatically configured according to the environmental characteristics of the DB2 database system.

New policy options for automatic table and index reorganization provide database administrators with more functions for managing table and index reorganization.

4. Enhanced Performance and scalability (storage compression, etc ):

Using row compression technology to compress data objects can help customers save disk storage space and speed up data access.

The statistical data view provides better access plans for improved query functions.

Use custom scripts or programs to speed up data loading.

Enhanced materialized query table (MQT) provides enhanced support for MQT design, better query performance, and better MQT maintenance.

A larger record identifier (RID) allows more data pages for each object and more records for each page in the system. On the one hand, it facilitates database administrators to use temporary tables of systems and users, on the other hand, it is easy to perform classification and login operations.

The index keyword can be up to 64 groups, and the size can be expanded to 8 KB.

5. New security features and enhancements:

Use label-based access control (LBAC) to improve row-and column-level data access control.

The authorization level of the new Security Manager (SECADM) puts several security-related priorities under a priority name, improving the control of access to information assets.

The "restriction" option added to the "create database" statement enhances control over database access.

The SETSESSIONUSER priority improves the control of the person with the power to change the session user's identity. It allows the person in charge of this power to convert to any authorized authorization ID.

The transfer ownership SQL statement provides the ability to change the permission of database objects.

6. Use table partitions to improve management of large databases:

Table Partitioning is a data organization plan in which table data is divided into multiple storage objects called table partitions or ranges based on multiple table columns. These storage objects may be stored in different or identical tablespaces, or both. Advantages of this new feature include:

A large table can be created. Partition tables contain much more data than normal tables. Dividing table data into multiple storage objects helps significantly increase the table size.

More flexible management capabilities. Now, you can manage individual data partitions and divide time-consuming maintenance operations into a series of small operations.

More precise control of index locations. You can manage indexes in different tablespaces.

Quick and easy access to or transfer data. This function is particularly useful in the data warehouse environment, where customers often move in or out of data and run queries that support decision-making.

Improved query functions. Table Partitioning separates data to avoid scanning irrelevant data, thus improving the query processing function.

7. Enhanced data recovery:

Restarting the interrupted recovery operation saves valuable time during database recovery and simplifies recovery.

Supports redirect recovery and automatically generates scripts from existing backup images.

Allows you to recreate a database from a tablespace backup image. This feature makes DB2 recovery more flexible and diversified, while providing customers with more comprehensive recovery solutions.

8. Enhanced self-management performance:

The adaptive and self-tuned memory allocation simplifies memory management. The Self-tuning memory provides dynamic configurations to actively respond to major changes in the workload characteristics.

When a customer creates a database, the automatic statistical data collection function is automatically started. With automatic statistical data collection, IBM DB2 9 automatically runs the RUNSTATS utility in the background to ensure correct statistics are collected and maintained.

Automatic Storage for multi-partition Databases. This function can automatically expand the capacity of databases in disks and file systems as needed.

The alter table statement enhancement allows you to change the attributes of some tables without having to stop or recreate a TABLE.

The new policy option provides the database administrator with the new automatic table and index reorganization function.

You can copy the database plan and create a module solution. Once the database administrator creates a module scheme, they can use it as a template for creating a new view.

The new management SQL routines and views provide a basic and easy-to-use programmable interface to facilitate the use of SQL to manage DB2.

The dynamic fast Communication Manager (FCM) buffer and new configuration parameters can be automatically adjusted through the DB2 database manager.

9. Enhanced installation performance:

New CLI Driver (for ODBC and cli ibm? DB2 driver), the customer can install this driver without installing the DB2 client software.

More flexible and effective product authorization management

You can install multiple DB2 versions and release packages on the same computer.

The new response file keyword allows IT staff to install DB2 without interacting with end users.

Automatic evolution-from Stinger to Viper

Based on the enhanced features released in version 8.2, the new automatic data management feature in IBM DB2 9 will continue to help improve the production efficiency and effectiveness of database administrators.

Some of the key features include:

Adaptive and Self-tuning memory allocation this new feature simplifies or eliminates the configuration of the DB2 server by constantly updating configuration parameters and adjusting the buffer pool size. Once started, this function dynamically allocates available memory resources between different memory consumption points. In Windows and AIX? In the operating system, the self-tuning memory function can also determine the database

[1] [2] Next