This fix resolves issues with Explorer model data calculations.

Readme file for: IBM® Spectrum LSF Explorer
Product/Component Release: 10.2.0.9
Update Name: Fix 537475
Fix ID: explorer-10.2.0.9-build537475
Publication date: Feb. 11, 2020
Last modified date: Feb. 11, 2020

• List of fixes
• Download location
• Product notifications
• Products or components affected
• System requirements
• Installation and configuration
• Uninstallation
• List of files
• Copyright and trademark information

• List of fixes
  

  P103360

• Download location

  Download from the following location: http://www.ibm.com/eserver/support/fixes/

• Product notifications:

  To receive information about product solution and patch updates automatically, subscribe to product notifications on the My notifications page http://www.ibm.com/support/mynotifications/ on the IBM Support website (http://support.ibm.com). You can edit your subscription settings to choose the types of information you want to get notification about, for example, security bulletins, fixes, troubleshooting, and product enhancements or documentation changes.

• Products or components affected
  

  Explorer Server

• System requirements
  • Linux-x86_64
  • Power 64 LE
• Installation and configuration
  • The following steps assume that IBM Spectrum LSF Explorer is installed in /opt/ibm. Replace with your actual installation directory.
    
  • 6.1  Before installation
    • Log on to the IBM Spectrum LSF Explorer Server host as root.
      
  • 6.2  Installation steps for IBM Spectrum LSF Explorer V10.2.0.
    

    Note: 1. This patch is only for LSF Explorer V10.2.0. If you are using other versions, you must first migrate to V10.2.0 before applying this patch. 2. User should install this patch on every IBM Spectrum LSF Explorer Servers and Nodes.
    

    • Run following commands to update the Model data, where ${ES_IP_PORT} is the Elasticsearch URL.
      
      curl -H "Content-Type: application/json" -H "Expect:" -XPUT http://${ES_IP_PORT}/model/_doc/workload_statistics_cube_1 -s -d '{ "id": "workload_statistics_cube_1", "type":"cube", "metadata": { "version": "10.1" }, "dataSets": [ { "id": "ds1", "datasource": "ds1", "source": "LSB_JOB_STATUS", "provider": { "id": "elasticsearch", "args": { "index": "lsf_jobs_active*" } }, "fields": [ { "id": "id_timestamp", "name": "Date", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "hour", "granularities": [ { "id": "year", "name": "Year", "format": "yyyy" }, { "id": "month", "name": "Month", "format": "yyyy-MM" }, { "id": "week", "name": "Week", "format": "w" }, { "id": "day", "name": "Day", "format": "yyyy-MM-dd" }, { "id": "hour", "name": "Hour", "format": "yyyy-MM-dd HH" } ] }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id": "id_job_status", "name": "Job Status", "field": "job_status", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_cluster", "name": "Cluster", "field": "cluster_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user", "name": "User", "field": "user_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user_group", "name": "User Group", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "formula": "([user_group_name]==null)?\u0027-\u0027:[user_group_name]", "selector": "buckets" } }, { "id": "id_project", "name": "Project", "field": "project_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_queue", "name": "Queue", "field": "queue_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_app", "name": "Application", "field": "app_profile", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_swap_usage_raw", "name": "Swap Usage (Raw)", "role": "measure", "dataType": "numeric", "field": "swap_usage", "unit": "KB", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_swap_usage_peak", "name": "Peak Swap Usage", "role": "measure", "dataType": "numeric", "field": "id_swap_usage_raw", "unit": "KB", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_swap_usage_avg", "name": "Avg Swap Usage", "role": "measure", "dataType": "numeric", "field": "id_swap_usage_raw", "unit": "KB", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_raw", "name": "Memory Usage (raw)", "field": "mem_usage", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_mem_usage_peak", "name": "Peak Memory Usage", "field": "id_mem_usage_raw", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_avg", "name": "Avg Memory Usage", "field": "id_mem_usage_raw", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_cpu_delta_raw", "name": "CPU Time (raw)", "role": "measure", "dataType": "numeric", "unit": "s", "agg": { "id": "sum", "formula": "[utime_delta]>0?[utime_delta]:0 + [stime_delta]>0?[stime_delta]:0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_cpu_time_total", "name": "Total CPU Time", "field": "id_cpu_delta_raw", "role": "measure", "unit": "s", "dataType": "numeric", "agg": { "id": "sum_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_num_jobs_raw", "name": "# of Jobs (raw)", "field": "time_stamp", "role": "measure", "dataType": "numeric", "agg": { "id": "count" }, "outputFormat": { "maximumFractionDigits": 0 } }, { "id": "id_num_jobs_avg", "name": "Avg # of Jobs", "field": "id_num_jobs_raw", "role": "measure", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw", "outputFormat": { "maximumFractionDigits": 0 } } ] }, { "id": "ds2", "datasource": "ds1", "source": "LSB_JOB_STATUS_PEND", "provider": { "id": "elasticsearch", "args": { "index": "lsf_jobs_pend*" } }, "fields": [ { "id": "id_timestamp", "name": "Date", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "hour", "granularities": [ { "id": "year", "name": "Year", "format": "yyyy" }, { "id": "month", "name": "Month", "format": "yyyy-MM" }, { "id": "week", "name": "Week", "format": "w" }, { "id": "day", "name": "Day", "format": "yyyy-MM-dd" }, { "id": "hour", "name": "Hour", "format": "yyyy-MM-dd HH" } ] }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id": "id_job_status", "name": "Job Status", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets", "formula": "\u0027PEND\u0027" } }, { "id": "id_cluster", "name": "Cluster", "field": "cluster_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user", "name": "User", "field": "user_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user_group", "name": "User Group", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "formula": "([user_group_name]==null)?\u0027-\u0027:[user_group_name]", "selector": "buckets" } }, { "id": "id_project", "name": "Project", "field": "project_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_queue", "name": "Queue", "field": "queue_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_app", "name": "Application", "field": "app_profile", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_swap_usage_raw", "name": "Swap Usage (Raw)", "role": "measure", "dataType": "numeric", "unit": "KB", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_swap_usage_peak", "name": "Peak Swap Usage", "field": "id_swap_usage_raw", "role": "measure", "dataType": "numeric", "unit": "KB", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_swap_usage_avg", "name": "Avg Swap Usage", "field": "id_swap_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_raw", "name": "Memory Usage (raw)", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_mem_usage_peak", "name": "Peak Memory Usage", "field": "id_mem_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_avg", "name": "Avg Memory Usage", "field": "id_mem_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_cpu_delta_raw", "name": "CPU Time (raw)", "role": "measure", "dataType": "numeric", "unit": "s", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_cpu_time_total", "name": "Total CPU Time", "field": "id_cpu_delta_raw", "role": "measure", "unit": "s", "dataType": "numeric", "agg": { "id": "sum_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_num_jobs_raw", "name": "# of Jobs (raw)", "field": "num_jobs", "role": "measure", "dataType": "numeric", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 0 } }, { "id": "id_num_jobs_avg", "name": "Avg # of Jobs", "field": "id_num_jobs_raw", "role": "measure", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw", "outputFormat": { "maximumFractionDigits": 0 } } ] } ] }';curl -H "Content-Type: application/json" -H "Expect:" -XPUT http://${ES_IP_PORT}/model/_doc/monitor_workload -s -d '{ "id" : "monitor_workload", "type":"cube", "metadata" : { "version" : "10.1" }, "dataSets" : [ { "id" : "ds1", "datasource" : "ds1", "source" : "lsf_jobs_active-", "provider" : { "id" : "elasticsearch", "args" : { "index" : "lsf_jobs_active-*" } }, "fields" : [ { "id" : "id_time_stamp", "name" : "Timestamp", "field" : "time_stamp", "role" : "dimension", "dataType" : "date", "agg" : { "selector" : "buckets", "id" : "date_histogram", "granularityId" : "hour", "arg" : { "interval" : "1h" } }, "granularities" : [ { "id" : "year", "name" : "Year", "format" : "yyyy" }, { "id" : "quarter", "name" : "Quarter", "format" : "yyyy-MM" }, { "id" : "month", "name" : "Month", "format" : "yyyy-MM" }, { "id" : "week", "name" : "Week", "format" : "w" }, { "id" : "day", "name" : "Day", "format" : "yyyy-MM-dd" }, { "id" : "hour", "name" : "Hour", "format" : "yyyy-MM-dd HH" }, { "id" : "10m", "name" : "10 Minutes", "format" : "yyyy-MM-dd HH:mm" } ], "granularityId" : "10m" }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1h" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id" : "id_mem_usage_avg_raw", "name" : "Memory Usage", "field" : "mem_usage", "role" : "measure", "dataType" : "numeric", "agg" : { "id" : "sum", "formula" : "[mem_usage]/1024" } }, { "id": "id_mem_usage_avg", "name": "Memory Usage", "role": "measure", "unit" : "MB", "dataType": "numeric", "field": "id_mem_usage_avg_raw", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_num_asked_processors_avg_raw", "name" : "Slots Usage", "field" : "num_asked_processors", "role" : "measure", "dataType" : "double", "agg" : { "id" : "sum" } }, { "id": "id_num_asked_processors_avg", "name": "Slots Usage", "role": "measure", "dataType": "numeric", "field": "id_num_asked_processors_avg_raw", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_cputime_avg_raw", "name" : "CPU Time(S)", "field" : "cputime", "role" : "measure", "dataType" : "numeric", "agg" : { "id" : "sum", "formula" : "[utime_delta]+ [stime_delta]" } }, { "id": "id_cputime_avg", "name": "CPU Time(S)", "role": "measure", "dataType": "numeric", "field": "id_cputime_avg_raw", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_job_id", "name" : "job_id", "field" : "job_id", "role" : "dimension", "dataType" : "double", "agg" : { "selector" : "buckets", "id" : "terms" } }, { "id" : "id_job_arr_idx", "name" : "job_arr_idx", "field" : "job_arr_idx", "role" : "dimension", "dataType" : "double", "agg" : { "selector" : "buckets", "id" : "terms" } } ] } ] }'
