New in 3.2

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.

  1. Library Space Map
  2. Batch Job Timeline
  3. Active Jobs Map
  4. Journal Activity Heat Map
  5. Index Advice Chart
  6. IFS Space Map
  7. Source Change Calendar
  8. Also in 3.2
  9. Fixed in 3.2.1
  10. Where to find them

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.

Example with sample data
ORDHIST *FILE 2.1 GBORDHIST2.1 GBORDERS *FILE 920.0 MBORDERS920.0 MBCUSTOMER *FILE 410.0 MBCUSTOMER410.0 MBORDERSL1 *FILE 160.0 MBBACKUP0923 *FILE 740.0 MBBACKUP0923740.0 MBOLDEXPORT *FILE 190.0 MBAPPJRN0042 *JRNRCV 330.0 MBAPPJRN0042330.0 MBAPPJRN0041 *JRNRCV 240.0 MBAPPJRN0041240.0 MBQRPGLESRC *FILE 120.0 MBQRPGLESRC120.0 MBQCLLESRC *FILE 30.0 MBQDDSSRC *FILE 18.0 MBORDSRV *SRVPGM 65.0 MBORDSRV65.0 MBORD001 *PGM 42.0 MBINV100 *PGM 31.0 MBNIGHTLY *PGM 8.0 MBORDQ *DTAQ 22.0 MBAPPMSG *MSGF 6.0 MB
Files · 3.6 GB (4)Save files · 930.0 MB (2)Journals · 570.0 MB (2)Source files · 168.0 MB (3)Programs · 146.0 MB (4)Data · 28.0 MB (2)

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).

Example with sample data
21:0022:0023:002026-11-0501:0002:0003:0004:0005:0006:00100231/BATCH/NIGHTLY okNIGHTLY100233/QSYSOPR/BACKUPQ ok100240/BATCH/ORDEXTRACT okORDEXTRACT100244/BATCH/INVOICES failedINVOICES100250/BATCH/SAVLIB okSAVLIB100262/BATCH/PURGEHIST ok100270/BATCH/STATS ok100281/BATCH/REPLICATE runningREPLICATE
Ended normallyEnded abnormallyStill running

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.

Example with sample data
QBATCH100231/BATCH/NIGHTLY RUNNIGHTLYRUN100240/BATCH/ORDEXTRACT MSGWORDEXTRACTMSGW100244/BATCH/INVOICES LCKWINVOICESLCKW100250/BATCH/STATS DEQWSTATSDEQWQUSRWRK100300/QUSER/QZDASOINIT TIMWQZDASOINITTIMW100301/QUSER/QZDASOINIT RUNQZDASOINITRUN100302/QUSER/QZDASOINIT TIMWQZDASOINITTIMW100303/QUSER/QZRCSRVS DEQWQZRCSRVSDEQW(none)100402/QSYS/QSYSARB EVTWQSYSARBEVTWQSYSWRK100400/QTCP/QTSMTPSRVR SELWQTSMTPSRVRSELW100401/QSYS/QJOBSCD EVTWQJOBSCDEVTWQINTER100501/OPS/QPADEV0007 RUNQPADEV0007RUN100500/DEV/QPADEV0004 DSPWQPADEV0004DSPW
Waiting for a reply (MSGW)Lock waitRunningWaiting

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.

