|
View previous topic :: View next topic
|
| Author |
Message |
Mike.Fulton
New User
Joined: 11 Jun 2014
Posts: 22
Location: Canada
|
|
|
|
Hi
I am attempting to set up a DB2 connection in CICS. I have only coded:
DB2CONN=YES
in the SYSIN of my started task. When I start CICS, I am getting:
| Code: |
N 4020000 S0W1 19037 12:23:36.66 STC02608 00000090 +DFHDB2110I 02/06/2019 12:23:36 CS54GENA The total number of threads
S exceeds TCBLIMIT. |
It looks from this book:
https://www.ibm.com/support/knowledgecenter/en/SSGMCP_5.3.0/com.ibm.cics.ts.resourcedefinition.doc/resources/db2conn/dfha4_connattr.html
that I should specify a larger TCBLIMIT than the default of 12, but I can't figure out how to change the syntax from:
DB2CONN=YES
to specify the TCBLIMIT increase as well... Perhaps that isn't even where I put it but I haven't been able to figure this out from my scanning of the books. |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| Try using CEDA DEF DB2CONN for online resource definition of DB2CONN. |
|
| Back to top |
|
|
Mike.Fulton
New User
Joined: 11 Jun 2014
Posts: 22
Location: Canada
|
|
|
|
Hi
Thanks Robert. I did that and then shut down CICS and started it up again and I am still getting the same message - so I'm not sure if:
a) the setting is 'lost' on a restart of the region
b) it just isn't high enough yet (I set it to 100 - surely that should be enough?)
c) I am inadvertently overwriting the TCBLIMIT unknowingly on restart.
Alternately, is there a way to start Db2 from inside CICS after the fact? Db2 is failing to start (and I'm hoping it's because of this error - since I have no other errors I can see in my CICS startup)
thanks, mike |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| b) it just isn't high enough yet (I set it to 100 - surely that should be enough?) |
Use CEDA/CEDB/CEDC to check the DB2CONN THREADLIMIT and the DB2ENTRY THREADLIMIT (for each DB2ENTRY) and add up the values. Set the TCBLIMIT to more than that value. I can easily see needing more than 100 for TCBLIMIT. |
|
| Back to top |
|
|
|
|
