Stored procedures for retrieving and updating automatic maintenance policies
用于检索和更新自动维护策略的存储过程
Policy: BLOB of maximum 2m that specifies the automatic maintenance policy in XML format.
policy：以xml格式指定自动维护策略的BLOB，最大为2m。
Deploy automatic maintenance polices to any database using a script or programming language.
使用脚本或编程语言向任何数据库部署自动维护策略。
The following table summarizes the control mechanisms relevant to each automatic maintenance operation
下表总结了与每个自动维护操作相关的控制机制
Any user who has EXECUTE privilege on these procedures can read or update automatic maintenance policies.
拥有这些过程的EXECUTE权限的任何用户均可以读取或更新自动维护策略。
This article provides in-depth information about the new stored procedures and the automatic maintenance policies.
本文给出了有关新的存储过程和自动维护策略的详细信息。
Note: The maintenance window is not an automatic maintenance policy, but it is configurable using the same interface.
注意：维护窗口并不是自动维护策略，但是可以使用相同的界面进行配置。
The automatic maintenance policies contain the same configuration information that can be set using the Control Center.
自动维护策略所包含的配置信息与使用ControlCenter设置的信息相同。
Refer to the DB2 documentation for further details on the configuration parameters used to enabled or disable automatic maintenance.
请参考DB2文档，获得有关启用或禁用自动维护特性的配置参数的详细信息。
The maintenance window policy is used to specify a period of time during which DB2 may schedule and run automatic maintenance tasks.
维护窗口策略用于指定DB2可以调度并运行自动维护任务的时段。
To enable a given automatic maintenance feature, the corresponding configuration parameter and all higher level switches must be set to ON.
若要启用某个指定的自动维护特性，必须将相应的配置参数和所有较高级别的开启特性设定为 ON。
DB2 9.5 provides the following stored procedures for updating and retrieving automatic maintenance policies and the maintenance Windows.
DB 2 9.5提供了以下存储过程，用于更新和检索维护策略和维护窗口。
Policy: an output argument of type BLOB of maximum 2m that specifies the automatic maintenance Settings for the given policy type, in XML format.
policy：blob类型的输出参数，将以xml格式指定给定策略类型的自动维护设置，最大大小为2m。
To set up the SAMPLE database for automatic statistics collection, set the database configuration parameters for automatic maintenance switches as follows.
为了设置SAMPLE数据库自动进行统计信息收集，需要为自动维护开关设置数据库配置参数，如下所示。
In DB2 9.5, the configuration for each automatic maintenance task can be expressed as a very simple XML document, referred to as an automatic maintenance policy.
在DB 2 9.5中，每个自动维护任务的配置可以通过一个非常简单的XML文档表示，称之为自动维护策略。
For example, if you set AUTO_MAINT to a value of OFF, all other automatic maintenance parameters are considered to have an effective value of OFF, regardless of whether or not they are set to on.
例如，如果将AUTO_MAINT的值设定为OFF，则其他所有自动维护参数的有效值均被视为OFF，无论它们的值是否被设定为ON。
The design of a real-time network database structure and its implementation method will determine, to a great extent, the performance of an automatic maintenance and switching scheduling system.
实时网络数据库的数据结构设计和实现方法在很大程度上决定了计算机辅助的检修票和操作票开票软件的成败与效果。
The following diagram (only showing the statistics collection and profiling options) shows the hierarchy of automatic maintenance commands for statistics collection and profiling and the dependencies.
下图（只显示统计信息收集和配置选项）展示了统计信息收集和配置的自动维护命令的层次结构和相关性。
The following diagram (only showing the statistics collection and profiling options) shows the hierarchy of automatic maintenance commands for statistics collection and profiling and the dependencies.
下图（只显示统计信息收集和配置选项）展示了统计信息收集和配置的自动维护命令的层次结构和相关性。
应用推荐