Info Briefs for DB2 Universal Database

Informational briefs for DB2 Universal Database are simply brief introduction to a particular component or feature of DB2 UDB. If you would like to submit an info breif to be listed on this web page e-mail the brief, title, and author name to Webmaster. High Availability Disaster Recovery High Availability Disaster Recovery (HADR) is a new feature introduced in DB2 UDB v8.2 for Linux, UNIX, and Windows. It is an integrated feature that provides for both high availability and disaster recovery by replicating data from a primary database to a standby database. HADR provides data protection for both partial system failures due to hardware or software failures and complete site failures due to natural disasters. DB2 UDB also includes two new Wizards to configure and manage HADR that are accessed from the DB2 Control Center. Read more about High Availability Disaster Recovery in this info brief. Clustering for High Availability Clustering for high availability, sometimes called failover clustering, is much like the buddy system in scuba diving. The idea behind the buddy system is very simple. If your system fails (air supply) you will be down (unable to breath) for a short period of time (down time) until you are able to locate, notify, and gain access (fail over) to your buddy's system (air supply).Read more about Clustering for High Availability in this info breif. Log Shipping for High Availability Log shipping for high availability is the process of keeping a secondary database on a standby server synchronized with the primary database by transferring (log shipping) and applying the database transaction logs from the primary to the secondary database. The idea behind log shipping is to take the work load that has already been applied to the primary database server and ship it over to a backup system, via the database transaction logs, where it can be applied to a standby database so that in the event of a failure to the primary system the database on the secondary system is just about in the same state as the primary database was right before the system failure. Read more about Log Shipping for High Availability in this info brief. Data Replication Data Replication is the process of maintaining a defined set of data in more than one location. It involves copying changes from one database (a source) to another database (a target), and synchronizing the data in both locations. Data Replication is a component of DB2 UDB since v5 which allows you to publish replication sources and define replication subscriptions. These subscriptions are defined and managed using DB2's graphical user interface administration tool known as the DB2 Control Center. The actual subscription information is stored in Replication Control Tables which are automatically created by the DB2 Control Center the first time a replication source or target is defined. Read more about Data Replication in this info brief. Database Partitioning Feature (DPF) The Database Partitioning Feature (DPF) is an optionally licensed component of DB2 UDB v8.2 Enterprise Server Edition (ESE) for Linux, UNIX, and Windows. The DPF provides the ability to partition a database within a single server or across a cluster of servers providing scalability that can support very large databases, complex workloads, and parallelism for database administration tasks. Read more about Database Partitioning Feature (DPF) in this info brief. Large Memory Support Large memory support is critical for any database management system because simply put accessing data in memory is much faster than accessing it from disk storage. DB2 UDB v8.2 for Windows supports several features that allow it to address large amounts of memory. Read more about Large Memory Support in this info brief. Enhanced Security Features DB2 UDB v8.2 introduced a number of new or enhanced security features. Many of these features are designed specifically for the Windows platform. Read more about Enhanced Security Features in this info brief.