Database 版 (精华区)
发信人: thank (飞云), 信区: Database
标 题: 关于DB2的LOAD(4)
发信站: 紫 丁 香 (Thu Oct 8 20:33:49 1998), 转信
During the Delete phase, all rows causing a unique key violation are
deleted. If a failure occurs, this phase should be restarted by you from
the beginning. Information on the rows containing the invalid keys is
stored in a temporary file. After you request a restart to begin at the
Delete phase, the violating rows are deleted based on the information in
a temporary file. You must not modify any data in any temporary files.
Also, you must restart the LOAD command with the same parameters, otherwise
the Delete phase will fail. If the temporary file has been modified, or
does not exist, you should restart the LOAD command at the Build phase.
Once the index is re-built, any invalid keys are placed in the exception
table if it exists, and duplicate keys are deleted.
--
※ 来源:.紫 丁 香 bbs.hit.edu.cn.[FROM: citslab.hit.edu.]
Powered by KBS BBS 2.0 (http://dev.kcn.cn)
页面执行时间:2.788毫秒