Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80

    Unanswered: db2 idle process script

    I have to create a script which will detect how many db2 process is idle.
    But I am not able to define its threshold.
    Means when script need to throw alert that IDLE connection is very much high. Its need to be a percentage of application connected to the system ? or anything else.
    ( let me clear I want to have alert only I dont want to kill it through script )

  2. #2
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    I want to add few more thing.
    I want the number of connection which came from application side and it is still in the system as idle connection as it is not disconnected. I am not interested to disturb NUM_INITAGENTS which use to display as idle.
    db2 get snapshot for applications on <dbname> | grep -i idle .. I dont think NUM_INITAGENTS use to come under this ?? Am i right ?

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, NUM_INITAGENTS is used to define an agent pool. This is the minimum number of agents in the system, whether they are idle or not.

    Andy

  4. #4
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80

    thansk Andy..

    Thanks Andy for reply but I am asking for something else. I am aware about NUM_INITAGENTS. If you have something related to idle agents ( which caused due to application team) please let me know.

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What specifically are you after? You asked a question about NUM_INITAGENTS then dismiss the answer. You are mentioning "idle" processes but do not give a definition as to what you define as idle. Any agent not currently performing work in the database is idle. To count those is meaningless because you are getting a snapshot and the number at that time does not take into account how long they have been doing nothing. You need to define what "idle" means, then simply count those over the threshold.

    Andy

Posting Permissions

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