Page 1 of 1

DB2 Bulk Loader or DB2/UDB stage

Posted: Mon Jan 08, 2007 9:51 am
by fmartinsferreira
I need to read from a sequential file and insert in a db2 table.

What is better to use in the target "DB2 Bulk Loader" or "DB2/UDB stage"
?

Regards,

Fernando

Posted: Mon Jan 08, 2007 10:10 am
by DSguru2B
It depends upon your datasize. Also depends if your dba will be fussy about giving you load permissions. Bulk loader will be much faster. Inserts will be slow. But if data size is small use the API else use the bulk loader.