Application Programming Interface Guide > Built-in Procedures > Procedures Reference > ExplainResources
 
ExplainResources
Retrieve the list of resources included in the specified resource set.
The second through fifth inputs (highlighted in bold) support paged, random resource access. When it is employed by the Deployment Manager UI client, it alleviates the performance issues related to large resource sets.
Location
/lib/resource/ (procedure)
/services/databases/system/deployment/ (published resource)
Inputs
resourceSetDefinition: The definition of the resource set to analyze.
searchPath: Applicable only when resourceSetDefinition contains a tree root which is set to “/”; otherwise ignored. If set and effective, searchType must also be set and searchLevel must be non-zero. When searchPath is set, the matched resource is not included in the result.
searchType: Applicable only when resourceSetDefinition contains a tree root which is set to “/”; otherwise ignored. Accepts the set of resource type values accepted by the Web Services operations (“Admin API calls”)—for example, CATALOG_CONTAINER, SCHEMA_CONTAINER. If set and effective, searchLevel must also be set.
searchSubtype: Applicable only when resourceSetDefinition contains a tree root which is set to “/”; otherwise ignored.
Accepts the set of resource subtype values accepted by the Web Services operations (“Admin API calls”)—for example, CATALOG_CONTAINER, SCHEMA_CONTAINER.
searchLevel: 0 denotes the resources matching the search criteria. A negative value denotes unlimited depth. A positive value denotes the maximum depth, relative to the matched resources, at which descendent resources are to be included in the result.
Outputs
resourceList: A cursor whose rows encode the resources included in the specified resource set:
resourcePath: The resource path.
resourceType: The resource type.
isNonRelocatableOnTarget: True if the resource cannot be relocated on the target; false if it can.
owner: The resource owner.
createTime: Time the resource was created.
modifyTime: Time the resource was last modified.
modifyUser: User who last modified the resource.
resourceId: The resource id.
parentId: The parent resource id.
depthLevel: The depth level of the resource within the resource tree.
Exceptions
IllegalArgumentException: If the specified resource set definition is invalid.