Skip to Content
author's profile photo Former Member
Former Member



one of our pre-prd database does not allow the new connection. After investigation we increase maxuproc value to 10000 for use db2<sid>. after that it allowed the connection.

Can somebody tell me why this is happening?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 06:06 PM


    maxuproc is an operating system limit , which controls the

    "Maximum number of PROCESSES allowed per user"

    With this limit reached for user db2<db2sid> , your db2 cannot create new processes , which could be necessary for the new connection .

    As you found out , you can customize this limit .

    An interesting point would be your former value of maxuproc before increasing

    Check also the following Notes for "Recommended Parameter settings" for your DB2 release

     899322	DB6: DB2 9.1 Standard Parameter Settings
     584952	DB6: DB2 UDB Version 8 Standard Parameter Settings

    Best regards


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Akki,

      the reason is that your application servers has opened more connections to the database. DB2 uses at least one process for each client connection. It needs more if you activate intra partition parallelism or you run on a partitioned database (used for SAP BI systems). In BI environment the developer are using more and more secondary connects. If you have upgraded your application, this could also a reason for more connections. If you don't run a BI system and you don't have changed the intra partition parallelism parameter, you probably have added SAP work processes or increased the number of Java connections. If none of this is correct, you should check which user and which client has opened the connections. Just do a [code]db2 list applications[/code] it'll show one line per connection. It shows also the client program opened the connection (second column). It should show only disp+work (dw.) or db2jcc_ and some db2 instance processes db2taskd and db2stmm. Every thing else should be investigated.

      May be you check your system with the following command:

      [code]> db2 list applications | sed -e '1,/^-----/d' | awk '{ user[$2]++; }END{ for (f in user) { printf "%-20.20s %d\n", f, user[f]; }}'[/code]

      It should show only processes like those I listed above.

      Best regards


  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 11:09 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.