Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    18

    Unanswered: db2dari.exe - Process keeps running

    Hello,

    Our application is in Java. When it starts executing. Many db2dari.exe processes strart on the server.
    But even after then application is finished these processes are still running.

    Please can any one explain what is db2dari.exe process. and why they persist after the application is finished. And how to gracefully get rid of them?

    Thanks in anticipation.

    Warm Regards

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2dari.exe - Process keeps running

    DARI is Database Application Remote Interface, a term for stored procedures in early versions of DB2 ...

    New processes are created for stored procedures .. these processes are called db2dari.exe ....

    A dbm cfg value of KEEPDARI=YES will create the DARI process once and reuses it for future invocations of the stored procedure ...

    You can set this parameter to NO , if you wish, but on a Production environment, depending on the number of calls to your procedure, creating the DARI process for every invocation will be an overhead ,,,

    HTH

    Sathyaram

    Originally posted by techlearn
    Hello,

    Our application is in Java. When it starts executing. Many db2dari.exe processes strart on the server.
    But even after then application is finished these processes are still running.

    Please can any one explain what is db2dari.exe process. and why they persist after the application is finished. And how to gracefully get rid of them?

    Thanks in anticipation.

    Warm Regards

  3. #3
    Join Date
    Oct 2002
    Posts
    18

    Re: db2dari.exe - Process keeps running

    Hi,

    Thanks for your mail.
    I want to keep KEEPDARI= YES. But the problem is my process is multithreaded and each thread invokes 6 stored procedures. so at a time around 30 db2dari.exe are runing ona a server. And this is kind of a overhead.

    Is there any way I can keep KEEPDARI=YES but optimize the invokation.....

    Thanks
    Warm Regards


    Originally posted by sathyaram_s
    DARI is Database Application Remote Interface, a term for stored procedures in early versions of DB2 ...

    New processes are created for stored procedures .. these processes are called db2dari.exe ....

    A dbm cfg value of KEEPDARI=YES will create the DARI process once and reuses it for future invocations of the stored procedure ...

    You can set this parameter to NO , if you wish, but on a Production environment, depending on the number of calls to your procedure, creating the DARI process for every invocation will be an overhead ,,,

    HTH

    Sathyaram

  4. #4
    Join Date
    Feb 2005
    Posts
    118
    What action do you guys take when db2dari takes 99% of your CPU ? I have noticed that a loop in a SP causes the db2dari to consume almost all the CPU ? but then the challenge remains - identify who is the root cause of the problem ? what is the problem ? what is the immidiate fix (to free the CPU) till the problem is not fixed ?

    thanks
    Anil

Posting Permissions

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