• Uninstallation
  • 7.1  Before uninstallation

    Log on to the IBM Spectrum LSF Explorer Server host as root.

  • 7.2  Roll back the fix

    The following steps assume that IBM Spectrum LSF Explorer is installed in the /opt/ibm directory.
    Replace this with your actual installation directory.

    • Run following commands to rollback the Model data, where ${ES_IP_PORT} is the Elasticsearch URL.
      
      curl -H "Content-Type: application/json" -H "Expect:" -XPUT http://${ES_IP_PORT}/model/_doc/workload_statistics_cube_1 -s -d '{ "id": "workload_statistics_cube_1", "type":"cube", "metadata": { "version": "10.1" }, "dataSets": [ { "id": "ds1", "datasource": "ds1", "source": "LSB_JOB_STATUS", "provider": { "id": "elasticsearch", "args": { "index": "lsf_jobs_active*" } }, "fields": [ { "id": "id_timestamp", "name": "Date", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "hour", "granularities": [ { "id": "year", "name": "Year", "format": "yyyy" }, { "id": "month", "name": "Month", "format": "yyyy-MM" }, { "id": "week", "name": "Week", "format": "w" }, { "id": "day", "name": "Day", "format": "yyyy-MM-dd" }, { "id": "hour", "name": "Hour", "format": "yyyy-MM-dd HH" } ] }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id": "id_job_status", "name": "Job Status", "field": "job_status", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_cluster", "name": "Cluster", "field": "cluster_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user", "name": "User", "field": "user_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user_group", "name": "User Group", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "formula": "([user_group_name]==null)?\u0027-\u0027:[user_group_name]", "selector": "buckets" } }, { "id": "id_project", "name": "Project", "field": "project_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_queue", "name": "Queue", "field": "queue_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_app", "name": "Application", "field": "app_profile", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_swap_usage_raw", "name": "Swap Usage (Raw)", "role": "measure", "dataType": "numeric", "field": "swap_usage", "unit": "KB", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_swap_usage_peak", "name": "Peak Swap Usage", "role": "measure", "dataType": "numeric", "field": "id_swap_usage_raw", "unit": "KB", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_swap_usage_avg", "name": "Avg Swap Usage", "role": "measure", "dataType": "numeric", "field": "id_swap_usage_raw", "unit": "KB", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_raw", "name": "Memory Usage (raw)", "field": "mem_usage", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_mem_usage_peak", "name": "Peak Memory Usage", "field": "id_mem_usage_raw", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_avg", "name": "Avg Memory Usage", "field": "id_mem_usage_raw", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_cpu_delta_raw", "name": "CPU Time (raw)", "role": "measure", "dataType": "numeric", "unit": "s", "agg": { "id": "sum", "formula": "[utime_delta]>0?[utime_delta]:0 + [stime_delta]>0?[stime_delta]:0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_cpu_time_total", "name": "Total CPU Time", "field": "id_cpu_delta_raw", "role": "measure", "unit": "s", "dataType": "numeric", "agg": { "id": "sum_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_num_jobs_raw", "name": "# of Jobs (raw)", "field": "time_stamp", "role": "measure", "dataType": "numeric", "agg": { "id": "count" }, "outputFormat": { "maximumFractionDigits": 0 } }, { "id": "id_num_jobs_avg", "name": "Avg # of Jobs", "field": "id_num_jobs_raw", "role": "measure", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw", "outputFormat": { "maximumFractionDigits": 0 } } ] }, { "id": "ds2", "datasource": "ds1", "source": "LSB_JOB_STATUS_PEND", "provider": { "id": "elasticsearch", "args": { "index": "lsf_jobs_pend*" } }, "fields": [ { "id": "id_timestamp", "name": "Date", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "hour", "granularities": [ { "id": "year", "name": "Year", "format": "yyyy" }, { "id": "month", "name": "Month", "format": "yyyy-MM" }, { "id": "week", "name": "Week", "format": "w" }, { "id": "day", "name": "Day", "format": "yyyy-MM-dd" }, { "id": "hour", "name": "Hour", "format": "yyyy-MM-dd HH" } ] }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1d" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id": "id_job_status", "name": "Job Status", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets", "formula": "\u0027PEND\u0027" } }, { "id": "id_cluster", "name": "Cluster", "field": "cluster_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user", "name": "User", "field": "user_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_user_group", "name": "User Group", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "formula": "([user_group_name]==null)?\u0027-\u0027:[user_group_name]", "selector": "buckets" } }, { "id": "id_project", "name": "Project", "field": "project_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_queue", "name": "Queue", "field": "queue_name", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_app", "name": "Application", "field": "app_profile", "role": "dimension", "dataType": "string", "agg": { "id": "terms", "selector": "buckets" } }, { "id": "id_swap_usage_raw", "name": "Swap Usage (Raw)", "role": "measure", "dataType": "numeric", "unit": "KB", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_swap_usage_peak", "name": "Peak Swap Usage", "field": "id_swap_usage_raw", "role": "measure", "dataType": "numeric", "unit": "KB", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_swap_usage_avg", "name": "Avg Swap Usage", "field": "id_swap_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_raw", "name": "Memory Usage (raw)", "unit": "KB", "role": "measure", "dataType": "numeric", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_mem_usage_peak", "name": "Peak Memory Usage", "field": "id_mem_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_mem_usage_avg", "name": "Avg Memory Usage", "field": "id_mem_usage_raw", "role": "measure", "unit": "KB", "dataType": "numeric", "agg": { "id": "max_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_cpu_delta_raw", "name": "CPU Time (raw)", "role": "measure", "dataType": "numeric", "unit": "s", "agg": { "id": "sum", "formula": "0" }, "outputFormat": { "maximumFractionDigits": 2 } }, { "id": "id_cpu_time_total", "name": "Total CPU Time", "field": "id_cpu_delta_raw", "role": "measure", "unit": "s", "dataType": "numeric", "agg": { "id": "sum_bucket" }, "outputFormat": { "maximumFractionDigits": 2 }, "basedFieldId": "id_timestamp_raw" }, { "id": "id_num_jobs_raw", "name": "# of Jobs (raw)", "field": "num_jobs", "role": "measure", "dataType": "numeric", "agg": { "id": "sum" }, "outputFormat": { "maximumFractionDigits": 0 } }, { "id": "id_num_jobs_avg", "name": "Avg # of Jobs", "field": "id_num_jobs_raw", "role": "measure", "dataType": "numeric", "agg": { "id": "avg_bucket" }, "basedFieldId": "id_timestamp_raw", "outputFormat": { "maximumFractionDigits": 0 } } ] } ] }';curl -H "Content-Type: application/json" -H "Expect:" -XPUT http://${ES_IP_PORT}/model/_doc/monitor_workload -s -d '{ "id" : "monitor_workload", "type":"cube", "metadata" : { "version" : "10.1" }, "dataSets" : [ { "id" : "ds1", "datasource" : "ds1", "source" : "lsf_jobs_active-", "provider" : { "id" : "elasticsearch", "args" : { "index" : "lsf_jobs_active-*" } }, "fields" : [ { "id" : "id_time_stamp", "name" : "Timestamp", "field" : "time_stamp", "role" : "dimension", "dataType" : "date", "agg" : { "selector" : "buckets", "id" : "date_histogram", "granularityId" : "hour", "arg" : { "interval" : "1h" } }, "granularities" : [ { "id" : "year", "name" : "Year", "format" : "yyyy" }, { "id" : "quarter", "name" : "Quarter", "format" : "yyyy-MM" }, { "id" : "month", "name" : "Month", "format" : "yyyy-MM" }, { "id" : "week", "name" : "Week", "format" : "w" }, { "id" : "day", "name" : "Day", "format" : "yyyy-MM-dd" }, { "id" : "hour", "name" : "Hour", "format" : "yyyy-MM-dd HH" }, { "id" : "10m", "name" : "10 Minutes", "format" : "yyyy-MM-dd HH:mm" } ], "granularityId" : "10m" }, { "id": "id_timestamp_raw", "name": "Time stamp (raw)", "field": "time_stamp", "role": "dimension", "dataType": "date", "agg": { "id": "date_histogram", "selector": "buckets", "arg": { "interval": "1h" } }, "granularityId": "10m", "granularities": [ { "id": "10m", "name": "Sample", "format": "yyyy-MM-dd HH:mm:ss" } ] }, { "id" : "id_mem_usage_avg_raw", "name" : "Memory Usage", "field" : "mem_usage", "role" : "measure", "dataType" : "numeric", "agg" : { "id" : "sum", "formula" : "[mem_usage]/1024" } }, { "id": "id_mem_usage_avg", "name": "Memory Usage", "role": "measure", "unit" : "MB", "dataType": "numeric", "field": "id_mem_usage_avg_raw", "agg": { "id": "max_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_num_asked_processors_avg_raw", "name" : "Slots Usage", "field" : "num_asked_processors", "role" : "measure", "dataType" : "double", "agg" : { "id" : "sum" } }, { "id": "id_num_asked_processors_avg", "name": "Slots Usage", "role": "measure", "dataType": "numeric", "field": "id_num_asked_processors_avg_raw", "agg": { "id": "max_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_cputime_avg_raw", "name" : "CPU Time(S)", "field" : "cputime", "role" : "measure", "dataType" : "numeric", "agg" : { "id" : "sum", "formula" : "[utime_delta]+ [stime_delta]" } }, { "id": "id_cputime_avg", "name": "CPU Time(S)", "role": "measure", "dataType": "numeric", "field": "id_cputime_avg_raw", "agg": { "id": "max_bucket" }, "basedFieldId": "id_timestamp_raw" }, { "id" : "id_job_id", "name" : "job_id", "field" : "job_id", "role" : "dimension", "dataType" : "double", "agg" : { "selector" : "buckets", "id" : "terms" } }, { "id" : "id_job_arr_idx", "name" : "job_arr_idx", "field" : "job_arr_idx", "role" : "dimension", "dataType" : "double", "agg" : { "selector" : "buckets", "id" : "terms" } } ] } ] }'
• List of files
  

  N/A
  

• Copyright and trademark information

  ©Copyright IBM Corporation 2020
  
  U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  
  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 http://www.ibm.com/legal/copytrade.shtml