Splunk Query for ZOS Buffer Pools (Total vs Used)

index="lamaxu" sourcetype="qmstatus_json" "identifier.dataType"=PAGESET_USAGE |rename identifier.dataSource as qmgrName|rename attributes.BUFFER_POOL_ID as bufferPoolId| eval objName="(".qmgrName.") Buffer Pool ID : ".bufferPoolId|timechart span=1m max(attributes.TOTAL_PAGES) as "Total Pages" max(attributes.UNUSED_PAGES) as "Unused Pages" BY objName

Splunk Query for  ZOS Buffer Pools (Persistent vs Non-Persistent)

index="lamaxu" sourcetype="qmstatus_json" "identifier.dataType"=PAGESET_USAGE |rename identifier.dataSource as qmgrName|rename attributes.BUFFER_POOL_ID as bufferPoolId| eval objName="(".qmgrName.") Buffer Pool ID : ".bufferPoolId|timechart span=1m max(attributes.PERSIST_PAGES) as "Perisitent Pages" max(attributes.NONPERSIST_PAGES) as "Non Persistent Pages" BY objName

Sample Dashboard

Dashboard Source

<dashboard>
  <label>ZOS Buffer Pools</label>
  <row>
    <panel>
      <title>ZOS Buffer Pools (Total vs Used)</title>
      <chart>
        <title>ZOS Buffer Pools (Total vs Used)</title>
        <search>
          <query>index="lamaxu" sourcetype="qmstatus_json" "identifier.dataType"=PAGESET_USAGE |rename identifier.dataSource as qmgrName|rename attributes.BUFFER_POOL_ID as bufferPoolId| eval objName="(".qmgrName.") Buffer Pool ID : ".bufferPoolId|timechart span=1m max(attributes.TOTAL_PAGES) as "Total Pages" max(attributes.UNUSED_PAGES) as "Unused Pages" BY objName</query>
          <earliest>rt-1h</earliest>
          <latest>rt</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>1m</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">collapsed</option>
        <option name="charting.axisTitleY.visibility">collapsed</option>
        <option name="charting.axisTitleY2.visibility">collapsed</option>
        <option name="charting.axisX.abbreviation">none</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.abbreviation">none</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.abbreviation">none</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">area</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">connect</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.mode">standard</option>
        <option name="charting.legend.placement">none</option>
        <option name="charting.lineWidth">2</option>
        <option name="refresh.display">progressbar</option>
        <option name="trellis.enabled">1</option>
        <option name="trellis.scales.shared">0</option>
        <option name="trellis.size">medium</option>
      </chart>
    </panel>
  </row>
  <row>
    <panel>
      <title>ZOS Buffer Pools (Persistent vs Non-Persistent)</title>
      <chart>
        <title>ZOS Buffer Pools (Persistent vs Non-Persistent)</title>
        <search>
          <query>index="lamaxu" sourcetype="qmstatus_json" "identifier.dataType"=PAGESET_USAGE |rename identifier.dataSource as qmgrName|rename attributes.BUFFER_POOL_ID as bufferPoolId| eval objName="(".qmgrName.") Buffer Pool ID : ".bufferPoolId|timechart span=1m max(attributes.PERSIST_PAGES) as "Perisitent Pages" max(attributes.NONPERSIST_PAGES) as "Non Persistent Pages" BY objName</query>
          <earliest>rt-1h</earliest>
          <latest>rt</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>1m</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">collapsed</option>
        <option name="charting.axisTitleY.visibility">collapsed</option>
        <option name="charting.axisTitleY2.visibility">collapsed</option>
        <option name="charting.axisX.abbreviation">none</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.abbreviation">none</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.abbreviation">none</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">area</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">connect</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.mode">standard</option>
        <option name="charting.legend.placement">none</option>
        <option name="charting.lineWidth">2</option>
        <option name="refresh.display">progressbar</option>
        <option name="trellis.enabled">1</option>
        <option name="trellis.scales.shared">0</option>
        <option name="trellis.size">medium</option>
      </chart>
    </panel>
  </row>
</dashboard>
  • No labels