QMF Analytics for TSO
When QMF 12 was released it came with a new component called QMF Analytics for TSO. This component gives QMF enhanced graphing and statistical analysis features.
Here is QMF for TSO. The Q.CLIMATE_USA table is about to be displayed
![](https://dw1.s81c.com/IMWUC/MessageImages/207f331ffbe34f33bc44385ef0f31351.png)
Here is the data
![](https://dw1.s81c.com/IMWUC/MessageImages/98857a88c15043a7877963c7792b112d.png)
We will primarily be using the MONTH, STATE, RAINFALL in the following demos.
Now when the command SHOW ANALYTICS is issued, the following interface is brought up
![](https://dw1.s81c.com/IMWUC/MessageImages/5acbb8f4aad449bfac225c6ef1bbe17e.png)
First, we will look at the charts
1) Histogram
You may fill in the column names if you can remember them. If you can’t remember them then click in the field where you would type them, and a list will appear:
Now you can select the column by clicking on it
![](https://dw1.s81c.com/IMWUC/MessageImages/dc79dba2ebd7405291f6f295bace1f2d.png)
Now fill in the grouping column and a Title
![](https://dw1.s81c.com/IMWUC/MessageImages/28bdfb54c4e24e5d8f85d07f2e31e7e3.png)
You may save all these settings with F5 or press F2 to run it.
![](https://dw1.s81c.com/IMWUC/MessageImages/28bdfb54c4e24e5d8f85d07f2e31e7e3.png)
2) MAPS
![](https://dw1.s81c.com/IMWUC/MessageImages/6a02b426463a4db3abf971d1227caa67.png)
![](https://dw1.s81c.com/IMWUC/MessageImages/6d537815b4024528bfde38453bbd1ce1.png)
Fill out the Panel and press F5 to save or F2 to Run
![](https://dw1.s81c.com/IMWUC/MessageImages/15e8b50e370c401ba500f9b0f0fbd1cc.png)
3) Mixed
![](https://dw1.s81c.com/IMWUC/MessageImages/cbd37ae809a148cdb6043ed8e606feb1.png)
With Mixed you may plot more than one column at a time
![](https://dw1.s81c.com/IMWUC/MessageImages/970a7a7b8549452289a04cd782075b8c.png)
![](https://dw1.s81c.com/IMWUC/MessageImages/86517383ae7c44ab802c734ab441325b.png)
Because they are on the same scale it may be difficult to read the values of the Rainfall.
Removing Sunshine will make it easier to read the Rainfall.
![](https://dw1.s81c.com/IMWUC/MessageImages/402625cd359547bc8d369a155fbfaf80.png)
![](https://dw1.s81c.com/IMWUC/MessageImages/0a9973744cef4fca8755340af22cc565.png)
4) PIE
![](https://dw1.s81c.com/IMWUC/MessageImages/d87b0de540b84f9090ce43c41fc8004a.png)
In the Pie panel you fill out the values for Y and X
![](https://dw1.s81c.com/IMWUC/MessageImages/91085115e7ac4dc1a0a6a4fa05110929.png)
When it is run you get the percentages of the total for each wedge
![](https://dw1.s81c.com/IMWUC/MessageImages/39ca862affba4f62af6d31002a8798be.png)
5) PLOT
![](https://dw1.s81c.com/IMWUC/MessageImages/b75156d259d0411cbf7a308fd6c66cd3.png)
Fill out the panel, again clicking on the spaces will show a list of columns to choose from.
![](https://dw1.s81c.com/IMWUC/MessageImages/0acf92cd62b54cf09317c7ff251f22b0.png)
When it is run you get a chart like this
![](https://dw1.s81c.com/IMWUC/MessageImages/79752df777c0474ba2a5fd20fe027c6b.png)
6) Finally, the TOWER
![](https://dw1.s81c.com/IMWUC/MessageImages/e3ff77d06b13414c8fab1210f7afb514.png)
Again, click on the fields for a list or fill in the blanks yourself.
![](https://dw1.s81c.com/IMWUC/MessageImages/cfd1f8abd063462297d71ac9bf3c26c5.png)
When run it gives a chart like this
![](https://dw1.s81c.com/IMWUC/MessageImages/52faa7f016984e74b3f397cd36aeacb2.png)
#Db2Toolsforz/OS#Db2QMF#QMF