Example with sample data
07:0010:0013:0016:0019:0022:0001:0004:00APPLIB/CUSTOMER2026-11-04 07:00 — 0 changes2026-11-04 08:00 — 0 changes2026-11-04 09:00 — 974 changes2026-11-04 10:00 — 843 changes2026-11-04 11:00 — 1074 changes2026-11-04 12:00 — 0 changes2026-11-04 13:00 — 0 changes2026-11-04 14:00 — 1069 changes2026-11-04 15:00 — 1016 changes2026-11-04 16:00 — 1092 changes2026-11-04 17:00 — 2 changes2026-11-04 18:00 — 3 changes2026-11-04 19:00 — 3 changes2026-11-04 20:00 — 0 changes2026-11-04 21:00 — 0 changes2026-11-04 22:00 — 0 changes2026-11-04 23:00 — 0 changes2026-11-05 00:00 — 0 changes2026-11-05 01:00 — 0 changes2026-11-05 02:00 — 0 changes2026-11-05 03:00 — 0 changes2026-11-05 04:00 — 0 changes2026-11-05 05:00 — 0 changes2026-11-05 06:00 — 0 changesAPPLIB/ORDERS2026-11-04 07:00 — 0 changes2026-11-04 08:00 — 0 changes2026-11-04 09:00 — 1 changes2026-11-04 10:00 — 1 changes2026-11-04 11:00 — 1 changes2026-11-04 12:00 — 0 changes2026-11-04 13:00 — 0 changes2026-11-04 14:00 — 2 changes2026-11-04 15:00 — 0 changes2026-11-04 16:00 — 2 changes2026-11-04 17:00 — 0 changes2026-11-04 18:00 — 2 changes2026-11-04 19:00 — 0 changes2026-11-04 20:00 — 0 changes2026-11-04 21:00 — 0 changes2026-11-04 22:00 — 1156 changes2026-11-04 23:00 — 962 changes2026-11-05 00:00 — 1121 changes2026-11-05 01:00 — 714 changes2026-11-05 02:00 — 0 changes2026-11-05 03:00 — 0 changes2026-11-05 04:00 — 2 changes2026-11-05 05:00 — 1 changes2026-11-05 06:00 — 0 changesAPPLIB/ORDLINES2026-11-04 07:00 — 0 changes2026-11-04 08:00 — 0 changes2026-11-04 09:00 — 0 changes2026-11-04 10:00 — 0 changes2026-11-04 11:00 — 0 changes2026-11-04 12:00 — 3 changes2026-11-04 13:00 — 1 changes2026-11-04 14:00 — 0 changes2026-11-04 15:00 — 1 changes2026-11-04 16:00 — 2 changes2026-11-04 17:00 — 0 changes2026-11-04 18:00 — 0 changes2026-11-04 19:00 — 0 changes2026-11-04 20:00 — 2 changes2026-11-04 21:00 — 2 changes2026-11-04 22:00 — 1247 changes2026-11-04 23:00 — 1256 changes2026-11-05 00:00 — 504 changes2026-11-05 01:00 — 0 changes2026-11-05 02:00 — 3 changes2026-11-05 03:00 — 0 changes2026-11-05 04:00 — 0 changes2026-11-05 05:00 — 0 changes2026-11-05 06:00 — 0 changesAPPLIB/INVOICE2026-11-04 07:00 — 0 changes2026-11-04 08:00 — 0 changes2026-11-04 09:00 — 0 changes2026-11-04 10:00 — 1 changes2026-11-04 11:00 — 2 changes2026-11-04 12:00 — 1 changes2026-11-04 13:00 — 2 changes2026-11-04 14:00 — 3 changes2026-11-04 15:00 — 0 changes2026-11-04 16:00 — 0 changes2026-11-04 17:00 — 0 changes2026-11-04 18:00 — 2 changes2026-11-04 19:00 — 3 changes2026-11-04 20:00 — 0 changes2026-11-04 21:00 — 0 changes2026-11-04 22:00 — 1 changes2026-11-04 23:00 — 1 changes2026-11-05 00:00 — 689 changes2026-11-05 01:00 — 565 changes2026-11-05 02:00 — 0 changes2026-11-05 03:00 — 3 changes2026-11-05 04:00 — 1 changes2026-11-05 05:00 — 0 changes2026-11-05 06:00 — 3 changesAPPLIB/AUDITLOG2026-11-04 07:00 — 0 changes2026-11-04 08:00 — 0 changes2026-11-04 09:00 — 0 changes2026-11-04 10:00 — 0 changes2026-11-04 11:00 — 3 changes2026-11-04 12:00 — 0 changes2026-11-04 13:00 — 0 changes2026-11-04 14:00 — 0 changes2026-11-04 15:00 — 8 changes2026-11-04 16:00 — 0 changes2026-11-04 17:00 — 0 changes2026-11-04 18:00 — 23 changes2026-11-04 19:00 — 11 changes2026-11-04 20:00 — 0 changes2026-11-04 21:00 — 2 changes2026-11-04 22:00 — 14 changes2026-11-04 23:00 — 0 changes2026-11-05 00:00 — 0 changes2026-11-05 01:00 — 2 changes2026-11-05 02:00 — 18 changes2026-11-05 03:00 — 0 changes2026-11-05 04:00 — 20 changes2026-11-05 05:00 — 9 changes2026-11-05 06:00 — 16 changes
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
#TableKey columnsTypeValueTimesMTI
1ORDERSCUSTNO, ORDDATE (covers 2)RADIX
2460252
2ORDHISTSTATUSEVI
4100
3CUSTOMERREGION, NAMERADIX
9512

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:

