As far as I know, there is no hard limit. However, open cursors will block
their data in what is known as the RQRIOBLK (DB2 CFG parm.). One blk per
blocking cursor for each for each connection.
This block is allocated out of the query_heap in agent private memory. If
there's no room for it, DB2 will just not block the returning result set.
do: db2 upsdate monitor switches for statements on
db2 get snapshot for databse on <dbname> | more
The output will show you each of the statements that have blocking cursors
open as well as the total number of cursors open.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"cmitchell" <ch************ *@eds.com> a écrit dans le message de news:
11************* *********@g47g2 00...legr oups.com...
Hi just wondering where i can see the maximum amount of open cursors
allowed at one time? I am using DB2 UDB for Windows
8.1.5.
Thanks..
Cheryl