Java Batch Reporter

Edit online

OMEGAMON AI for Db2 6.1.0 introduces Java Batch Reporter, a redesigned, Java-based batch reporting engine that processes Db2® SMF historical performance data faster and more efficiently by leveraging multithreading, zIIP offloading, and 64-bit memory addressing.

Java Batch Reporter will remain compatible with existing FILE and SAVE-CONVERT outputs, allowing you to migrate smoothly without changing data collection methods. The new engine improves scalability, reduces CPU resource consumption, and significantly shortens elapsed time for batch reporting jobs, helping you analyze large volumes of historical data more effectively.

Key Features of Java Batch Reporter:
  • Java-Based Multithreaded Engine: Processes historical Db2 SMF records concurrently, reducing elapsed processing time.
  • zIIP Offloading Support: Offloads processing to zIIP engines to decrease general CPU utilization.
  • 64-Bit Memory Addressing: Overcomes previous limitations of 31-bit addressing for improved scalability with large datasets

The classic Batch Reporter continues to be the premier solution for historical Db2 data reporting. However, if you process large quantities of SMF data (n x 106 records), the Batch Reporter has some limitations.

This version delivers a streamlined set of core capabilities while maintaining interface compatibility with the classic Batch Reporter to ensure continuity for existing workflows.

Additional features and enhancements will be delivered incrementally through a continuous delivery model, enabling you to benefit from ongoing improvements without disruptive upgrades.

Note: In version 6.1.0, a limited set of reports are eligible. More reports will be available in future quarterly enhancement releases.
Table 1. Java Batch Reporter Support Matrix
Report Set Supported IFCIDs Output Functions
Record Trace 001, 002, 199, 225, 365, 369, 402, 411, 412 Trace

Sample JCL for Java Batch Reporter report

See Figure 1 for a sample of the JCL used to produce a report in the Java Batch Reporter.

Figure 1. Sample JCL for Java Batch Reporter report
 //GO       EXEC PGM=FPEJMAIN,
//         PARM='ENVAR("_CEE_ENVFILE_S=DD:STDENV")/-c -i'
//STEPLIB  DD DISP=SHR,DSN=YOUR.STEPLIB.DATASET
//INPUTDD  DD DISP=SHR,DSN=YOUR.INPUT.DATASET
//SYSPRINT DD SYSOUT=*
//DPMLOG   DD SYSOUT=*
//DPMERROR DD SYSOUT=*,LRECL=200
//RECTRACE DD SYSOUT=*
//STDENV   DD *
_CEE_ENVFILE_CONTINUATION=\
LIBPATH=/path/to/java/lib/j9vm/:/path/to/java/lib
CLASSPATH=/path/to/product/jar/your-product.jar
/*
//SYSIN    DD *
INCLUDE GLOBAL(IFCID(1,2,402))
RECTRACE
   TRACE
      LEVEL(LONG)
EXEC
/*