在您需要重新定位数据文件的情形下,您需要通过发出下面的命令来更新控制文件。
In cases where you need to relocate the data files, you need to update the control file by issuing the following command.
数据库服务器自动发出PREPARE命令,更新引用该表的任何编译过的对象。
The database server automatically issues the prepare statement to update any prepared objects that reference the table.
此命令更新了系统目录中的统计数据,优化程序使用这些数据来确定成本最低的查询计划。
This command updates the statistics in the system catalogs that the optimizer USES to determine the lowest-cost query plan.
下面的方法在对雇员数据的创建、更新和删除操作之间打印文本到命令行,并等待用户输入。
The following method prints text to the command line and waits for user input between the creation, update, and deletion of the employee's data.
例如,如果加载之后所有数据都在一个分区上,并从另一分区执行runstats,那么该命令将更新syscat .tables来表示该表的行数为零。
For example, if after a load all the data is on one partition and runstats is executed from another partition, it will update syscat.tables to show zero rows for that table.
强制更新数据库/索引可使用$sudoupdatedb命令,这也花不了多少时间。
forcing locate to update the database/index is done with $ sudo updatedb, and it doesn’t take a lot of time
您将使用这些命令来创建、读取、更新或者删除数据库中的记录。
You will use these commands to create, read, update, or delete records from your database.
它会通过套接字连接将数据发送给其他节点,然后接收响应,它会发出提交命令,这个命令实际上会更新这些节点。
This sends the data via socket connections to other nodes and upon receiving the response, it issues the commit which actually updates the nodes.
只有以下情况才能使用该命令:模式的改变是向后兼容的;已更新模式被自动应用到所有存储在数据库的XML文档。
This command can only be used in cases where the change to the schema is backward-compatible, and the updated schema is automatically applied to all XML documents that are stored in the database.
在这一部分中,我们将开发一个使用XMLToSQLAPI进行VIDEOS数据库更新的命令行应用程序。
In this section, we will develop a command line application program that USES the XMLToSQL API to update the VIDEOS database.
从DB 2CommandWindow发出以下命令,以更新数据库管理器配置参数。
Update the database manager configuration parameters by issuing the following command from the DB2 command window.
从DB2CommandWindow发出以下命令,以更新数据库管理器配置参数
Update the database manager configuration parameters by issuing the following commands from the DB2 Command Window
他打开一个命令行窗口,连接到SAMPLE数据库,并尝试更新employee表中的雇员工资(当然这样的尝试会遭到失败)。
He opens a command line window, connects to the SAMPLE database and unsuccessfully tries to update the employee salaries in the employee table. He issues the following SQL statements.
如果更改了SID,那么需要输入以下命令更新logarchmeth1数据库配置参数,使之指向新的SID。
If you changed the SID, you need to enter the following command to update the LOGARCHMETH1 database configuration parameter to point to the new SID.
如果在更新DB 2Express - c代码之后创建新数据库,这些数据库会自动地启用最新特性,所以不需要运行此命令。
If you are creating new databases after updating the DB2 Express-C code, these databases will automatically have the newest features, so you would not need to run this command.
某些情况下,reorgchk命令也可用来更新数据库统计,只需一个简单的命令,如清单11所示。
In some cases, the reorgchk command can also be used to update the database statistics with one simple command, as shown in Listing 11.
注意:使用命令db2 “getdbmcfg ”查看这些参数,并使用db 2 “update dbm cfgusing ”更新数据库管理器的配置参数。
Note: Use the command db2 "get DBM CFG", in order to look at these parameters and db2 "update DBM CFG using" to update a database manager configuration parameter.
自从最近一次更新过统计数据后,您是否想过您将要运行的update statistics命令是否真正必要?
Have you ever wondered if the update statistics command you are about to run is actually needed since the last time you updated statistics?
如要看对实体e JB Category Bean下的数据库表进行更新的效果,请登录到数据库的命令行界面,并输入以下sql语句。
To see the effect of updating the database table underlying the CategoryBean entity EJB, sign on to the database's command-line interface and enter the following SQL statement.
List:提供用来运行统计数据更新的命令。
List: Provides the actual "Execution Command" to run update statistics.
注意:使用命令db2 "getdbcfgfor "来查看这些参数,以及使用 db2 "update db cfg forusing ") 来更新数据库配置参数。
Note: Use the command db2 "get db cfg for " in order to look at these parameters and db2 "update db cfg for using ") to update a database configuration parameter.
还可以在Domino统计数据中检查复制条目(通过ShowStatReplica命令),了解添加、删除和更新文档的速率。
You can also review the Domino statistics for replica entries (via the Show stat replica command) and see the rate of documents being added, deleted or updated.
用runstats命令更新目录统计数据,以便优化器可以考虑这个新创建的索引。
Update the catalog statistics with the runstats command so that the optimizer can take this newly created index into account.
DB 2runstats命令更新概述数据库表及其相关索引的物理特征的统计数据。
The DB2 runstats command updates statistics that profile the physical characteristics of a database table, along with its associated indexes.
注意,在把db 2Express - c代码更新为新版本时,需要使用db2updv97命令更新现有的数据库。
Note that as you update your db2 Express-C code to a newer refresh, existing databases also need to be updated using the db2updv97 command.
StatisticsAdvisor会指出什么时候应该更新编目统计数据并生成所需的命令;您只需单击一个按钮即可。
The statistics Advisor will let you know when it's time to update those catalog statistics and generate the command to do so-all you have to do is click a button.
还可以选择“使用开放式并发”来指定希望命令确定在执行更新或删除操作前数据是否已经被修改。
You can also select Use optimistic concurrency to specify that you want the commands to determine whether the data has been modified before an update or delete operation is performed.
OAT 的AutoUpdateStatistics (AUS)组件根据特定的策略运行统计数据更新命令,从而简化 DBA的工作。
The Auto Update Statistics (AUS) component of OAT is used to simplify the work of the DBA by running the update statistics command based on specific policies.
这应该给你一个计划,所有的命令需要更新您的数据库上下文的当前版本。
This should give you a plan that has all of the commands needed to update your database to the current version of the context.
调停人可以操纵的应用数据通过发送通知将会触发命令来更新数据对象通过代理。
A mediator can manipulate application data by sending a notification that will trigger a command to update a data object through a proxy.
应用推荐