If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > How to get value of default db2set parameter?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-29-09, 05:26
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,570
How to get value of default db2set parameter?

Hi,
I have got from CICS admin, that for connection pooling I should set DB2_SERVER_CONTIMEOUT to 0. Executing "db2set -all" commnand on DB2 v9.5 FP2 on Linux this settings is not listed. So default parameter is taken.

How do I know which is default value for parameter if it is not specified?
Regards
Reply With Quote
  #2 (permalink)  
Old 02-02-09, 17:57
rodex2mail rodex2mail is offline
Registered User
 
Join Date: Nov 2008
Posts: 7
try with db2 get db cfg
Reply With Quote
  #3 (permalink)  
Old 02-02-09, 21:10
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by grofaty

How do I know which is default value for parameter if it is not specified?
I'm sure if it's a valid registry variable its default value is listed in the manual.
Reply With Quote
  #4 (permalink)  
Old 02-03-09, 00:11
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
I wouldn't normally look this up for you, but I was curious as to what is was:

DB2_SERVER_CONTIMEOUT

Operating system: All

Default: 180, Values: 0 to 32767 seconds

This registry variable and the DB2_DISPATCHER_PEEKTIMEOUT registry variable both configure the handling of a new client during connect time. DB2_SERVER_CONTIMEOUT allows you to adjust the time, in seconds, that an agent waits for a client's connection request before terminating the connection. In most cases, you should not need to adjust this registry variable, but if DB2 clients are constantly being timed out by the server at connect time, you can set a higher value for DB2_SERVER_CONTIMEOUT to extend the timeout period. If an invalid value is set, the default value is used. This registry variable is not dynamic
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old 02-03-09, 01:58
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
the books are very easy to use
see
DB2_SERVER_CONTIMEOUT

* Operating system: All
* Default: 180, Values: 0 to 32767 seconds
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On