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