Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: MAXAPPLS - High Water Mark

    DB2 V8.2/AIX 5.3

    Any method available to get the high water mark of MAXAPPLS parameter ?

    Thanks in advance

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    I am not aware that there is a method for this. You should derive to this value based on how many people your business expects to be connected to this DB at that same point of time.

    If you set it too low you will hear about it rather quickly
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    look in
    get snapshot for databse
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    You can try the DB SNAPSHOT and look into the MAX NUM CONNECTIONs which will give you an idea of the MAXAPPLS.

    Regarding the high-water mark, hope this one from Manual will be helpful:

    "When an application attempts to connect to a database, but MAXAPPLS has already been reached, an error is returned to the application indicating that the maximum number of applications have been connected to the database. "

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  5. #5
    Join Date
    Aug 2009
    Posts
    6

    what is a water mark?

    not sure if this is relevant but there may be beginners like me who don't know what a water mark is...
    the onlyplace i have seen a water mark is or movies where some1 tries to block the subtitles n stuff

Posting Permissions

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