If you do not have problems of storage, and you can use DASD, it is a better option unload the table to sequential file.
In case you had to use Tapes or Cartridge for problems of storage in the installation... probably if that serious better to access DB2 in cursor mode.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
I believe unload into flat file and process may be faster.
It may be. It would be worth a test or 2.
Also, if there is a high volume of data to be processed, using the unload will take the overhead away from the database leaving those resources for other tasks rather than possibly contributing to a bottleneck.