Results 1 to 2 of 2

Thread: User Limit?

  1. #1
    Join Date
    May 2010

    Unanswered: User Limit?

    Does IBM-DB2 limit the number of users that can access the database, like Microsoft Access does? I have read that Access limits to 200 users, while Oracle allows up to hundreds of thousands. What is the limit on DB2?

  2. #2
    Join Date
    May 2003
    There is no practical limit that I know of. If there is a limit, it is extremely high. However, each connection requires a certain amount of DB2 instance memory, usually about 64K, but the exact amount of memory can vary depending on a number of factors.

    With DB2 ESE (Enterprise Server Edition), one can activate the connection concentrator that allows multiple inbound connections to share one connection on the DB2 Server. If you don't have DB2 ESE, then connection pooling software can be used on the application server such a DB2 Connect, Websphere AS, Jboss, WebLogic, etc. Even for those using DB2 ESE, most shops do not enable the connection concentrator on the DB2 server and instead use connection pooling on the application server.
    Last edited by Marcus_A; 05-01-10 at 22:54.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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