DB2 Workgroup Server Edition

XML database management with DB2 pureXML

• Process and manage XML data in its native hierarchical format for more sophisticated business capabilities.
• Integrate XML data intact into a relational database structure, allowing users to take full advantage of the relational database capabilities.
• Manage both relational and XML data for better runtime performance and reduced storage and development costs.

Time Travel Query and backup compression capabilities

• Use the Time Travel Query feature to reduce development costs and improve efficiency when working with temporal data.
• Help reduce data storage needs by providing data compression on backup systems to reduce the use of expensive disk space.
• Utilize compression on storage subsystems to produce storage reductions that can result in substantial cost savings.

High availability and disaster recovery functions

• Keep critical databases highly available and reduce the costs of planned and unplanned downtime.
• Allow failover from a primary or standby server to be accomplished quickly, resulting in less downtime.
• Work with an intuitive utility to guide you through the steps to set up and configure primary and standby servers.

Data access at your fingertips

• Synchronizes data seamlessly between mobile devices and the main system with IBM Mobile Database and IBM Mobile Database Synch technology.
• Offers toolkits and database connections tools to help ensure the right data is delivered to the right mobile devices quickly and transparently.

Efficiency enhancements, autonomic tasks and security features

• Use self-tuning memory management and other autonomic features to significantly reduce daily database maintenance expenses.
• Make it easier for non-DB2 developers to write applications for DB2 with their existing skills. Save time with procedure-building and debugging features.
• Help protect data with authentication, encryption and authorization checks to reduce the risk of unauthorized, undetected data access.
• Work with an audit facility to monitor data access and maintain a record of activities on the database system.
• Take advantage of automated tasks, including memory allocation, storage management and business policy maintenance to free time for database administrators (DBAs) to focus on strategic projects.