如何使用ADMIN_MOVE_TABLE例程移动表和修改表属性?
How to use ADMIN_MOVE_TABLE routing to move tables and modify table properties?
可以使用 ADMIN_MOVE_TABLE 例程在线修改和移动表。
Tables can be changed and moved online using the ADMIN_MOVE_TABLE routine.
当到处移动表数据时,RUNSTATS和REORG实用程序都使用日志文件。
Both the RUNSTATS and REORG utilities use log files when moving table data around.
因此,如果源表在RI关系中为父表或子表,您需要捕捉外键定义并在移动表之后重新创建它们。
Therefore, if your source table was either a parent or child in an RI relationship, you need to capture the foreign keys definition and recreate them after the table is moved.
用于实际移动表的例程admin_move_table则随核心DB 2 9.7产品或更高版本附带。
The routine ADMIN_MOVE_TABLE that is used for the actual movement of the table is shipped with the core DB2 9.7 product or later.
清单3中的示例可以更快速地移动表,并保存名为 CUSTOMER_INFOAC61b#o的初始表。
The example in Listing 3 moves the table much faster and saves the original table with the name CUSTOMER_INFOAC61b#o.
例如,135代表中国移动通信公司,188代表中国联通。
For example, 135 is for the China Mobile Communication Corporation and 188 is for China Unicom.
降低磁盘资源争用的另一种可行办法是将信息传递引擎数据表和日志移动到文件系统中其他更快的驱动器上,或者使用远程消息传递数据库。
Another possible way to reduce disk contention is to move the messaging engine data tables and logs to separate, faster drives on the file system or use a remote messaging database.
您可以添加、配置、移动和重新放置表1中描述的小部件。
You can add, configure, remove, and reposition the widgets described in Table 1.
默认条件下,如果项目为移动设备进行了优化,那么HATS就不会包含一个空白的布局表。
By default, if the project is optimized for mobile devices, HATS does not include a free layout table.
移动注册表的位置。
移动开发的第一个变化是改善即用样式表,让它们在小屏幕上看起来也很舒服。
The first change to the mobile development story is improving the out-of-box style sheets so they look good on small screens.
一套各种各样的线框,比如产品详单,项目表,首页,移动电话。
A set of various wireframes, such as product details, list of items, front page, mobile phone.
注意:在分析数据库中,规则执行或列分析过程中创建的相关表是不能自动移动的。
Note: the associated tables that are created during the execution of rules or column analysis in the analysis database are not moved automatically.
DB 2现在提供把表在线移动到另一个表空间的功能。
DB2 now provides you with the capability to move tables online to a different table space.
表11说明在移动物理日志时需要提供的参数。
Table 11 includes the parameters you need to supply in order to move a physical log.
首先,您必须指定数据库名(想要移动的表所在的数据库)和要执行的操作(export 和 import或load)。
You must specify the name of the database whose tables you want to move, and the action (export, import, or load) that is to be performed.
db 2 move工具利用了db2的数据移动工具(export和import或load)来移动数据库表。
The db2move utility exploits the db2 data movement utilities (export and import or load) to move the database tables.
除了表3所示的键组合外,鼠标移动键,比如上、下、左、右,以及Home和end键都通常被设置为以逻辑方式工作。
Besides the key combinations shown in Table 3, cursor movement keys such as the right, left, up, and down arrows, and the Home and End keys are usually set to work in a logical way.
SQL描述的表和索引也可以通过对应的ALTERTABLE或 ALTERINDEX命令放置和移动。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
该示例移动同一个customer_info表,但是使用了LOAD选项,而不是INSERTFROM CURSOR选项,后者是默认配置。
This example moves the same CUSTOMER_INFO table, but it USES the LOAD option instead of the INSERT FROM CURSOR option, which is the default.
下一个示例演示了如何将 CUSTOMER_INFO表移动到新的表空间中
The next example demonstrates how to move the CUSTOMER_INFO table to a new tablespace
移动设备需要查看、更新和处理来自电子邮件系统、日程表、数据库和其他数据源的信息。
Information from E-mail systems, calenders, databases and other data sources is needed on mobile devices for review, update, and processing.
注意,这个操作是不可恢复的,因此如果需要将数据库恢复到完成表移动与备份之间的某个时间点,那么表可能会丢失。
Note that this operation is not recoverable, so if you need to recover your database to the point in time between the table move completion time and following backup, the table may get lost.
由于每个事件都是作为惟一的文档存放的,因此用户可以在不影响其他相关事件的情况下移动、删除或更新一个日程表事件。
Since each event is stored as a unique document, users can move, delete or update one calendar event without affecting the other related events.
在数据库和消息之间移动数据——应用程序需要将数据从JMS消息移动到数据库表,或者相反。
Moving data between a database and a message — an application may need to move data from a JMS message to a database table or vise versa.
我为这些地方列了张表,这样当冬天到来的时候,阳光和出门动机变少了,我就能用那张表欺骗自己移动。
I've started a list of these places so that, come winter when there's less sunlight and motivation to be outdoors, I have a cheat sheet for getting myself moving.
字母表中的每个字母都会触发火箭向前移动(参见图3)。
Each letter of the alphabet triggers a rocket headed for space (see Figure 3).
提交选择之后,它们才从CGTT移动到实际表中。
Once they commit their selections, they are moved from the CGTT to the real tables.
DB2更新当前表中的行并将旧行的副本移动到历史表中,记录系统时间起始值和结束值。
DB2 updates the row in the current table and moves a copy of the old row to the history table, recording the system time start and end values.
应用推荐