DB2_UDB stage - Need help
Posted: Wed Apr 27, 2011 2:21 pm
I am trying to get familiar with DB2_UDB stage using one row to insert in table. But while running I am getting the warning "Warning: DB2BulkLoad.DB2_UDB_Load_0: SQL1325N The remote database environment does not support the command or one
of the command options" . Because of that I am not able to see any progress.
Some of the properties in my DB2_UDB stage are
LoadMethod: Sequential File
LoadImmediate : YES
Load from Client : NO
File Type of data format : DEL
Method : D (Default)
Load Mode :INSERT
MODE : LOAD_ONLY
Control file generated is having below contents
LOAD FROM /home/n87511/inpdata.dat OF DEL MODIFIED BY lobsinfile noheader SAVEC
OUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES /home/n87511/Log.txt TEMPFILES PATH /h
ome/n87511/ INSERT into GGDD.ELOAD_EMAIL STATISTICS NO COPY NO DATA BUFFER 0 S
ORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT
of the command options" . Because of that I am not able to see any progress.
Some of the properties in my DB2_UDB stage are
LoadMethod: Sequential File
LoadImmediate : YES
Load from Client : NO
File Type of data format : DEL
Method : D (Default)
Load Mode :INSERT
MODE : LOAD_ONLY
Control file generated is having below contents
LOAD FROM /home/n87511/inpdata.dat OF DEL MODIFIED BY lobsinfile noheader SAVEC
OUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES /home/n87511/Log.txt TEMPFILES PATH /h
ome/n87511/ INSERT into GGDD.ELOAD_EMAIL STATISTICS NO COPY NO DATA BUFFER 0 S
ORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT