Notes from when I installed Jim Hees's db2loader Java code on ips03i on 7-19-2002. From inst1 on trantor, scp1 -p /home/inst1/v4/java/db2loader.class inst1@ips06i:/dfs/download scp1 -p /home/inst1/v4/java/com/delphion/db2loader/db2loader.jar inst1@ips06i:/dfs/download Logon as inst1 on ips03i, Patolis's DB2 machine, mkdir -p v4/java/com/delphion/db2loader mv /dfs/download/db2loader.jar v4/java mv /dfs/download/db2loader.jar v4/java/com/delphion/db2loader To use it or test it out, export CLASSPATH=$CLASSPATH:/home/inst1/v4/java/com/delphion/db2loader/db2loader.jar:/home/inst1/v4/java java db2loader which gave me this error message, java.lang.NoClassDefFoundError: com/delphion/db2loader/CmdLineRequest Apparently, the version of Java on ips03i cannot handle the jar file, probably due to a slight inconsistency with the fix-levels of Java on ips03i versus trantor. Instead, I copied all the class files over. Back as inst1 on trantor, scp1 -p /home/inst1/v4/java/com/delphion/db2loader/*class inst1@ips01i:/dfs/download then as inst1 on ips03i, mv /dfs/download/*class v4/java/com/delphion/db2loader then a java db2loader command gave me the usage information as it should, which was Usage 1 - XML Input File java db2loader -C collectionLoadRequest -X xmlfile [-U dbUser -P dbPassword -D db2Database] Usage 2 - Command Line (No XML Input File) java db2loader -T"loadfile1[=tbl1] loadfile2[=tbl2] ..." [-K primaryTbl -CHARDEL stringDelimiter -COLDEL columnDelimiter -U dbUser -P dbPassword -D db2Database] Defaults -X db2loader.xml -CHARDEL ~ -COLDEL | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Despite the help text, the proper command to load the 66,177-line load file was java db2loader -T /dfs/download/NPO.WO.imag.2002.fix.ld=IMAG -U inst1 -P inst1_password -D patent Note in particular, the space after the -T and the fact that the table name must be uppercased. This worked as expected, with these heartbeat messages, Start: 19-Jul-02 10:22:42 AM main thread done Table start: IMAG IMAG Read: 1008/66177 Ignored: 0 Del: 986-0 Ins: 997-0 Upd: 0-0 IMAG Read: 2004/66177 Ignored: 0 Del: 1972-0 Ins: 1993-0 Upd: 0-0 IMAG Read: 3000/66177 Ignored: 0 Del: 2961-0 Ins: 2989-0 Upd: 0-0 ... IMAG Read: 65004/66177 Ignored: 0 Del: 63134-0 Ins: 64993-0 Upd: 0-0 IMAG Read: 66000/66177 Ignored: 0 Del: 64071-0 Ins: 65989-0 Upd: 0-0 IMAG Read: 66177/66177 Ignored: 0 Del: 64239-0 Ins: 66177-0 Upd: 0-0 Table done: IMAG Read: 66177/66177 Ignored: 0 Del: 64239-0 Ins: 66177-0 Upd: 0-0 End: 19-Jul-02 10:53:35 AM Elapsed (min:sec) 30:52 Read: 66177/66177 Ignored: 0 Del: 64239-0 Ins: 66177-0 Upd: 0-0 Note that the counts in the heartbeat messages come after the title, e.g. the first heartbeat message says there were 1008 out of 66177 lines read, 986 lines deleted and 997 lines inserted.