Database 版 (精华区)
发信人: thank (飞云), 信区: Database
标 题: 关于DB2的LOAD(2)
发信站: 紫 丁 香 (Thu Oct 8 20:30:11 1998), 转信
During the Load phase, data is loaded into the table; index
keys and table statistics are collected if necessary. Save points,
or points of consistency, are established at intervals specified
by you in the SAVECOUNT parameter on the LOAD command. These points
of consistency are not established exactly on the number of rows
specified with the SAVECOUNT parameter; rather the number of rows
are converted to a page count, and rounded up to intervals of the
extent size. Messages let you know how many input rows were successfully
loaded at the time of the save point. If a failure occurs, you should
use the number of input rows at the last successful consistency point
with the RESTARTCOUNT parameter during a restart. If the failure
occurs near the beginning of the LOAD process and you were doing a
REPLACE, you might consider restarting the load using the REPLACE option.
--
※ 来源:.紫 丁 香 bbs.hit.edu.cn.[FROM: citslab.hit.edu.]
Powered by KBS BBS 2.0 (http://dev.kcn.cn)
页面执行时间:2.787毫秒