New EZ-DB2 Maintenance - CX910324 has been issued.

EZ-DB2 users should download the latest maintenance and apply as soon as convenient.

• Use STMTID where possible, in place of STMTNO for static SQL in EZ-Tracer. Resolves possible duplicate STMTNO's that can be generated by PL/I compilations.
• Add initial EZ-Impact Analyzer event output to Ironstream.
• General improvements to SQL parser.

We are excited to announce the availability of EZ-Tracer and EZ-Cache integration with Syncsort Ironstream, to allow SQL metrics to be ingested directly by Splunk or Elasticsearch. This will allow users to perform advanced analytics off-mainframe, using the SQL statement metrics captured by EZ-Tracer/EZ-Cache.

For further details please see the Knowledgebase article SQL Analytics from EZ-Tracer/EZ-Cache to Splunk - or contact us for further details.

The optional Trend Analysis Database, that allows the user to capture SQL execution metrics over an extended period of time, has also been enhanced. The metrics now include new fields for parallel time, speciality engine time (zIIP/zAAP), a more detailed cursor breakdown and the Db2 connection type. The trace summary now includes details of the Db2 release and modification levels, that were in effect at the time if the trace and there are additional tables that allow users to add their own comments and notes to a trace or specific SQL statement. For details of the new table layouts see the updated Tables Reference V9.2.1.

The above functionality is introduced with software APAR CX910323 and Trend Analysis DB APAR CT910003.

New EZ-DB2 Maintenance - CX910323 has been issued.

EZ-DB2 users should download the latest maintenance and apply as soon as convenient.

• EZDB2 to Splunk via Syncsort Ironstream (for further details see article: SQL Analytics From EZ-Tracer/EZ-Cache to Splunk)
• Enhanced Trend Analysis Database - New Trend DB APAR CT910003 is a co-req (download the latest table details - Tables Reference V9.2.1)

A copy of our Privacy Policy can be viewed here, on our website, or it can be forwarded directly upon request.

New EZ-DB for IDMS Maintenance - CDL10010 has been issued.

EZ-DB users should download the latest maintenance and apply as soon as convenient.

• Drop all two phase commit records in EZ-SQP

New EZ-DB2 Maintenance - CX910322 has been issued.

EZ-DB2 users should download the latest maintenance and apply as soon as convenient.

• Fix -805 in 'Edit and Explain' command (EE).
• Fix -805 in Statistics Feedback reports.