当一个数据库实用程序(例如备份、恢复、导出、导入和装载)启动时,才会按util_heap _ sz指定的大小分配全额的内存。
When a database utility is started, such as backup, restore, export, import and load, then the full amount specified by util_heap_sz is allocated.
DB2有一个非常高效的备份实用程序,它可以将从数据库读出的数据页分成多个部分,并以随机的顺序将它们写到目标设备。
DB2 has a very efficient and optimized backup utility that multiplexes the data pages it reads from the database and writes them to the target device in a randomized order.
这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用RUNSTATS实用程序。
These updatable views allow you to update certain statistical information to investigate the performance of a hypothetical database, or to update statistics without using the RUNSTATS utility.
因此,当您最开始在系统上加载负载之后,或者无论何时数据库中的数据量剧烈变化,都应该通过运行DB2RUNSTATS实用程序更新统计数据。
Therefore, after initially putting load on your system, or whenever the data volume in the database changes significantly, you should update the statistics by running the DB2 RUNSTATS utility.
进行节流的实用程序的一个例子是数据库备份。
这让 DBA 能够对数据库执行他们原来所做的所有操作(执行日常管理任务、装载数据、使用实用程序等等),但是不会看到或修改数据。
This enables DBAs to do everything to the database that they would ordinarily do-perform regular administration tasks, load data, use utilities-but not see or alter the data.
正如2.1节中提到的,要想让TM 1使用LDAP身份验证,必需的步骤之一是通过运行ETLDAP实用程序在TM 1数据库中创建用户和组。
As mentioned in section 2.1 to use LDAP authentication for TM1 one of the prerequisite steps is to run the ETLDAP utility to create users and groups in the TM1 database.
当ROLLFORWARD实用程序需要使用日志文件来恢复数据库时,就会检索它们。
They are retrieved when the ROLLFORWARD utility needs to use them to restore a database.
建议在运行离线重分发实用程序之前,对数据库进行完全备份。
It is recommended that you take a full database backup before running the offline redistribute utility.
如果系统内存不充裕,那么可以减少目标数据库中缓冲池的大小,因为DB 2LOAD实用程序不使用缓冲池。
If your system is constrained on memory, you can reduce the size of buffer pools in the target database because the DB2 LOAD utility does not use buffer pools.
该实用程序利用底层DB 2数据库生成序号。
This utility will take advantage of underlying DB2 database to generate the sequence Numbers.
记住:在填充数据库之后再运行RUNSTATS实用程序。
Remember: Don't run the RUNSTATS utility until after you have populated the database.
清单7显示了如何使用db 2 pd实用程序为数据库中的所有表上的索引获取该信息。
Listing 7 shows how to use the db2pd utility to get this information for all indexes on all tables in a database.
如果您已经有一个存在的数据库,并需要使用该存储过程所提供的功能,就需要在安装db 2V8.2.2之后使用db2updv8实用程序更新您的数据库。
If you have an existing database and you want to use the function provided by this stored procedure, you need to update your databases after you install db2 V8.2.2 using the db2updv8 utility.
我在 /etc/mail/mailertable文件中创建了一个新的mailer定义。然后,与前面所做的一样,使用makemap 实用程序更新 mailertable数据库。
I created a new mailer definition in the /etc/mail/mailertable file and updated the mailertable database, just as I did before, with the makemap utility.
throttling选项将根据当前的数据库活动级别,来限制实用程序所占有的资源数量。
Throttling limits the amount of resources taken up by a utility based on the current database activity levels.
BaseDbProvider 为使用MySQL数据库提供一个实用程序类。
The BaseDbProvider provides a utility class for working with MySQL databases.
这个php模块用两个实用程序函数连接MySQL数据库和断开连接。
This PHP module has two utility functions to connect to and disconnect from the MySQL database.
它是一个用来对Cloudscape数据库运行脚本的简单实用程序。
It is a simple utility for running scripts against a Cloudscape database.
例如,如果连接的是Oracle数据库,那么名为NVL的实用程序类函数返回nvl;如果连接的是DB2,那么返回COALESCE。
For example, a utility class function called NVL would return NVL if the database connection is with Oracle, and COALESCE if the DB connection is with DB2.
运行msgfmt命令行实用程序以创建在运行时使用的本地化的消息数据库。
Run the MSGFMT command-line utility to create the localized message databases used at runtime.
symfony 将根据模式构建模型,并且甚至可以使用命令行实用程序生成SQL脚本以根据模式定义创建数据库。
symfony builds the model based on the schema, and the command-line utility can even be used to generate SQL scripts to create a database based on the schema definition.
通过增加目标数据库的实用程序堆(utility heap),可以提高DB2LOAD 实用程序的性能。
The performance of DB2 LOAD utility can be improved by increasing the target database's utility heap.
决定实现一个实用程序类来进行数据访问的关键原因是,希望确保可以使用相同的类来连接任何类型的Domino数据库。
The key reason why we decided to have a utility class for data access was to ensure that the same classes could be used to connect to any type of Domino database.
基于上述参数,GenSequence实用程序会与库服务器数据库(LSDB)连接,并验证给定属性与给定项目类型相关联。
Based on these parameters, the GenSequence utility will connect to the Library Server database (LSDB) and verify that the given attribute is associated with the given item type.
因此,应该使用db2look实用程序提取源数据库中sales表的DDL。
Thus, you should extract the DDL of table sales in the source database using the db2look utility.
LotusMobileConnect附带有一个实用程序wg_ikeyman,用于管理密钥数据库文件。
Lotus Mobile Connect ships with a utility, wg_ikeyman, for managing key database files.
gperf实用程序可以为中小型数据库快速生成完美散列。
The gperf utility is tuned to quickly generate a perfect hash for small to medium datasets.
EXPORT实用程序执行从Unicode(数据库编码页)到 1252(客户机编码页)的自动编码页转换。
The EXPORT utility performs an automatic code page conversion from Unicode (database code page) to 1252 (client code page).
使用kdb5_util实用程序创建KDC数据库。
应用推荐