Knowledgebase
Q&A
Latest Updates
Oct
12
New EZ-DB2 Maintenance - CX910317
Posted by Clive Petley on 12/10/17 @ 4:20 PM

New EZ-DB2 Maintenance - CX910317 has been issued.

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

  • Add workload Statistics Feedback report to Warehouse.
  • Add display of RUNSTATS Profile to Statistics Feedback reports: drill on Reason column.
  • Add IFCID 363 to trace to capture 'straw model' parallel activity.
  • Correct Parallel CPU collection.
  • Report Parallel CPU time separately on SQL reports and SQL detail screen.
  • Report SE CPU Time (zIIP/zAAP) separately on SQL reports and SQL detail screen - note DRDA limitation below!
  • Add Tracer log switch timings to log switch messages.
  • Fully break down Cursor times to show CLOSE separately.
  • Add Connection Type to SQL reports and SQL detail screen. Identifies where SQL originated from (eg CAF, CICS, DRDA etc). 
  • Add DB2 Release details to Trace Summary Reports screen. For DB2 12, also display the Mod Level.
  • Display of Explain Table DB2 versions fixed for V12.

For more details on the new fields reported by EZ-Tracer, see KB article: Info On New EZ-Tracer Information


Read more »



Sep
27
New EZ-DB2 Maintenance - CX910316
Posted by Clive Petley on 27/09/17 @ 11:06 AM

New EZ-DB2 Maintenance - CX910316 has been issued.

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

  • Support for sites without Cobol 5 runtime installed. APARs since CX910314 have contained Cobol 5 object libraries.
    This causes problems for sites that have not upgraded to Cobol 5 or who have not installed IBM's Cobol 5 runtime support PTFs.
    While Cobol 4.2 is supported by IBM, APARs from this one forward, will seamlessly support both COBOL 5 and COBOL 4.2.
  • Correction to V12 definition for explain table DSN_STATEMNT_TABLE.  


Read more »



Aug
23
New EZ-DB2 Maintenance - CX910315 & WH APAR CW910014
Posted by Clive Petley on 23/08/17 @ 4:48 PM

New EZ-DB2 Maintenance - CX910315 has been issued. 

Note, users with Warehouse Databases must apply the co-req Warehouse APAR CW910014, to each Warehouse DB.

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

  • Add new features to support DB2 Statistics Feedback for missing/conflicting statistics. New command SF when displaying single SQL. New menu options, 2.5B & 5.11.
  • New search command FINDSQL to just search reports for SQLno. Abbreviates to FS. Especially useful in EZ-Tracer report 23.
  • Runtime improvements to XOPIXAN.
  • Create and update of EXPLAIN tables now supports DB2 V12.
  • Warehouse DDL updates for Statistics Feedback.
  • Fix for applying Warehouse APARs.
  • Fix for PDS to PDS/E conversion.

Read more »



Jun
14
New EZ-DB Maintenance for R6.0/R5.7 APAR CDL10009 & PTF CSK07035
Posted by Clive Petley on 14/06/17 @ 3:42 PM

New EZ-DB Maintenance for R6.0 - APAR CDL10009 has been issued. The corresponding maintenance for R5.7 - PTF CSK07.035, has also been issued. 

  • EZ-Share may fail to initialize correctly.
  • EZ-Synchro/EZ-Share stats output as zero to shutdown log if no DBSLOG specified.


Read more »



Apr
27
New EZ-DB2 Maintenance - CX910313
Posted by Clive Petley on 27/04/17 @ 10:15 AM

New EZ-DB2 Maintenance - CX910313 has been issued.

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

  • Prevent abends when loading Warehouse workload with more than max number of traces.
  • Increase maximum number of traces that can be loaded to the Warehouse in single run from 200 to 500.
  • SQL Parser improvements. 


Read more »