Unable To Obtain Datasource Pool Statistics In Managed Setup

[rmoyersrfd]

On a standalone configuration, the following CLI command works perfectly:

/subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

Returning:

{

    "outcome" => "success",

    "result" => {

        "ActiveCount" => "8",

        "AvailableCount" => "50",

        "AverageBlockingTime" => "1",

        "AverageCreationTime" => "258",

        "CreatedCount" => "8",

        "DestroyedCount" => "0",

        "InUseCount" => "0",

        "MaxCreationTime" => "1915",

        "MaxUsedCount" => "8",

        "MaxWaitCount" => "0",

        "MaxWaitTime" => "1",

        "TimedOut" => "0",

        "TotalBlockingTime" => "23",

        "TotalCreationTime" => "2066"

    }

}

BUT, in a domain setup, the command never works. All of the following forms fail:

1. /subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

2. /host=batch-node-1/server=batch-server-1/subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

3. /profile=default/host=batch-node-1/server=batch-server-1/subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

4. /host=master/server=batch-server-1/subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

5. /profile=default/host=master/server=batch-server-1/subsystem=datasources/data-source=TECBATCHDS/statistics=pool:read-resource(include-runtime=true)

See the attached screen shot showing that the host, server and data-source names are correctly spelled.

Numbers 1, 3, 4, and 5 all fail with: "Failed to get the list of the operation properties: "JBAS014883: No resource definition is registered for address"

Number 2 fails, because the values returned are all zero:

{

    "outcome" => "success",

    "result" => {

        "ActiveCount" => "0",

        "AvailableCount" => "0",

        "AverageBlockingTime" => "0",

        "AverageCreationTime" => "0",

        "CreatedCount" => "0",

        "DestroyedCount" => "0",

        "InUseCount" => "0",

        "MaxCreationTime" => "0",

        "MaxUsedCount" => "0",

        "MaxWaitCount" => "0",

        "MaxWaitTime" => "0",

        "TimedOut" => "0",

        "TotalBlockingTime" => "0",

        "TotalCreationTime" => "0",

        "statistics-enabled" => false

    }

}

Even after enabling statistics, "ActiveCount" is always zero.

[abhijithumbe]

Hi,

You need to enable datasource statistics first, using following CLI command:

      /host=master/server=server-one/subsystem=datasources/data-source=ExampleDS/statistics=pool:write-attribute(name=statistics-enabled,value=true)

And then use following command to check datasource statistics

     /host=master/server=server-one/subsystem=datasources/data-source=ExampleDS/statistics=pool:read-resource(include-runtime=true)

[rmoyersrfd]

I did enable statistics, but was reading the results incorrectly.  This issue can be closed.

[rmoyersrfd]

Also, the documentation doesn't tell you that after enabling statistics, you need to wait for a while - 30 minutes or more - before you will start seeing any values from /statistics=pool