Open ExchangeIt's about an example for the External Languages Contest 2025
You get almost any information about your databases in IRIS using
the System Management Portal. After passing several levels, you often
get a wide list of items, but the interesting ones are hard to find.
The example takes the important numbers and visualizes them as a
bar chart, showing the total size of DB, size of free space in the DB, and
the free percentage. All just actual data, no accumulation or history.
How does work
There is an external Python code that connects to IRIS using IRIS Native API for Python.
It connects to a local helper running in any namespace (default = USER)
The result is stored by columns in a Global.
This is transformed into a DataSet and feeds the bar chart.
For improved readability, the x-axis is logarithmic
The table of data received is a bypack.
The visualization is provided by a very simple CSP page.
Forcing the browser NOT to use an actual instead of the cached JPG was a bit tricky.
Advantages
- Graphic visualization instead of buried numbers
- Fast jumping across multiple instances of IRIS
.png)
