Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to specify TCBLIMIT for DB2CONN in CICS rgn started task

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Mike.Fulton

New User


Joined: 11 Jun 2014
Posts: 18
Location: Canada

PostPosted: Thu Feb 07, 2019 1:27 am    Post subject: How to specify TCBLIMIT for DB2CONN in CICS rgn started task
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: 8416
Location: Dubuque, Iowa, USA

PostPosted: Thu Feb 07, 2019 2:32 am    Post subject: Reply to: How to specify TCBLIMIT for DB2CONN in CICS rgn started task
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: 18
Location: Canada

PostPosted: Thu Feb 07, 2019 2:55 am    Post subject:
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: 8416
Location: Dubuque, Iowa, USA

PostPosted: Thu Feb 07, 2019 3:57 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Suggestion on KSDS VSAM READ in CICS subratarec CICS 5 Wed Feb 13, 2019 4:42 pm
No new posts Convert CICS Modules to AMODE ANY CICSWOLF PL/I & Assembler 6 Fri Feb 08, 2019 7:10 pm
No new posts CKTI not started in CICS 5.4 danik56 CICS 9 Thu Jan 31, 2019 12:13 pm
No new posts SAS Webinar - PROC REPORT: Getting St... vasanthz All Other Mainframe Topics 0 Wed Jan 30, 2019 11:38 pm
No new posts Forcepurge CICS transaction via JCL bhavin.mehta JCL & VSAM 4 Wed Jan 09, 2019 6:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us