fastload錯誤 — RDBMS error 2634

標籤：style   blog   color   strong   width   os   

我們來看一下下面這條語句：BEGIN LOADING stu_fl
ERRORFILES error_1, error_2; 如果此時已經存在error_1或error_2表，那麼將會報錯，資訊如下：

0008 BEGIN LOADING stu_fl     ERRORFILES error_1, error_2;**** 07:41:08 Number of FastLoad sessions requested = 4**** 07:41:08 Number of FastLoad sessions connected = 2**** 07:41:08 FDL4808 LOGON successful**** 07:41:08 RDBMS error 2634: Existing ERROR table(s) or Incorrect use of stu_fl in  Fast Load operation.**** 07:41:08 Delete the Error Tables or fix the BEGIN LOADING statement

 

查了下手冊，錯誤碼2634的相關資訊如下： 2634 Existing ERROR table(s) or Incorrect use of %TVMID in Fast Load operation. Explanation: This error occurs if the table/error table(s) specified either;(a) existed before the start of the Fast Load, or(b) did not indicate that it was involved in this specific Fast Load.  Notes: This error means either that the user has referenced existing tables for the ERRORFILES in a Fast Load that is not restarting, or that incorrect tables werereferenced in a restart of a Fast Load.  Remedy: If this is not a restart of a previous Fast Load, delete the referenced error files. If this is a restart, correct the Begin Loading Statement so that the error files are those specified for the original Fast Load.  我們很明顯地可以看出，這個錯誤的原因是我們在不是restarting的fastload中，ERRORFILES引用了已經存在的表。   解決辦法： 在fastload開始之前加入以下語句刪除errorfiles所指定的表： DROP TABLE error_1; /* error table ,internal to fast load utility needed to be defined */DROP TABLE error_2; /* error table ,internal to fast load utility needed to be defined */   總結：BEGIN LOADING stu_fl
ERRORFILES error_1, error_2; 1. 在一個不是restarting的fastload中，如果errorfiles指定的表已經存在，就會報2634的錯；2. 如果fastload的過程中不出錯，error_1, error_2是不會自動產生的；3. 我們可以select * from error_1；查看相關的錯誤資訊；