News
Mar
8
New EZ-DB2 Maintenance - CX910320
Posted by Clive Petley on 08/03/18 @ 5:12 PM

New EZ-DB2 Maintenance - CX910320 has been issued.

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

  • Cursor name was being truncated for static SQL which resulted in statement not found in EZ-Tracer.

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


Read more »



Feb
13
New EZ-DB2 Maintenance - CX910319
Posted by Clive Petley on 13/02/18 @ 5:47 PM

New EZ-DB2 Maintenance - CX910319 has been issued.

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

  • SQL error in Impact Analyzer due to invalid bind time.
  • Impact Analyzer using incorrect qualifier to access DSN_STAT_FEEDBACK.

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


Read more »



Jan
24
New EZ-DB2 Maintenance - CX910318
Posted by Clive Petley on 24/01/18 @ 6:14 PM

New EZ-DB2 Maintenance - CX910318 has been issued.

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

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

  • Correct condition code error in APAR JCL.
  • Report Parallel & SE CPU times in Warehouse.
  • New report SQL Predicate Details when viewing access paths. Drill on the old 'Narrative' column in the AP access path report. To see the new report for existing work-loads, users will need to refresh the access paths. The 'Narrative' report column has been renamed to 'Drill for Predicates'.                       *
  • If profile is active, we no longer display profile id in 'hint used' on the access path report. Instead, when the DSN_STATEMNT_TABLE. REASON column contains the profile id, then the same will be available in the reason column on the access path report.
  • Don't report 'Remote Bind' in EZ-Tracer when the SQL is DDF.        
  • New separate 'Create/Recreate Trend Analysis DB' option 2.3B in EZDB2I panels. 
  • EZ-Tracer/Cache 'Populate Trend Analysis DB' control simplified to Y/N. Y will populate all previous trend options.

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


Read more »



Nov
27
Cogito Support Portal URL's
Posted by Clive Petley on 27/11/17 @ 5:36 PM

Please be aware that the Cogito support portal's URL has changed from https://my.cogito.co.uk to https://cogitosupport.syncsort.com.

We encourage you to use the new URL, though the change should be transparent to you, as the old URL will continue to work and will redirect you to https://cogitosupport.syncsort.com.

Please contact us if you have any problems accessing the portal.


Read more »



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 »