Ginny,
I haven't messed around in this area in a long time, but if the CICS-DB2
attach hasn't changed, look at the startup values you are feeding CICS for
it's attachment to DB2. It used to be that CICS created a bunch of TCB's
for executing SQL. Each one of the TCB's would open a connection to DB2.
When the CICS main task needed to execute an SQL statement, it would select
an open DB2 task, and use that. The attachment facility would increase and
decrease the number of tasks active depending upon the workload, if I
remember correctly. It always tried to keep a certain number ready for use,
so SQL didn't have to queue up in the CICS addr space. Defaults were pretty
generous, if I remember right. This may be what you are seeing.
--Dave Day
----- Original Message -----
From: "Ginnie Nuckles" <[EMAIL PROTECTED]>
Newsgroups: bit.listserv.ibm-main
To: <[email protected]>
Sent: Thursday, October 12, 2006 12:50 PM
Subject: DB2 Threads
When trying to simulate workload between 2 cics regions (1 for web 1 for
db2) I am seeing a large number of DB2 threads in use (anywhere from 30 to
70) when as the number of users starts to grow (say around 150users)..
but
a little while after I hit max users (200) the number of DB2 threads drops
to 5 - 8 ?? a drastic reduction, yet the workload doenst seem to diminish
on the web cics region .. can anyone tell me why this might be happening
??
thanks
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
