IBM Spectrum Computing Group

Using IBM Spectrum LSF Explorer Database Schema to create a new chart

  • 1.  Using IBM Spectrum LSF Explorer Database Schema to create a new chart

    Posted Fri December 11, 2020 05:16 AM

    It is easy to create a new chart by using the IBM Spectrum LSF Explorer Database Schema.

    The following example is to create a new chart showing the Number of Jobs by User or Queue. 

    Procedure 

    1. Select Charts on the left sidebar and click the New button on the upper-right corner. 
    2. Enter a name for the chart, for example "Number of Jobs by Queue". 

    3. Select a data source for the chart data. 

    The data sources are automatically created at installation by the installer and are defined in EXPLORER_SERVER_TOP/lsfsuite/ext/explorer/server/config/config.json, where EXPLORER_SERVER_TOP is the top-level installation directory on the IBM Spectrum LSF Explorer server. The default data source is "ds1". 

    4. Select an Index. In this instance, select "lsf_job_acct-*", which contains all the information for finished LSF jobs. 
    5. Select the Dimension "queue_name". The search box can be used to narrow down candidate dimension field list. The queue name dimension allows you to view jobs by queue.  

    6. Modify the 
    Display Name to be used as the label for the Dimension (for example, Queue Name) and click"+"button. "user_name" dimension can be added in similar way. Click the "pen" icon on the right side of the same line to edit the display name. Click the "trash" icon on the right side of the same line to delete the dimension. 

    7. Select the "job_id" Measure and "Count" Aggregation to get the number of jobs. Modify the Display Name to be used as the label for the Measure (for example, Number of Jobs) and select "+". Click the "pen" icon on the right side of the same line to edit the display name. Click the "trash" icon on the right side of the same line to delete the measure. 
    8. Under Filters, select: 
    • user_name with Multiple Selection Selection Type and the Display Name "User Name". 
    • queue_name with Multiple Selection Selection Type and the Display Name "Queue Name". 
    • job_status with Multiple Selection Selection Type and the Display Name "Job Status". 
    • end_time with defaultSelection Type and the Display Name "Time Range" and Relative Time of past 7 days. For date filter, Date Range type can be selected to specify date range with fixed start time and end time. 
    9. Click Calculated field management to enter calculated field management page. 

    In calculated field management page, click Create button to create new calculated field. Enter the calculated field Name and the Formula. Hover the cursor on the "question"icon to see the supported formula syntax. In this example, we create a field named avg_mem_in_mb indicating the average memory usage in MB based on original avg_mem field whose unit is KB. Select Numeric as data type and click Save. The created calculated field can be used same as original fields in dimension/measure/filter. 


    10. Click Next to see a preview of your chart. 
    11. Select a Chart Type to best display your data. 

    Examine the preview of your chart to make sure it meets your requirements and return to the previous screen to make any modifications.  

    12. When you are satisfied with your new chart, select a Category where your chart will be stored. You can create a new category by clicking "+Add new category" button in the top of the category list. 
    13. Click Save. 

    Your new chart is now available under the chosen Category (in our example, Sample) in the Charts section of IBM Spectrum LSF Explorer. 



    ------------------------------
    Edward Deng
    ------------------------------