The following problem affects Netezza releases 3.0.1 through 3.0.3. Netezza will be correcting this problem beginning with release 3.0.4.

When the Netezza driver PREFETCH value is less than the number of rows fetched from an answer set, Netezza rolls back the transaction. To avoid this problem, you can do any of the following:

• Set PREFETCH to a value greater than the number of records to be fetched. The default value is 256.
• Convert the report request to several smaller sub-requests, such that each fetches fewer rows than are specified by PREFETCH.