Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2007
    Posts
    6

    Unanswered: user level control the db2

    Hi All,

    Here my position is , so Plz help me. If u support me I will .

    here My problem is ..

    we are using db2 7.2.5 on rhel linux 7.3., Here My problem is. If the users connect the database more than 13 users. the data base is automatically log out the users. We check in db2. In my knowledge, i am not getting the problem for this one.

    So, Please let me know about this issue.

    Thanks & Regards.

  2. #2
    Join Date
    Mar 2008
    Posts
    136
    will you mention all related parameters
    u can get all from db2 get db cfg for <dbname>

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DB2 V7 is out of service for more than 2 years. You may want to consider upgrading to a more recent version like V9 or V9.5.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    check the MAXAPPLS in db cfg

    Quote Originally Posted by stolze
    DB2 V7 is out of service for more than 2 years. You may want to consider upgrading to a more recent version like V9 or V9.5.
    I would be surprised if he did not know that already
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by Cougar8000
    I would be surprised if he did not know that already
    I wouldn't.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jul 2007
    Posts
    6
    I CHECK THE MAX APPLS=512 in my database mentioned., AVG APPLS=1

    give me suggestion.

    Thank u

Posting Permissions

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