about DB2 Express v8.2 at 18:37

What's Cool about DB2 Express v8.2

You may have heard about IBM's new major initiative called "on demand." A significant part of this strategy is autonomic computing: software and hardware that is self-managing, self-tuning, and self-healing to reduce the cost and complexity of technology.

DB2 v8.2 has industry-leading autonomic tech

nologies that make developing and maintaining DB2 database applications easier. The entire list of new features in DB2 v8.2 is too substantial to list here. Instead, we highlight some key technologies that are relevant to the target audience of this book:

• Application development features: features that enhance developer productivity
• Autonomic features: features that are part of DB2's self-monitoring, self-healing, and self-tuning capabilities

Application Development Features

Application development tooling has been significantly enhanced with DB2 v8.2.

For Microsoft Visual Studio .NET Developers

• An enhanced .NET Data Provider that supports Microsoft's .NET Framework 1.1 and Visual Studio .NET 2003
• Support for Microsoft .NET CLR (Common Language Runtime) stored procedures and user-defined functions
• An enhanced DB2 development add-in for Visual Studio .NET 2003 that allows you to develop for DB2 seamlessly without leaving the Visual Studio .NET development environment

For Java Developers

• Improved DB2 Universal JDBC Driver that supports both JDBC type 2 (client-based) and type 4 (clientless) connections
• Support for Java Software Development Kit (SDK) 1.4.1

Autonomic Capabilities

DB2 provides many features to reduce the strain of database administration. These features work together to automatically manage the health of your database:

• Automatic database backup
• Automatic statistics collection
• Automatic statistics profiling
• Automatic reorganization
• Self-tuning backup and restore
• Autonomic log management
• Database Design Advisor
• Database Configuration Advisor
• Adaptive throttling utilities
• Health Monitor