IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

How to specify TCBLIMIT for DB2CONN in CICS rgn started task


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Mike.Fulton

New User


Joined: 11 Jun 2014
Posts: 22
Location: Canada

PostPosted: Thu Feb 07, 2019 1:27 am
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8568
Location: Dubuque, Iowa, USA

PostPosted: Thu Feb 07, 2019 2:32 am
Reply with quote

Try using CEDA DEF DB2CONN for online resource definition of DB2CONN.
Back to top
View user's profile Send private message
Mike.Fulton

New User


Joined: 11 Jun 2014
Posts: 22
Location: Canada

PostPosted: Thu Feb 07, 2019 2:55 am
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8568
Location: Dubuque, Iowa, USA

PostPosted: Thu Feb 07, 2019 3:57 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts How to get RBA value from CICS EVENT CICS 4
This topic is locked: you cannot edit posts or make replies. Sample CICS Webservices Program CICS 1
No new posts parmeter existence bit for URIMAP in ... CICS 1
No new posts How to use CICS command CEBR on sdsf ... CICS 1
No new posts CICS file processing using applicatio... CICS 3

Back to Top