Problem or error: When Netezza is the user database and in-database optimization is not enabled in
Campaign, the Select process sometimes returns incorrect results.
Solution: Configure the Netezza ODBC driver to have a prefetch count value that is a multiple of the value of the
BulkReaderBlockSize property (in versions of Campaign that use the
dbconfig.lis file, the name is
bulkreader_blocksize). For example, if the value of the
BulkReaderBlockSize property is
2500, the prefetch count can be
25000.