The exciting new features of IBM DB2 express-c 9.5.2

Source: Internet
Author: User
Tags db2 db2 express ibm db2 new features

As you may already know, DB2 Express-c is the DB2 free community version. You can apply it to a product, or distribute it in an application system, or just use it for simple development purposes, and all of this is free! Although DB2 Express–c can only use two processors and 2G of memory, you can install it on servers of any size, and there are no restrictions on the size of the database. This is a fairly generous donation compared to the community version provided by other vendors.

The 9.5 edition of DB2 Express-c was released in November 2007. Since then, several important improvements and new features have been added to the new version of DB2 Express-c. Although these features were originally only in the DB2 billing version, they are now integrated into the latest release of DB2 express-c version 9.5.2.

By the time of writing, the DB2 express-c team was doing the final quality test for the official version of all the platforms supported by the Community edition, but this article was published earlier than expected, and the official edition has not yet been released, but you can still use the download from October 2008 DB2 The beta version of Express-c.

By using the new version of DB2 express-c You can fully experience the following new features:

DB2 text Search, which is newly integrated into this product, allows you to perform fast retrieval in a text column;

Task Management Scheduler allows developers to schedule tasks in a regulated manner;

Support localization-sensitive sequencing, supporting the ordering of local cultural habits;

PureXML enhancements, such as the LOAD function that supports inserting data into an XML document;

Many enhancements for JDBC, SQLJ and. NET clients and drivers.

In addition to the improvements to DB2 express-c 9.5 and the addition of new features, DB2 express-c 9.5.2 also patched the defects found since 9.5. For a repair list, refer to the "Reference resources" section of this article.

DB2 Text Search

DB2 Text Search should be the most important new feature in DB2 version 9.5.2. DB2 Text Search allows you to use SQL, sql/xml, and XQuery statements in the DB2 database to perform text searches on the data stored in the DB2 database. For example, suppose you have developed a WEB application for your company, an IT magazine. The company's Web site allows readers to comment on the article and store it in a table called Article, as shown in the following table:

Table 1. Structure of the Article table




varchar (30)


varchar (100)

101 The JOB market for Database professionals Awesome article! I ' ve been working as a DBA for ten years, and this one's right on the mark!
101 The JOB market for Database professionals What is the difference between a database Architect and a database Administrator?
105 Working with ORM frameworks Nice to know how are these frameworks work!
102 New with DB2 express-c 9.5.2 Glad to the new features coming out with the DB2 ' s new release. Hi ibm!
105 Working with ORM frameworks Great article. thanks!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.