IBM Support

RTM graph that contains total available memory of the cluster

Question & Answer


Question

Does RTM have a graph which contains total available memory of the cluster?

Answer

There is no graph graph that shows the total available memory for all the hosts for a cluster.

The graph name "<Cluster_Name>_Summary - Grid Available Memory" does not show up the total available memory for the cluster.


Go to Graphs tab-> Cluster-cluster name->Grid available memory.
  • The graph "<Cluster_name>_Summary - Grid Available Memory" doesn't show the total available memory. It shows the total average available memory of all the hosts. The confusion occurs due to its name. So the graph is about total average memory, minimum average and max average memory of all the hosts.
  • Its coming from the below sql query.
# mysql cacti -e "SELECT AVG(mem) as a_mem, AVG(swp) as a_swp FROM grid_load WHERE (status NOT LIKE 'U%') AND clusterid = 2 GROUP BY clusterid;" (Note: change the cluster id to your cluster id number)

The total available memory of the cluster can be calculated by the below sql query:
# mysql cacti -e "SELECT sum(mem) as a_mem, sum(swp) as a_swp FROM grid_load WHERE (status NOT LIKE 'U%') AND clusterid = 1 GROUP BY clusterid;"
(Note: please change the cluster id to your cluster id number)

[{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"Standard","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSVMSD","label":"Platform RTM"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

isg3T1025014