Automatic statistics collection, Related concepts

Protect your data by planning and implementing a disaster recovery strategy for your system. If suitable to your needs, you may incorporate the automatic database backup feature as part of your backup and recovery strategy.

If the database is enabled for roll-forward recovery (archive logging), then automatic database backup can be enabled for either online or offline backup. Otherwise, only offline backup is available. Automatic database backup supports disk, tape, Tivoli Storage Manager (TSM), and vendor DLL media types.

Through the Configure Automatic Maintenance wizard in the Control Center or Health Center, you can configure:

vThe requested time or number of log pages between backups

vThe backup media

vWhether it will be an online or offline backup.

If backup to disk is selected, the automatic backup feature will regularly delete backup images from the directory specified in the Configure Automatic Maintenance wizard. Only the most recent backup image is guaranteed to be available at any given time. It is recommended that this directory be kept exclusively for the automatic backup feature and not be used to store other backup images.

The automatic database backup feature can be enabled or disabled by using the auto_db_backup and auto_maint database configuration parameters. In a partitioned database environment, the automatic database backup runs on each database partition if the database configuration parameters are enabled on that database partition.

Related concepts:

v“Developing a backup and recovery strategy” in Data Recovery and High Availability Guide and Reference

v“Automatic statistics collection” on page 36

v“Catalog statistics” in Performance Guide

v“Table and index management for MDC tables” in Performance Guide

v“Table and index management for standard tables” in Performance Guide

v“Table reorganization” in Performance Guide

v“Health monitor” in System Monitor Guide and Reference

Related reference:

v“auto_maint - Automatic maintenance configuration parameter” in Performance Guide

Automatic statistics collection

The DB2 optimizer uses catalog statistics to determine the most efficient access plan for any given query. Having out-of-date or incomplete statistics for a table or an index could lead the optimizer to select a plan that is not optimal, slowing down query execution. However, deciding which statistics to collect for a given workload is complex, and keeping these statistics up to date is time-consuming.

With automatic statistics collection, part of DB2’s Automated Table Maintenance feature, you can let DB2 determine which statistics are required by your workload and which statistics need to be updated. With automatic statistics collection

36Getting started with DB2 installation and administration

VERSION 9 specifications

IBM VERSION 9 is a significant advancement in IBM's product line, boasting a range of features and technologies designed to enhance performance, security, and usability in enterprise environments. This version marks a pivotal shift, focusing on integrating artificial intelligence, cloud computing, and advanced data analytics into its core functionalities.

One of the standout features of IBM VERSION 9 is its enhanced artificial intelligence capabilities. With built-in AI tools, users can leverage machine learning algorithms and natural language processing to automate tasks, gain insights from data, and improve decision-making processes. These capabilities are not only geared towards data scientists but are also accessible to business analysts who may not possess deep technical skills, thereby democratizing access to AI-driven analytics.

Another defining characteristic is the robust cloud integration. IBM VERSION 9 seamlessly supports hybrid cloud architectures, allowing organizations to operate across private and public cloud environments with ease. This flexibility enables businesses to optimize their resources, manage workloads more efficiently, and ensure data is stored and processed in the most suitable environment. Enhanced security protocols and data encryption mechanisms further ensure that sensitive information remains protected both on-premises and in the cloud.

The release also emphasizes improved performance optimizations, utilizing cutting-edge technologies such as in-memory computing and parallel processing. These enhancements result in faster data processing speeds and reduced latency, ultimately leading to improved user experiences across applications. Additionally, the system supports a variety of programming languages, allowing developers to use their preferred tools while building applications that harness the full potential of IBM VERSION 9.

User experience is another area that received attention in this version. The interface has been streamlined and made more intuitive, enabling users to navigate through features and functionalities easily. Training resources and documentation have also been improved, providing comprehensive support to ensure users can maximize the capabilities of IBM VERSION 9 without steep learning curves.

In summary, IBM VERSION 9 brings together a suite of advanced features, including enhanced AI capabilities, robust cloud integration, improved performance, and a user-friendly interface, making it a powerful tool for modern enterprises seeking to harness technology for competitive advantage. With these innovations, IBM continues to position itself as a leader in the tech industry, addressing the evolving needs of businesses worldwide.