Oracle to DB2 UDB Conversion Guide2003

2.5 After the port

IBM offers a variety of products and solutions that extend the capabilities of DB2 UDB.

• Information integration: Integration of the information in the database with other data sources. Contains facilities for implementing replication and federation of data and databases.

• Content management: Management and coordination of sophisticated data types

• Business intelligence: Sophisticated querying and analysis of data

• Web integration: Inclusion of Web access to the database

• DB2 UDB Tools: Tools and utilities that assist you in using DB2 UDB

In addition to the fundamentals of database administration (establishing tablespaces, creating databases, maintaining indexes, and so on), do not forget these other key administrative functions:

• Backup and recovery: To prevent loss of data, you should have an adequate strategy for saving the data in your databases and for being able to restore it in case of a failure or error. The larger the amount of data you have, the longer and more sophisticated your strategy will become, especially if you need your database always on line. This section gives you some of the basics, and points you to much more information.

• Replication: The DB2 UDB replication feature enables you to transfer data between systems for the purpose of building new data stores, or for duplicating some, or all of the original data in another DBMS.

• High availability: High availability ensures that your data sources are always available for use (regardless of failures in hardware and software). This concept is closely related to the backup and recovery process, and is often implemented at the same time.

• Federation: Federation allows access to data in numerous, heterogeneous data stores from one query. This section introduces the federation concepts and guides you to resources that will assist in creating a federated design.