ChannelDB2

Technical papers for DB2: March segment

Hello everyone!

 

 

I'm back with another installment of insightful and interesting articles about DB2. March saw a lot of new articles on a wide range of database subject matter.

 

Remember, if you don't find what you're looking for in my blog posts or on developerWorks, then reply to any of my posts and tell me exactly what you're searching for.

 

First, the big news: DB2 V10 has been announced!

http://www-01.ibm.com/software/data/db2-warehouse-10/

 

Feature highlights of the new release, available to users on April 30, 2012, are listed below:

 

DB2 eats data for lunch!

 

Back to our technical articles:

 

Moving a PHP application to DB2 from MySQL, Part 4: Deploy your application

Learn why you should move a PHP application to DB2, how to plan the migration, how to execute it, how to support it, and how to handle potential risks based on the experience of an IBM Intranet application case study. This four-part series shares lessons from a successful MySQL-to-DB2 migration for a mission-critical PHP Intranet application used by 4,000 global users within IBM to support content production for ibm.com. Part 4 describes the steps taken to deploy and support the application.

 

Migrate DB2 Net Search Extender indexes to DB2 Text Search

In order to leverage the latest capabilities in DB2 for Linux, UNIX, and Windows for full text search, users of DB2 Net Search Extender need to migrate to DB2 Text Search. This article explains how to migrate from Net Search Extender to DB2 Text Search indexes, and what to consider when planning your migration.

 

Best practices: Physical database design for online transaction processing (OLTP) environments

Understanding the basic concepts, the stages of physical database design, and the advanced aspects that affect the structure of databases is key for a successful database design.

 

Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio

The automatic maintenance capabilities of IBM DB2 for Linux, UNIX, and Windows relieve DBAs so that they can focus on other vital tasks such as maximizing performance. This article demonstrate how to configure the automatic maintenance capabilities in DB2 for performing database backups, keeping statistics current, and reorganizing tables and indexes as necessary, using IBM Data Studio.

 

DB2 Text Search, Part 4: High-availability setups with DB2 Text Search

DB2 Text Search enables creating full-text search applications in a DB2 Database for Linux, UNIX, and Windows. For scenarios where a high availability of the full-text search applications is required, a fail-over strategy must take into account that a DB2 Text Search setup involves two components, the DB2 database server and the text search server. Text search index catalog data and text search index administration data are stored in the database and included in the DB2 High Availability Disaster Recovery (HADR) strategy. However, the text search index collections are managed by the text search server and are located on the file system. An extension of the database HADR strategy is therefore required to include the objects managed by the text search server.

 

 

Also, did you know about the DB2 for Linux, UNIX, and Windows Information Roadmap? This page is a veritable cornucopia of information about DB2. Bookmark link:

http://www.ibm.com/developerworks/data/roadmaps/roadmap_db2.html

 

Finally, closing of today’s post with proof positive of DB2’s prowess: Coca-Cola Bottling Co. Consolidated (CCBCC), the largest Coca-Cola products, began their migration from Oracle Database to DB2 in 2007. Since then CCBCC has achieved more than $1 million USD in cost savings and significant performance gains. View the video:

http://www.youtube.com/watch?v=qma5TMpxtCY&feature=youtu.be

 

 

 

Cheers,

Farzana.

Views: 376

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service