Staus of the application in list application show detail - Explain

Posted on 2006-05-03
Last Modified: 2008-01-09
When I do a db2 list application show detail in EEE i get the status of few applications as Decoupled...Can anyone explain me what does this status exactly mean.
Question by:Reddy13
    LVL 7

    Expert Comment


    Here is the explanation from IBM doc

    Decoupled:  There are no agents currently associated with the application. This is a normal state. When the Connection Concentrator is enabled, there is no dedicated coordinator agent, so an application can be decoupled on the coordinator partition. In non-concentrator environments, an application cannot be decoupled on the coordinator partition as there will always be a dedicated coordinator agent .
    LVL 13

    Expert Comment

    decoupled means that the agent was stolen by another application, which is the preferred behaviour,whereas as in the past, stolen agents was to be avoided.
    By stealing agents, there is less overhead for the instance manager as less agents need to be created. In addition, stolen agents were previously idle, so they may as well be reused by another application that needs them. By behaving this way, less agents need to be defined, therefore, you can use less memory.
    You can still tune the number of agents per partition, but by itself, decoupled isnt anything to worry about.

    Author Comment

    How could an application that is decoupled hold locks and cause a lock wait status when its is not really Executing .
    LVL 13

    Accepted Solution

    thats a very good question, and the answer is that the lock wait status is occuring on a node where the agent is not decoupled.
    Remember, list applications only shows the agents on the node to which you are on, which by default is node 0.
    If you want to see all applications on all nodes, do list applications global.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now