RESOURCE_PROVIDERS table

RESOURCE_PROVIDERS table

The RESOURCE_PROVIDERS table stores cross-references between resource provider IDs and stores reconciliation data for each resource provider.
Column Name Description Data type

PROVIDER_ID^* Unique ID for each resource provider. Primary key.
There is a one-to-one relationship between a PROVIDER_ID and a RESOURCE_DN.
Character (20)

RESOURCE_DN DN for the managed resource for which the provider is responsible. Character (2000)

RECON_STATUS Indicates whether reconciliation is currently running.
0 – No reconciliation is running for this service.
1 – Reconciliation is currently running on this service. If the server is shut down abruptly during reconciliation, this flag might need to be reset to 0. Reset the flag before other reconciliation requests can be processed for the specified service.
Numeric

LAST_RECON_TIME The time of the last reconciliation. Date

MAX_RECON_DURATION Timeout value, in minutes, for reconciliations. If a reconciliation request runs beyond the amount of time specified in this field, the request is terminated. Numeric

LOCK_SERVICE Indicates whether to lock the service during a reconciliation:
0 – Do not lock the service during reconciliation.
1 – Lock the service during reconciliation.
Numeric

REQUEST_ID Tracks the process that locks the service. Character (20)

CURRENT_REQUEST_COUNT Current number of requests that are being executed. Numeric

MAX_REQUEST_COUNT Maximum number of concurrent requests that can be executed (or -1 = unlimited). For future use (currently null). Numeric

LAST_RESPONSE_TIME Timestamp of last response (to detect failed resources). For future use (currently null). Date

RESOURCE_STATUS Resource status (0 = ok, 1 = failed, 2 = failed service that is being tested). Numeric

RESTART_TIME Timestamp of the last reconciliation started. Date

SERVER The ID of the WebSphere Application Server that initiated the recon. It is used in cluster mode during WebSphere Application Server restart to decide whether a recon lock flag was left enabled due to server failure. In that case, clean up locks and set the recon state to failed or aborted. Character (255)

RESOURCE_TEST_STATUS¹ Resource status, including updates that resulted from ‘Test’(ping) request (0 = OK, 1 = failed, 2 = failed service that is being tested). Numeric

LAST_TEST_STATUS_TIME¹ Timestamp of last ping of the resource (to detect failed resources). Date

FIRST_RESOURCE_FAIL_TIME² Timestamp of the time the service was placed in failed state. Timestamp

LAST_ERROR² The most recent error message returned when attempting to send a request to the service. Character (2000)

^* Indicates the column is required and not null.
¹ Indicates the column or the value is added in release 5.0.
² Indicates the column or the value is added in ISIM release 6.0.
Parent topic: Services tables

Column Name	Description	Data type
PROVIDER_ID^*	Unique ID for each resource provider. Primary key. There is a one-to-one relationship between a PROVIDER_ID and a RESOURCE_DN.	Character (20)
RESOURCE_DN	DN for the managed resource for which the provider is responsible.	Character (2000)
RECON_STATUS	Indicates whether reconciliation is currently running. 0 – No reconciliation is running for this service. 1 – Reconciliation is currently running on this service. If the server is shut down abruptly during reconciliation, this flag might need to be reset to 0. Reset the flag before other reconciliation requests can be processed for the specified service.	Numeric
LAST_RECON_TIME	The time of the last reconciliation.	Date
MAX_RECON_DURATION	Timeout value, in minutes, for reconciliations. If a reconciliation request runs beyond the amount of time specified in this field, the request is terminated.	Numeric
LOCK_SERVICE	Indicates whether to lock the service during a reconciliation: 0 – Do not lock the service during reconciliation. 1 – Lock the service during reconciliation.	Numeric
REQUEST_ID	Tracks the process that locks the service.	Character (20)
CURRENT_REQUEST_COUNT	Current number of requests that are being executed.	Numeric
MAX_REQUEST_COUNT	Maximum number of concurrent requests that can be executed (or -1 = unlimited). For future use (currently null).	Numeric
LAST_RESPONSE_TIME	Timestamp of last response (to detect failed resources). For future use (currently null).	Date
RESOURCE_STATUS	Resource status (0 = ok, 1 = failed, 2 = failed service that is being tested).	Numeric
RESTART_TIME	Timestamp of the last reconciliation started.	Date
SERVER	The ID of the WebSphere Application Server that initiated the recon. It is used in cluster mode during WebSphere Application Server restart to decide whether a recon lock flag was left enabled due to server failure. In that case, clean up locks and set the recon state to failed or aborted.	Character (255)
RESOURCE_TEST_STATUS¹	Resource status, including updates that resulted from ‘Test’(ping) request (0 = OK, 1 = failed, 2 = failed service that is being tested).	Numeric
LAST_TEST_STATUS_TIME¹	Timestamp of last ping of the resource (to detect failed resources).	Date
FIRST_RESOURCE_FAIL_TIME²	Timestamp of the time the service was placed in failed state.	Timestamp
LAST_ERROR²	The most recent error message returned when attempting to send a request to the service.	Character (2000)