自调优内存只适用于单一分区数据库。
Self-tuning memory only applies to single partition databases.
场景:希望将这个三分区数据库的名称从 PRODUCTS 改为 OLDPROD。
Scenario: You wish to change the name of this three partition database from PRODUCTS to OLDPROD.
如果在多个物理节点上运行DB 2分区数据库系统,那么必须在每个数据库主机上的相同路径中安装数据库软件。
If you are running a DB2 partitioned database system on multiple physical nodes, you must install the database software on each database host in identical paths.
数据库服务器在虚拟区中管理内存的分配和解除分配。
The database server manages the allocation and de-allocation of memory in this portion.
当创建该数据库时,该信任存储区由商业证书颁发机构提供的一套缺省密钥填充。
When the database is created, the trust store is populated with a default set of keys from commercial certificate authorities.
涂鸦的激增引起了新的工作来与之战斗,包括洛杉矶复杂的涂鸦识别数据库和波特兰布鲁克林邻区徒步巡逻的重新启用。
The surge has prompted new efforts to combat it, including a sophisticated graffiti-recognition database in Los Angeles and a reinstitution of foot patrols in the Brooklyn neighborhood of Portland.
以这种方式,页面在数据库中搜索,查找与用户在输入区输入内容相似的项目,如图2所示。
In this way, the page searches the database for items similar to what the user has already typed in an input field, as shown in Figure 2.
包括描述实例数据库的内存区。
This includes memory areas that describe the databases on the instance.
定位并修复数据库在约束、触发器、区(extent)和索引上的问题,同时可以让Toad直接利用OracleOCI调用获得对OracleAPI的完全访问。
Find and fix database problems with constraints, triggers, extents, indexes, and grants Toad utilizes direct Oracle OCI calls for full access to the Oracle API.
虚拟区可以通过数据库服务器得到较大扩展,并且可以通过操作系统将虚拟区页移出(page out)磁盘。
The virtual portion is quite expandable by the database server and can be paged out to disk by the operating system.
当创建表空间时,可以将它与特定的缓冲区池(数据库缓存)关联起来,并关联到特定的容器。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
可以在其中为消息传递引擎数据存储区指定数据源和数据库信息。
Here you can specify the data source and database information for the Messaging Engine data store.
需要缓存数据库或其他后端数据存储区中的数据,并需要以其他方式无法达到的速度访问这些数据?
Need to cache data from a database or other backend data store that needs to be accessed at speeds that would otherwise be unattainable?
以前尝试解决此问题时通常都依赖于采用某种形式的数据存储区访问,如关系数据库或队列。
Previous attempts at solving this problem have generally relied on some form of access to a data store, such as a relational database or queue.
日志缓冲区大小是由LOGBUFSZ数据库参数定义的。
The log buffer size is defined by the LOGBUFSZ database parameter.
如果一项修改的目标是减少数据库的内存占用量,那么取消各种缓冲区肯定会有帮助,但是这会牺牲查询速度和应用程序性能。
If the goal of a change is to reduce the memory footprint of the database, eliminating various buffers will certainly help, at the expense of query speed and application performance.
此组件提供分析数据库服务器性能所需的共享内存缓冲区信息。
This component provides the Shared memory buffer-related information required to analyze the database server performance.
与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
对于具有许多更新工作负载的数据库系统而言,下面日志缓冲区的默认大小(LOGBUFSZ)通常都太小。
The default size of the log buffer (LOGBUFSZ) below is normally too small for database systems with many update workloads.
如果超过这个缓冲区大小,数据库服务器会丢弃保存的数据。
If this buffer size is exceeded, the database server discards saved data.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
这将调出一个向导,指导我们完成必要工作区构件的生成和数据库连接属性的配置。
This brings up a wizard that will walk us through the generation of the necessary workspace artifacts and the configuration of the database connection properties.
该数据库有一部分称为密钥存储区,它包含用于对要发送的数据进行签名的所有证书。
The database has one section called the key store that contains all of the certificates that could be used to sign something to be sent out.
缓冲区的大小是由AUDIT _ BUF_SZ这个数据库管理器配置参数决定的。
The size of the buffer is determined by the AUDIT_BUF_SZ database manager configuration parameter.
日志缓冲区——在将所有对数据库的更改刷新到磁盘上的日志之前,用来存储这些更改的内存。
Log Buffer - Memory used to store all changes to database before it is flushed to the logs on disk.
当您在创建一个子工作区时,仍然没有数据被复制,在数据库中有一个指示符表示可以使用子工作区,而其内容被设置为读/写。
When a child Workspace is created, again no data is duplicated, there is simply an indicator in the database that a child Workspace is available, and that its content is set to read/write.
在增加LOGBUFSZ参数的值时,您还应该考虑DBHEAP参数,因为日志缓冲区使用来自数据库堆区域中的空间。
When increasing the value of the LOGBUFSZ parameter, you should also consider the DBHEAP parameter since the log buffer USES space from the database heap area.
在清单7中处理了两个操作:向工作区中添加资源和从数据库中删除资源。
In Listing 7 you process two actions: adding resources to and removing resources from the workspace.
当数据库服务器处于联机状态并执行操作时,如果虚拟区的初始尺寸太小,数据库服务器会自动向虚拟区附加其他操作系统段。
When the database server is online and performing operations, it automatically attaches additional operating-system segments to the virtual portion, if the initial size is too small.
就像城市地图按网格分成一些区一样,数据库管理器使用分区键来确定数据所存储在的位置(数据库分区)。
Just as a city map is organized into sections using a grid, the database manager USES a partitioning key to determine the location (the database partition) where the data is stored.
应用推荐