Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: 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

  2. #2
    Join Date
    Nov 2008
    Posts
    7
    try with db2 get db cfg

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •