By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

Max number of Cursors?

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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**********************@g47g2000cwa.googlegroups. 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


Nov 12 '05 #2

P: n/a
Thanks Pierre..
From a former student...Cheryl Mitchell
Pierre Saint-Jacques wrote: 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**********************@g47g2000cwa.googlegroups. 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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.