DB 2LUW为您提供一种管理各种内存结构的简单方法，即自调优内存管理(STMM)。
DB2 LUW provides you with an easy way to manage various memory structures through self-tuning memory management (STMM).
另外，由于能够使用相同的sql语法，而且DB 2提供自调优和自动内存管理，开发团队可以快速地转移到DB2平台。
Plus, the ability to use the same SQL syntax will allow your development team to quickly shift to the DB2 platform with its self-tuning and automated memory management.
这些机制都为管理超量使用的内存提供了有效的框架，但它们都有一个共同的限制：必须由外部实体来配置和调优。
These mechanisms provide an effective framework for managing overcommitted memory, but they all share an important limitation: they must be configured and tuned by an external entity.
这个管理基础设施的一个调优技巧是关闭节点配置的自动同步功能。
A tuning tip for this management infrastructure is to turn off automatic synchronization of the node configurations.
因此，即使是技术最高超的管理员在某个时候调优过的系统，在另一个时候也未必是最优的。
Therefore, a system tuned by even the most skilled administrator at one point in time may not be optimal at another time.
我们将更深入地介绍它的工作方式，并讨论在管理和调优分页空间时需要使用的一些工具。
We'll dig deeper into how this works and discuss some of the tools you need to use to manage and tune your paging space.
监控和调优数据库配置参数，这部分按照重要性的顺序描述了一列数据库管理器参数和数据库参数。
Monitoring and tuning database configuration parameters, which describes a list of database manager parameters and database parameters in the order of importance.
任务包括计划并管理数据库、调优性能与容量、创建和维护索引并优化查询、监测、以及管理备份与恢复。
Tasks include planning and administering the database, tuning for performance and capacity, creating and maintaining indexes and optimizing queries, monitoring, and managing backup and recovery.
调优MQ队列管理器的日志记录。
对于每个数据库来说，调优参数、资源管理和日志会有所不同，并且可以在数据库级别上对其进行控制。
Tuning parameters, resource management, and logging can differ for each database and can be controlled at the database level.
我们来看看不同领域的一些工具，例如数据库创建和维护、网络、管理GUI、性能调优、数据移动和备份恢复工具。
We shall look at tools from different areas such as database creation and maintenance, network, administration GUI, performance tuning, data movement and backup-recovery tools.
检查监控数据是否正在帮助管理架构师调优基础设施，并帮助业务分析师重新定义优化的业务流程。
Find out whether monitoring data is helping the management architect in fine tuning the infrastructure, and helping the business analyst in redefining the optimized business processes.
XML任务：创建并维护具有XML数据的表和视图；创建并调优xML索引；查询并查看XML文档；存储并管理XML模式文档。
XML tasks: create and maintain tables and views with XML data; create and tune XML indexes; query and view XML documents; store and manage XML schema documents.
通常认为SQL查询的调优是程序员和开发人员的主要责任，但是数据库管理员也应积极参与该过程。
Tuning SQL query is often thought of as a major responsibility of programmers and developers, but database administrators should also be actively involved in this process.
更少的缓冲池和表空间，以及更少的页宽种类，可以导致更简单的物理数据库设计，从而更容易管理、维护和调优。
Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.
数据库管理员参与SQL查询调优的主要好处之一是，他们可以提出不同的观点。
One of the major advantages of having database administrators involved in SQL query tuning is that they can a offer different perspective.
本文将展示如何启用DB 29的一些特性，例如自调优内存管理和压缩，这些都是完成迁移后的工作。
This article shows you how to enable some of DB2 9 features, such as self-tuning memory management and compression, as part of the post-migration steps.
它们能够帮助开发人员和应用程序数据库管理员在开发周期的早期开始关注查询调优。
They can help developers and application database administrators focus on query tuning efforts early in the development cycle.
我们调优了几个数据库管理器和DOMINO数据库配置参数以实现最优性能，如表2所示。
We tuned several database manager and DOMINO database configuration parameters for optimal performance as listed in table 2.
有时，只有数据库管理员有权创建SQL并对SQL的性能进行调优。
Sometimes only database administrators are authorized to create and fine tune SQL for performance.
XML任务：创建并维护具有XML数据的表和视图；创建并调优xML索引；查询并查看XML文档；存储并管理XML模式文档。
XML tasks: creating and maintaining tables and views with XML data; creating and tuning XML indexes; querying and viewing XML documents; storing and managing XML schema documents.
如果使用持久化事件或活动，一定要记得调优mq队列管理器来优化日志。
If you're using persistent events or actions, it's important to tune the MQ queue manager to optimise logging.
在DB2 fori 上，物理设置和调优是在数据库环境之外完成的，应当参考IBM i 系统管理手册。
On DB2 for i, physical setup and tuning is done outside of the database environment. Consult the IBM i system management manuals.
ServerStudio帮助您管理数据库任务，比如存储管理、性能调优、进程和事件响应管理。
Server Studio helps you manage database tasks such as storage management, performance tuning, and process and event response management.
PerformanceOptimizationFeaturePack：提供工作负载管理服务和一套用于调优db 2数据库性能的报告和工具。
Performance Optimization Feature Pack: Delivers workload management services and a suite of reports and tooling for the performance tuning of DB2 databases.
可以使用vmo调优工具管理VPSS的调优。
自调优内存管理，可以占用最多 500MB 内存
Self-tuning memory management that can take up to 500MB of memory
它的用户界面使性能监控和调优变得非常简单，无论新手还是专家级数据库管理员都能够使用它。
Its user interface makes performance and tuning simple so that both novice and expert database administrators can use it. Performance expert can help you do the following.
调优数据库管理器代理程序的最大数目(maxagents)。
Tuning the maximum number of database manager agents (maxagents).
尽管前者可以通过使用Kerberos （参见参考资料）和类似的网络安全协议完成，但是后者需要特殊的管理调优。
While the former can be accomplished via use of Kerberos (see Resources) and similar network security protocol, the latter requires special administrative tuning.
应用推荐