New Optimize DB2 (EZ-DB2) Maintenance - CXA00010 has been issued for V10.0

Syncsort Optimize DB2 V10.0 users should download the latest maintenance and apply as soon as convenient.

• Duplicate SQL Numbers can be generated when SQL consolidation is turned off
• Include DSN_PREDICAT_TABLE in default tables created when using option 9.2.11 - CREATE New EXPLAIN Plan Table
• Update Help panels with latest CPU fields

New EZ-DB2 Maintenance -  CX910331 for V9.10

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

• Possible S0C7's after applying CX910330.

New Optimize DB2 (EZ-DB2) Maintenance - CXA00010 has been issued for V10.0 and CX910330 for V9.10

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

• Fix unexpected characters in DRDA SQL text - can cause DRDA Cursor metrics to be incorrectly accounted.
• Improve FETCH metrics in DRDA 'blocked' or 'bundled' cursors.
• Improve accounting of parallel time metrics.
• Correct accounting of zIIP time metrics for DRDA cursors.
• Fix 'RID/RLIM Failures' alignment on SQL detail display.
• Fix drill on Thread Key in Report 25.8.
• New IFCID Trace facility - for support use.
• (V10 Only) Add new CPU Time split into 'GP Time' and 'zIIP Time'. Reports updated to show new 'GP Time' column. Sort on 'GP Time' to show most expensive SQL on GP - excluding zIIP time.

Note: Select the required APAR for your release level

New Optimize DB2 (EZ-DB2) Maintenance - CXA00009 has been issued for V10.0 and CX910329 for V9.10

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

• 'SQL With Errors' drill down and 'SQL Error Audit Trail' reports, now indicate when reports are truncated due to report limits. 
• XOPSUMTP summary reports can be corrupted when using log datasets with intervals and logs fill prior to an interval end. (V10 only)

Note: Select the required APAR for your release level

New Optimize DB2 (EZ-DB2) Maintenance - CXA00008 has been issued for V10.0 and CX910328 for V9.10

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

• Increase 'SQL Errors' counts fields on reports to prevent truncation of totals.
• Warning message if report 25.6 - SQL with Errors, exceeds max report limit.
• Limit maximum SQL Error details recorded for a given SQLNO to 1000 occurrences to prevent 'flooding' report. Can be overridden with new parameter MAX_SQLERR_PERSQL.

Note: Select the required APAR for your release level

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

While Syncsort has become Precisely, the mainframe software portfolio continues to use the trusted Syncsort mainframe brand.

The EZ-DB2 suite is now 'Syncsort Optimize DB2' and this APAR introduces the rebranding to V10.0. All panels, menus and jobs have been updated to 'Syncsort Optimize DB2'.

The individual component names have also changed to become part of Precisely's Syncsort mainframe portfolio:

• Syncsort DB2 Tracer - formerly EZ-Tracer
• Syncsort DB2 Cache - formerly EZ-Cache
• Syncsort DB2 Impact Analyzer - formerly EZ-Impact Analyzer
• Syncsort DB2 Index Analyzer - formerly EZ-Index Analyzer
• Syncsort DB2 SQL Warehouse - formerly EZ-SQL Warehouse
• Syncsort DB2 Stats - formerly EZ-Stats
• Syncsort DB2 Alerts - formerly EZ-Alerts

Note: This APAR is only for EZ-DB2 V10.0 installations - EZ-DB2 V9.1 will not be rebranded and will continue to be the EZ-DB2 suite.