News
Apr
5
New EZ-DB for IDMS Maintenance - CDL10010
Posted by Clive Petley on 05/04/18 @ 5:55 PM

New EZ-DB for IDMS Maintenance - CDL10010 has been issued.

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

  • Drop all two phase commit records in EZ-SQP

Read more »



Apr
5
New EZ-DB2 Maintenance - CX910322
Posted by Clive Petley on 05/04/18 @ 5:51 PM

New EZ-DB2 Maintenance - CX910322 has been issued.

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

  • Fix -805 in 'Edit and Explain' command (EE).
  • Fix -805 in Statistics Feedback reports.

Read more »



Mar
23
New EZ-DB2 Maintenance - CX910321
Posted by Clive Petley on 23/03/18 @ 4:33 PM

New EZ-DB2 Maintenance - CX910321 has been issued.

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

  • EZ-Tracer may abend with message 'FREE KCV FAILED' when attempting to free orphaned entries.
  • EZ-Stats may attempt to translate qualifiers when copying stats between systems, even if 'Qualifier Translation : N' is specified.

Read more »



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 »