Visual insights: see a library, the IFS, the active jobs, a night of batch jobs, the tables a journal saw change, the indexes Db2 asks for and a year of source changes at a glance — and click straight through to the object, the job log or the member.
The pictures on this page are drawn with Vanthrex’s own layout code and sample data. In VS Code each one is interactive: hover for details, click to open.
Library Space Map
Every object of a library as a tile sized by its disk space (a treemap), grouped and coloured by kind: programs, files, source files, save files, journals and data objects.
Open it: right-click a library → Library Space Map, or Library Space Map (Visual)… from the command palette or the quick menu (Ctrl+Alt+I).
What you can do:
Colour by last used: green used this month, yellow up to 6 months, orange up to a year, red over a year. An object never used is counted from the day it was created.
Type to highlight objects by name, type or text; click a kind in the legend to hide it.
Click a tile for the object information (size, owner, journaling, locks…).
Under the map: the total size, the number of objects, the biggest kind, the space not used for a year and the 15 largest objects.
Typical use: before a clean-up, a save or a migration — the old save files and journal receivers are usually the first big red tiles.
Batch Job Timeline
The batch jobs of the last 6 hours to 7 days as bars on a time axis, read from the history log (job started CPF1124, job ended CPF1164).
Open it:Batch Job Timeline (Visual) from the command palette or the quick menu.
What you can do:
Jobs that overlap get their own lane, so you see what ran at the same time.
Filter by job name (ORD* for every job starting with ORD) or by user. Only * is a wildcard: ORD_EXT matches that job only.
Click a bar for the job log; right-click for the run history of that job.
Tiles show the runs, the jobs that ended abnormally, the jobs still running, the longest run and the CPU used; the failed and the longest runs are listed below.
Active Jobs Map
Every active job as a tile inside its subsystem, sized by CPU time (or temporary storage, threads or disk I/O) and coloured by status. A job waiting for a reply is red and pulses, so you see it at once.
Open it:Active Jobs Map (Visual) from the command palette or the quick menu (Ctrl+Alt+I).
What you can do:
Size by CPU, temporary storage, threads or disk I/O; type to highlight jobs by name, subsystem, status or function.
Tick Refresh every 15 seconds to watch a batch window live.
Click a job for its job log; right-click for Work with Active Jobs (option 7 answers the message).
The jobs waiting for a reply and the top 10 jobs are listed under the map.
Journal Activity Heat Map
Which tables a journal saw change in the last 6 hours to 7 days: one row per table, one square per hour — the darker, the more changes — and inserts, updates and deletes per table as a stacked bar.
InsertsUpdatesDeletesLast 24 hours, one square per hour
Open it:Journal Activity Heat Map (Visual)… from the command palette, then type LIBRARY/JOURNAL.
What you can do: see which program run touched which tables and when, and the busiest hour. Click a table for its journal entries: who changed which row, from which program.
Only row changes are counted (inserts PT / PX, updates UP, deletes DL / DR), read with QSYS2.DISPLAY_JOURNAL from the current receiver chain.
Index Advice Chart
The indexes the Db2 optimizer asked for while running queries over a library (QSYS2.SYSIXADV), ranked by how often slow queries asked for them.
Example with sample data
#
Table
Key columns
Type
Value
Times
MTI
1
ORDERS
CUSTNO, ORDDATE (covers 2)
RADIX
2460
252
2
ORDHIST
STATUS
EVI
410
0
3
CUSTOMER
REGION, NAME
RADIX
95
12
Advice for the same table whose keys start the same way is merged: an index on (CUSTNO, ORDDATE) also serves the queries that asked for (CUSTNO) — here it covers 2 pieces of advice. CREATE INDEX… writes the statement into an SQL editor:
Open it: right-click a library → Index Advice Chart. Nothing is created until you run the SQL; check large, busy tables first, since an index speeds up reads and slows down writes.
IFS Space Map
A treemap of the folders and files below an IFS folder, sized by disk space and coloured by what fills them: source, logs and text, archives and save files, data, documents and images.
Open it: right-click a folder in the IFS view → IFS Space Map, or IFS Space Map (Visual)… from the command palette.
What you can do: click a folder to go in, use the path at the top or Up one level to go back, click a file to open it. The 15 largest files are listed under the map.
Source Change Calendar
A year of source changes in a library or a source file as a heat map, one square per day — the darker, the more members were last changed that day.
360 members changed128 days with changesLongest run: 4 days
Open it: right-click a library or a source file → Source Change Calendar.
What you can do: click a day to list the members changed that day, click a member to open it. Tiles show the members changed this year, the active days, the busiest day and the longest run of days; a bar chart shows the changes by source type.
Only the last change of each member is known (from the member statistics): a member changed again later shows on its latest day.
Also in 3.2
Library Space Map: objects never used are coloured by their creation date, so a new object does not show as “not used for over a year”; the same library on two systems opens two maps.
Batch Job Timeline:_ in a job or user name is matched as a character, not as a wildcard.
Fixed in 3.2.1
IFS Space Map on a folder such as /home/USER no longer fails with SQL0443 INVALID OMIT_LIST PARAMETER SPECIFIED: the file systems to leave out (QSYS.LIB, QNTC, QFileSvr.400, QOPT, QDLS) are only passed from /, and if a system still refuses the list, the map is read again without it.
Where to find them
Page
Right-click
Command palette
Library Space Map
a library
Library Space Map (Visual)…
Batch Job Timeline
—
Batch Job Timeline (Visual)
Active Jobs Map
—
Active Jobs Map (Visual)
Journal Activity Heat Map
—
Journal Activity Heat Map (Visual)…
Index Advice Chart
a library
Index Advice Chart (Visual)…
IFS Space Map
a folder in the IFS view
IFS Space Map (Visual)…
Source Change Calendar
a library or a source file
Source Change Calendar (Visual)…
All seven are also in the quick menu (Ctrl+Alt+I) and read the system only: nothing is created or changed on the IBM i.