SQL Bulk Fetch error

[Vick]

Error Message:

RQP-DEF-0177 an error occurred while performing operation sqlbulkfetch status =-9
UDA-SQL-0107 general exception has occurred during the operation fetch

Solution:

In Oracle, change the cursor sharing mode to Exact.

Steps:

In the Oracle Manager Console, choose Instance > Configuration > All initialization parameters, and set the value to Force.

My Question: Can anybody tell me how do we go about to fix this problem for DB2 database ?

Any help is appreciated...

Thanks in advance,
Vivek Mody

[rajivgupta1107]

Hi
I am also getting the same error. May i know the cause for the same.

Also i am not having Oracle Manager Console, pls tell how to set the parameter value then.

Thanks
Rajiv Gupta

[rajivgupta1107]

I am getting the error in  the report.

Thanks

[rajivgupta1107]

Pls update me on the same.

Regards
Rajiv

[raro]

Hi,

Error Message:

RQP-DEF-0177 an error occurred while performing operation sqlbulkfetch status =-9
UDA-SQL-0107 general exception has occurred during the operation fetch

My Question: Can anybody tell me how do we go about to fix this problem for DB2 database ?

One reason could be that DB2 is forcing your application (cutting connection) because of excessive consumption of resources, e.g. CPU, IO, Rows in/Out - DB2 monitores resources with DB2-govenor.

Edit the DB2-Govenor settings, change them to a higher thresholds or temporarly disable the govenor at all to test if error is connected to these settings at all.

Let me know if this helped you.

regards,
RaRo