Knowledgebase
Q&A
Latest Updates
May
20
New EZ-DB2 Maintenance - CXA00001 has been issued for V10.0
Posted by Clive Petley on 20/05/19 @ 6:01 PM

New EZ-DB2 Maintenance - CXA00001 has been issued for V10.0

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

  • Runtime parameter output now goes to EZD2PRM. 
  • Dynamic allocation output now goes to EZD2ALC.
  • Command UTL now runs the Trace Status report. Alternatively, option '9.1.5 - Full EZ-DB2 Status Report' can be used. The Status Report panel also allows Trace CSA control blocks to be cleared.
  • New EZD2AUD audit trail in Master STC's job output. This logs the start and end of all distinct EZ-Tracer and EZ-Cache jobs - main trace, post processing and report jobs/tasks - irrespective of whether they were initiated via the Master STC.
  • Various improvements to messaging and processing in EZ-Tracer and EZ-Cache. 
  • Additional checks in EZ-Cache to trap corrupt IFCID 316 length field and prevent possible IEC036I 002-18 abend in XOPTRACE. 
  • Test for Db2 12 returning error status 00E60831 and end. Check IBM for UI59961. 
  • Add TCB update steps to Reports job, when running traces in batch. 
  • Fix Reports JCL in STC/Logstream mode when tracing host variables. 
  • Automatically delete existing Logs datasets if found, when starting a trace. 
  • New Master STC command to clear a log stream '/F ezvxmst,CLEARLGS logstream_name' 
  • Correct generated batch trace jobs to use the alternative authorized loadlib if set. 
  • New Master Started Task 'force start' option - see notes in EZVXMST replacement proc.

Note: This APAR is only for EZ-DB2 V10.0 installations


Read more »



May
14
New EZ-DB2 V9.1 Maintenance - CX910325
Posted by Clive Petley on 14/05/19 @ 6:09 PM

New EZ-DB2 Maintenance - CX910325 has been issued for V9.1

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

  • Additional checks in EZ-Cache to trap corrupt IFCID 316 length field and prevent possible IEC036I 002-18 abend in XOPTRACE
  • Test for Db2 12 returning error status 00E60831 and end. Check IBM for UI59961

Note: This APAR is only for EZ-DB2 V9.1 installations


Read more »



Apr
2
Announcement - EZ-DB2 Release 10.0 is now GA
Posted by Clive Petley on 02/04/19 @ 12:11 PM

We are pleased to announce that EZ-DB2 Release 10.0 is now GA and available for immediate download.

Release 10 brings significant architecture changes to the EZ-Tracer and EZ-Cache tools, allowing for more dynamic workload and trace control. Version 10 positions EZ-DB2 ready for continued improvements and future integration with other tools and products.

Release 10 changes include:

  • Ability to run traces as true started tasks.
  • Flexibility in creating and modifying trace workloads.
  • Control and monitoring of EZ-Tracer and EZ-Cache traces via a Master EZ-DB2 started task.
  • Use of logstreams when capturing Db2 trace data.
  • The ability to run trace post processing continuously, while the trace data is still being captured.

The 'EZ-DB2 V10 What’s New – Release Summary' provides an overview of the changes and the benefits they bring.

Existing EZ-DB2 customers can download the latest Release 10 User Guide Addendum from the 'EZ-DB2 Release 10 Documentation' page and the latest GA installation files from the 'EZ-DB2 Release 10.0 Base Installation' page.


Read more »



Dec
14
New EZ-DB2 Maintenance - CX910324
Posted by Clive Petley on 14/12/18 @ 3:22 PM

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.

Read more »



Jul
3

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.


Read more »