Open cursors limit with database node when connecting to Oracle

[Yonny Serrano]

An MQSI flow that is using database nodes to update an Oracle table.  It exceeds the open cursors limit defined in the actual parameters of the database.  The limit is 600 and we reach that with about 450 messages.

 

We are using MQSI 2.1 for AIX and DB2 ML U485544
AIX 4.3.3, MQSeries 5.3
The odbc driver in the AIX box is /usr/opt/wmqi/merant/lib/UKor816.s  date Jul 30 2002.

Oracle 8.1.6 running over HP-UX  B11.00
open_cursors   600
cursor_sharing  EXACT
cursor_space_for_time FALSE

 

The flow does two SELECT and one UPDATE and one INSERT.

If you need the ESQL code I could post it.

Any ideas will be apreciated.

Thank You,

Yonny.

"{-��-���~��jv��x2���j)b� b��.n�+��b�v�z��'^v)�������ڕK����ך���i�^j�m����%���r����b��m����f�������I��zƫr