CREATE INDEX APPLIB.ORDERS_IX1 ON APPLIB.ORDERS (CUSTNO, ORDDATE);
CREATE ENCODED VECTOR INDEX APPLIB.ORDHIST_EVI2 ON APPLIB.ORDHIST (STATUS);

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.

Example with sample data
/home/app/logs 1.1 GB📁 logs1.1 GB/home/app/archive 660.0 MB📁 archive660.0 MB/home/app/exports 400.0 MB📁 exports400.0 MB/home/app/docs 40.0 MB📁 docs40.0 MB/home/app/src 260 KB
/ › home › app

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.

Example with sample data
NovDecJanFebMarAprMayJunJulAugSepOctNovMonWedFri2025-11-02: 22025-11-03: 02025-11-04: 22025-11-05: 22025-11-06: 42025-11-07: 32025-11-08: 02025-11-09: 02025-11-10: 02025-11-11: 02025-11-12: 02025-11-13: 02025-11-14: 22025-11-15: 02025-11-16: 02025-11-17: 02025-11-18: 42025-11-19: 02025-11-20: 02025-11-21: 02025-11-22: 02025-11-23: 02025-11-24: 22025-11-25: 02025-11-26: 22025-11-27: 02025-11-28: 32025-11-29: 02025-11-30: 02025-12-01: 02025-12-02: 22025-12-03: 12025-12-04: 02025-12-05: 02025-12-06: 02025-12-07: 02025-12-08: 12025-12-09: 42025-12-10: 02025-12-11: 32025-12-12: 42025-12-13: 02025-12-14: 02025-12-15: 02025-12-16: 12025-12-17: 02025-12-18: 12025-12-19: 22025-12-20: 02025-12-21: 02025-12-22: 02025-12-23: 02025-12-24: 42025-12-25: 02025-12-26: 22025-12-27: 02025-12-28: 02025-12-29: 42025-12-30: 22025-12-31: 02026-01-01: 02026-01-02: 02026-01-03: 02026-01-04: 02026-01-05: 32026-01-06: 42026-01-07: 32026-01-08: 02026-01-09: 12026-01-10: 02026-01-11: 02026-01-12: 12026-01-13: 22026-01-14: 02026-01-15: 22026-01-16: 02026-01-17: 02026-01-18: 02026-01-19: 02026-01-20: 12026-01-21: 22026-01-22: 02026-01-23: 22026-01-24: 02026-01-25: 02026-01-26: 42026-01-27: 02026-01-28: 32026-01-29: 02026-01-30: 02026-01-31: 02026-02-01: 02026-02-02: 02026-02-03: 22026-02-04: 12026-02-05: 12026-02-06: 12026-02-07: 02026-02-08: 22026-02-09: 02026-02-10: 02026-02-11: 22026-02-12: 12026-02-13: 12026-02-14: 02026-02-15: 02026-02-16: 32026-02-17: 02026-02-18: 02026-02-19: 22026-02-20: 32026-02-21: 02026-02-22: 22026-02-23: 02026-02-24: 02026-02-25: 02026-02-26: 02026-02-27: 42026-02-28: 02026-03-01: 02026-03-02: 02026-03-03: 02026-03-04: 22026-03-05: 12026-03-06: 02026-03-07: 02026-03-08: 02026-03-09: 02026-03-10: 12026-03-11: 02026-03-12: 02026-03-13: 02026-03-14: 02026-03-15: 02026-03-16: 02026-03-17: 12026-03-18: 22026-03-19: 22026-03-20: 02026-03-21: 02026-03-22: 02026-03-23: 02026-03-24: 22026-03-25: 12026-03-26: 12026-03-27: 02026-03-28: 02026-03-29: 02026-03-30: 42026-03-31: 02026-04-01: 02026-04-02: 02026-04-03: 22026-04-04: 02026-04-05: 02026-04-06: 02026-04-07: 02026-04-08: 02026-04-09: 02026-04-10: 02026-04-11: 02026-04-12: 02026-04-13: 02026-04-14: 02026-04-15: 22026-04-16: 02026-04-17: 02026-04-18: 02026-04-19: 02026-04-20: 32026-04-21: 02026-04-22: 02026-04-23: 02026-04-24: 02026-04-25: 02026-04-26: 02026-04-27: 22026-04-28: 02026-04-29: 02026-04-30: 32026-05-01: 12026-05-02: 02026-05-03: 02026-05-04: 42026-05-05: 02026-05-06: 02026-05-07: 32026-05-08: 02026-05-09: 02026-05-10: 02026-05-11: 22026-05-12: 32026-05-13: 02026-05-14: 32026-05-15: 12026-05-16: 02026-05-17: 22026-05-18: 02026-05-19: 02026-05-20: 92026-05-21: 12026-05-22: 02026-05-23: 02026-05-24: 02026-05-25: 02026-05-26: 22026-05-27: 02026-05-28: 112026-05-29: 52026-05-30: 02026-05-31: 02026-06-01: 02026-06-02: 112026-06-03: 92026-06-04: 02026-06-05: 32026-06-06: 02026-06-07: 02026-06-08: 02026-06-09: 12026-06-10: 02026-06-11: 12026-06-12: 02026-06-13: 02026-06-14: 02026-06-15: 02026-06-16: 02026-06-17: 22026-06-18: 02026-06-19: 42026-06-20: 02026-06-21: 02026-06-22: 42026-06-23: 02026-06-24: 02026-06-25: 02026-06-26: 12026-06-27: 02026-06-28: 02026-06-29: 02026-06-30: 02026-07-01: 02026-07-02: 02026-07-03: 22026-07-04: 02026-07-05: 02026-07-06: 02026-07-07: 02026-07-08: 02026-07-09: 02026-07-10: 42026-07-11: 02026-07-12: 02026-07-13: 02026-07-14: 22026-07-15: 32026-07-16: 22026-07-17: 12026-07-18: 02026-07-19: 02026-07-20: 22026-07-21: 02026-07-22: 02026-07-23: 42026-07-24: 02026-07-25: 02026-07-26: 02026-07-27: 12026-07-28: 22026-07-29: 22026-07-30: 02026-07-31: 12026-08-01: 02026-08-02: 02026-08-03: 22026-08-04: 22026-08-05: 02026-08-06: 22026-08-07: 02026-08-08: 02026-08-09: 02026-08-10: 02026-08-11: 02026-08-12: 12026-08-13: 12026-08-14: 02026-08-15: 02026-08-16: 02026-08-17: 02026-08-18: 02026-08-19: 32026-08-20: 12026-08-21: 02026-08-22: 02026-08-23: 02026-08-24: 02026-08-25: 02026-08-26: 02026-08-27: 02026-08-28: 02026-08-29: 02026-08-30: 02026-08-31: 02026-09-01: 22026-09-02: 42026-09-03: 02026-09-04: 32026-09-05: 02026-09-06: 02026-09-07: 22026-09-08: 02026-09-09: 02026-09-10: 02026-09-11: 02026-09-12: 02026-09-13: 02026-09-14: 02026-09-15: 22026-09-16: 32026-09-17: 22026-09-18: 02026-09-19: 02026-09-20: 02026-09-21: 02026-09-22: 62026-09-23: 02026-09-24: 02026-09-25: 92026-09-26: 02026-09-27: 02026-09-28: 02026-09-29: 32026-09-30: 02026-10-01: 102026-10-02: 02026-10-03: 02026-10-04: 02026-10-05: 112026-10-06: 122026-10-07: 52026-10-08: 02026-10-09: 22026-10-10: 02026-10-11: 32026-10-12: 32026-10-13: 02026-10-14: 02026-10-15: 62026-10-16: 02026-10-17: 02026-10-18: 02026-10-19: 02026-10-20: 02026-10-21: 12026-10-22: 02026-10-23: 32026-10-24: 02026-10-25: 02026-10-26: 22026-10-27: 02026-10-28: 02026-10-29: 22026-10-30: 02026-10-31: 02026-11-01: 02026-11-02: 32026-11-03: 12026-11-04: 02026-11-05: 0
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.