Technote (FAQ)
Question
The client is working on an integration that cannot support REST queries, and they are looking for the totals of CPU, memory and disk resources for each pool. Is it possible to use a SQL query to retrieve the total amount of resources allocated to a Server Cloud Pool and the resources available for provisioning directly from the database?
Answer
It is unfortunately not possible to use a SQL query to retrieve the total resources allocated to a pool directly from the database.
The REST API is the externalized wrapper for all TSAM data and must always be used to access TSAM data. Providing an SQL query is not possible because this would externalize internal data structures - which are no secret but are subject to change without notice. The problem may be that a fix can make any such queries fail.
The only way to provide these kind of queries would be if the customer agrees on a "no support" statement because there is no guarantee that the semantic will not change in the next releases of the product.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Systems and Asset Management | IBM Service Delivery Manager | Not Applicable | AIX, Linux | 7.2.2, 7.2.1 |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.