|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/15/2006 5:08:00 AM
Posts: 1,
Visits: 1
|
|
hello out there,
i'm re-importing data from dbase A to dbase B, exporting it using fload (in fastload format) and using mload to load them back.
the mload procedure (a script which uses mload) works in the same manner for every file to be loaded, such as dropping the manually-defined errortables and a worktable and later a definition of those. and usually, mload is happy although a 'drop table ' commands on errortables end with a failure message when they do not exist, but this apparently does not matter to mload.
however, there is a file I cannot get loaded (it is only this one file), mload does nothing say about a warning/error but when it is ready, it returns with errlevel=3 and the log table remains on the dbase (working table and the 2 errtables are dropped by mload as they're empty).
here the output snapshot:
----------
0006 .begin import mload db.tab
worktables db.tab_wt
errortables db.tab_e1
db.tab_e2;
...
**** 10:58:38 UTY0826 A checkpoint has been taken, recording that end of file has been reached
for IMPORT 1 of this MultiLoad Import task.
**** 10:58:38 UTY1803 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........ 106....... 106
Apply conditions satisfied:.......... 106....... 106
Candidate records not applied:....... 0....... 0
Candidate records rejected:.......... 0....... 0
**** 10:58:38 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING;
**** 10:58:39 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING END;
**** 10:58:40 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq, MLoadSeq)VALUES(130, 1,
30);
**** 10:58:40 UTY0817 MultiLoad submitting the following request:
ET;
========================================================================
= =
= MultiLoad Application Phase =
= =
========================================================================
**** 10:58:40 UTY0817 MultiLoad submitting the following request:
EXEC MLOAD db.tab;
**** 10:58:41 UTY0818 Statistics for table db.tab:
Inserts: 106
Updates: 0
Deletes: 0
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq) VALUES (115, 1)
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
END MLOAD;
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq) VALUES (120, 1)
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INS db.tab_l (LogType, Seq,
MLoadCkpt)VALUES(135, 1, :Ckpt);
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
========================================================================
= =
= MultiLoad Task Cleanup =
= =
========================================================================
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
SELECT COUNT(*) FROM db.tab_e1;
**** 10:58:41 UTY0821 Error table db.tab_e1 is EMPTY, dropping table.
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq, MLoadSeq)VALUES(125, 1,
1)
**** 10:58:41 UTY0817 MultiLoad submitting the following request:
DROP TABLE db.tab_e1;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
SELECT COUNT(*) FROM db.tab_e2;
**** 10:58:42 UTY0821 Error table db.tab_e2 is EMPTY, dropping table.
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq, MLoadSeq)VALUES(125, 1,
2)
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
DROP TABLE db.tab_e2;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq, MLoadSeq)VALUES(125, 1,
3)
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
DROP TABLE db.tab_wt;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 10:58:42 UTY0825 Error table statistics for:
Target table 1: db.tab
Number of Rows Error Table Name
============== ========================================================
0 db.tab_e1
0 db.tab_e2
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INS db.tab_l (LogType, Seq,
MLoadCkpt)VALUES(140, 1, :Ckpt);
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
INS db.tab_l (LogType, Seq) VALUES (125, 1)
**** 10:58:42 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 10:58:44 UTY0822 MultiLoad processing complete for this MultiLoad import task.
========================================================================
= =
= MultiLoad Task Complete =
= =
========================================================================
----------
please advise,
many thanks in advance!
|
|
|
|