RESOURCE_PROVIDERS table

Edit online

The RESOURCE_PROVIDERS table stores cross-references between resource provider IDs and stores reconciliation data for each resource provider.

Table 1. `RESOURCE_PROVIDERS` table
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® Liberty that initiated the recon. It is used in cluster mode during WebSphere Liberty 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 IBM Verify Identity Governance release 6.0.