1.JCL failure in Impact Analyzer processing Tracer Workload with just free form SQL text.
2. Add Dynamic Prepare CPU to Tracer summary reports.
3. Fix problem with missing prepares when tracing SPUFI SQL.
4. Improve reporting of work file table types in access path reports.
5. Load from Catalog now includes MERGE SQL.
6. When importing Workloads into Warehouse you may now choose from Tracer, Impact Anayzer or Warehouse Workloads.
7. SQL Formatting Enhancements.
8. New reporting option in Impact Analyzer for Warehouse Workloads to generate a comparison between Tracer Access Path Versions B and E.
9. Fix to excessive XOPTRC2 runtime when a Dynamic Prepare is missed and followed by many executes.
10. Correctly identify lowercase 'create trigger' in Tracer and correct invalid replacement of certain tokens in trigger with ?.
11. Add Filter options to Virtual Index Table lists.
12. Correct BIND PLAN table matching in Impact Analyzer.
13. Correct processing in IA for 2 DBRMLIBs on 2 LPARs.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Re-BIND for new EZ-DB2 Plan Names.

1. EZ-DB2 Trend Database changes for all DB2 versions.

1. EZ-DB2 Warehouse Database changes for all DB2 versions.

1. EZ-DB2 Trend Database changes for all DB2 versions.

1. Restructure all XOPSQLCP VSAM files. This APAR is a co-requisite of CX910051 or later. It must be applied once after applying CX910051 or later.

1. Tidy up SQL executions drill report.
2. Declare GTTs in Index Optimizer.
3. Use cut down plan table set in IX Optimizer.
4. Preserve XML indexes etc in Index Optimizer.
5. Some SQL Explains fail using parameter markers - replace with CAST appropriate to column type.
6. Add Elapsed Time to Summary reports.
7. Add Dynamic Prepare CPU times to Summary, Authid and Plan reports.
8. Fix detection of V10 conversion mode.
9. Add 'WITH DEFAULT' to DSN_STATEMNT_TABLE definitions.

Note: If you have an EZ-DB2 Warehouse Database installed then first apply CW910007.

1. Menu Trace drill to show additional stats.
2. Additional statistics on Program Summary report.
3. Tracer access path processing enhanced to provide optional refresh of statistics.
4. SQL text formatting improved.
5. Fix abend refreshing access paths.
6. Fix fault causing partial Index Analysis.
7. Add dedicated explain tables for XOP. CW910007 must also be applied.
8. Fix RC=12 loading Bind Access Paths when DETCOST data may be missing.
9. Tracer abend processing Prepare of DECLARE GTT with statement number zero.

1. Possible S0C4 in Tracer running trace sampling with multi processors.
2. Update GRANTs for the Explain Stored Procedure.

1. Traces may terminate prematurely when sampling is active.
2. SQL Parser support for EXTRACT FROM.
3. Option 9.9 lists all available EZ-DB2 panel commands.
4. Tracer abend where Host Variable is VARCHAR with zero length.
5. Tracer Edit and Explain use Version B for comparison when Version E not present.
6. Allow 8 filters per type in Load SQL from Catalog.
7. Impact Analyzer display TOTAL_COST for Timerons in Bind access paths.

1. STATIC SQL Cache. EZ-Cache will now read Dynamic or Static Cache or both.
2. Capture Host Variable and Literals enhancements:
Capture SQL with no HV or Lits for completeness.
Enter HV sqlno from SQL reports to list all executions of SQLNO.
New Option 2.2.25.6 to generate ad-hoc reports of SQL executions.
Drill on THREAD KEY to list all SQL executions for a thread.
Capture INSERT (otherwise ignored) when it fails.
3. New Elapsed Time Thresholds.
4. Improved REXX error message handling.
5. Allow SQL with simple or bracketed comments to be displayed and explained.
6. Enter R against a Workload name in the drill down list to issue an HRECALL command for all the Workload datasets.
7. SQL Parser changes to deal with XML functions.
8. Remove Impact Analyzer pre-filter limit of 32K package versions in plan table.
9. Displaying Transformed Text for large SQL may fail.
10. Support for Connect:Direct.
11. Allow deletion of statistics from EZ-Stats Archive and Warehouse.
12. Updates to Option 9.9 listing all available.

Note: If you have an EZ-DB2 Warehouse Database installed then first apply CW910006.

1.Support multiple Warehouses (only 1 per DB2 Subsystem).
2. Drill on Virtual Index names in Index Analyzer access path report.
3. Workloads with no SELECT statements fail Index Analysis.
4. Honour QUERYNO when loading free form SQL.
5. Display highest valid DB2 Version against each Explain table type in Plan Table drill.
6. Trigger consolidation errors.
7. Qualifier translation error with multiple databases using same TSNAME.
8. Set execute STMTNO correctly where multiple databases.
9. Ignore comments in free form SQL text.
10. Obscure parser errors.
11. Disallow Index Optimizer or Statistics controls when WH is installed in a Production system.
12. When using Live Statistics in WH refresh WH STATS repository.

1. Group Traces for Dynamic Statement Cache.
2. Multiple Workloads selected for deletion now deleted in a single
jobstream instead of one job per Workload.
3. Long Column names may result in Index Analysis failures.
4. Issue messages to Log on Authorisation failures.
5. Index Analyzer enhanced to allow acceptance of pre-defined Virtual
Indexes.
6. Sort error updating Statistics.
7. Edit and Explain failure on SQL with GTT.
8. Virtual Index COLNO limited to two digits.

1. UNICODE Plan Tables result in incorrect filtering in Impact Analyzer.
2. Correct stats when adding SQL to trace from Catalog.

1. Reduce Catalog access for interval traces.
2. Explain of SQL > 32K fails.
3. XOPSIXA failure with user indexes with more than 30 columns.
4. Spurious Version E access path displayed in Index Analyzer Edit and Explain.
5. Spurious Virtual Index panel messages. Parm file space allocation failure.
6. Display User Index > 24 columns causes abend in Virtual Indexes.
7. B37 in Export Workload.
8. After Load Free Form SQL, Index Analyzer says No Valid SQL.
9. 'Total-Cost' incorrect after Edit and Explain.

1. Warning message when EZ-DB2 limit of 32,000 programs is reached when processing access paths.
2. Deal with empty members in DBRMLIB.
3. Report all revelant access paths after Edit and Explain.
4. New command DB2T displayd SQL text after query transformation following Edit and Explain.
5. Create access path for SQL containing WHERE CURRENT OF cursor_name when explaining SQL.
6. Index Analyzer: Report when a predicate set is used in the first table join and order the set to suit. Fix errors in reporting predicate type.
7. Add new Plan/Package filters option to Warehouse load.
8. Tracer, Load Freeform SQL Text: ignore cols 73-80, only 1 SQL member allowed.
9. Fix occasional loss of Trace Sample Interval.
10. Correct JCL generation when selecting indexes or tables for copying Catalog Statistics.
11. Trap null SQL from SPUFI in Tracer.
12. EZ-Cache reports zero elapsed times.
13. Add option to use Direct Connect in 9.4. See xopsprfx.CNTL(XOPWKSNY).

1. Fix issue where bind access paths are not loaded in EZ-Tracer.

1. S0CC abend explaining SQL. TOTAL-COST corrupt.
2. Tracer Explain Access Paths can't be turned off.
3. User indexes prefixed X00 mistaken for XOP indexes.

1.Stop possible loop in EZ-Tracer processing corrupt trace data.
2. Index Analysis failure processing very large access paths.

1. Allow users not authorised to update Workload datasets to view all Workload reports.
2. Clarify row stats help panels.
3. Possible Impact Analyzer abend processing very long SQL text and/or stored procedures.
4. Add User exit for user controlled consolidation of AUTHIDs.
5. Corrupt Host Variable IFCIDs may result in SQL consolidation failures.
6. Error creating indexes in XOP after CX910125.
7. Parser error JOIN ... ON ... IN (...).
8. Parser error on some qualified host variables.
9. Locate command added to 'Select SQL Text Member' popup.
10. Explain failures result using the stored procedure on SQL containing literals with hex zeroes. Use EZDB2I Option 2.5 to regenerate the SP.
11. Changes to TRACE GROUP Y/N lost after drill to filter parameters.
12. Impact Analyzer comparing QA to Prod on the LPAR fails to match access paths.

1. When loading access paths in Tracer from the bind plan table, respect plan stability.
2. Fix occasional prepare error in Tracer.

1. Possible spurious broken chain messages issued by Tracer.
2. New command provided to extend trace times: /F jobname,ADD,nnnn where nnnn is the number of minutes to be added to the trace.
3. Prevent possible CPU loop and S0C1 abends in Tracer processing corrupt data generated by DB2. Generate diagnostic data.
4. Add Jobcard to EZ-Stats copy statistics from one LPAR to another.
5. Correct Index Analyzer toggles.
6. Tracer Edit and Explain may attempt access to Warehouse database.
7. Correct edit and explain from Tracer Report 23.
8. Correct Tracer to properly handle data change table references in select statements.
9. Correct access path report where the contents of narrative and table creator were swapped.
10. REXX failure scrolling down multi-page interval list.
11. When importing statistics translate index name if necessary if Ignore Missing Objects = Y.

1. Possible spurious broken chain messages issued by Tracer.
2. New command provided to extend trace times.
3. Prevent possible CPU loop and S0C1 abends in Tracer processing corrupt data generated by DB2. Generate diagnostic data.
4. Add Jobcard to EZ-Stats copy statistics from one LPAR to another.
5. Correct Index Analyzer toggles.
6. Tracer Edit and Explain may attempt access to Warehouse database.
7. Correct edit and explain from Tracer Report 23.

1. Fix Statistics displays when the table name is longer than 18 characters.
2. Allow mixed case when specifying CORRID filters in Tracer.
3. New command provided to extend trace times.
4. Drill on Trace field and selecting a trace from the displayed list does not work in Tracer reports.

1. Fix to resolve loop in XOPTRC2 (XOPPARS).

1. Alert generation failure in DB2 V8 CM.
2. Cache "Only" trace displays corrupt trace time.
3. Allow filter by Table Name in Impact Analyzer.
4. Statistics extract failure in DB2 V8 CM.

1. Support DB2 V10 GA
2. New report command SET MAX LINES nnnnn to control the maximum number of rows displayed in reports.
3. Tracer interval reports deleted in error.
4. New temporary VSAM files introduced to allow generation of very large SQL by AUTHID reports.
5. Get around DB2 V9 bug in IFCID 0058 data.

1. Support MERGE statements.
2. Support Static SQL with Common Table Elements.
3. Consolidate Select and From Lists.
4. Explain long SQL > 32K.
5. Revised Trigger text processing for clarity.
6. New Filter FILTER FLAG SET/SQL ON/OFF to see only flagged SQL/Sets in reports.
7. New Tracer report to show Flagged SQL.
8. FLAG SQL/SET nnnnn now assumes optional SQL/SET depending on report.
9. EZ-Stats support for DB2 Groups.
10. Possible load failure S806 processing DB2 groups.

1. Fix drill failure in Index Analyzer.
2. Fix abend processing long SQL.
3. Workaround occasional bad timeron value.

1. Eliminate some unnecessary catalog access from XOPTRC2.
2. Fix drill on long names.
3. Host Variables not processed correctly in BETWEEN Clause.
4. Add L (locate) command to Workload lists.

1. Tracer abend S0C1 when the HLQ for Tracer Log files is > 21 bytes.
2. Cache Trace abends S0C4 when stored procedure name > 18 characters.

1. The installation default for the LE370 run time load library changed to LINKLIST. Specifying this value will mean it does not appear in STEPLIB in job streams.
2. RRSAF applications do not have host variables processed correctly.

1 Adjust Host Variable capture to deal with nullable columns.
2. XPRINT on SQL Drill to Text or Statistics now generates complete report of SQL Text, Statistics and Access Path.
3. Loading data into Warehouse may fail with explain errors where tables contain LOB or XML columns.

1 EZ-Tracer Index Report to use Version B in preference to Version E if present.
2. Possible explain failures in Index Analysis.
3. Possible Index Full error generating Index Analyzer reports.
4. Process Static SQL with qualified Cobol working storage host variables.
5. EZ-Tracer internal thread array management improved.
6. Select ALL Databases option added to EZ-Stats.

1 Provide AUTHID to QUALIFIER conversion for JDBC applications using SET CURRENT SCHEMA before the trace starts.
2. Help updates.
3. GTT not being processed properly within Stored Procedures.

1 Fix problem processing invalid data in explain plan tables generated by bugs in DB2 V9.
2. Fix end of job housekeeping on thread array.

1. Fix excessive Catalog access associated with certain static work-load patterns.

1.Long running dynamic SQL may not be recorded if the Prepare and Execute span multiple log files.
2. LE run time library name may not be set.
3. Possible Enqueue error drilling on Table.
4. New Toggle in EZ-Stats display of SYSCOLDIST data to switch between different TYPEs.
5. Spurious Statement Not Found messages with Unicode catalogs and no suitable index available on SYSSTMT.
6. Spurious 'Not Authorized' messages.

1. Fix possible loop generating reports for work-load containing invalid SQL text.
2. When drilling on SQL with same select lists garbage is displayed in Drill To field.
3. Restarting a failed Job Scheduler trace may generate incorrect JCL.

1. CALL statements result in skipped SQL numbers - causes problems with max SQL No = 99,999.
2. New V9 statistics captured.
3. New trace filter options to control which IFCIDs are traced.
4. New trace filter options to allow tracing of Host Variables and Dynamic Literals.
5. Load SQL From Catalog into Warehouse mistakenly checks Tracer password.

1. Index Analyzer REXX errors creating VirtualIndexes and Flagging Sets.
2. Refine PPHK management to reduce memory utilization.

1. EZ-Tracer S0C1 abend when 1st DB2 in a Group trace is inactive and has no trace data.
2. EZ-Tracer S0C7 in XOPSUMM when 1st SQL access path starts with work file.
3. Improve use of CAST where necessary to allow DB2 Explain to work.

1. Add new Tracer report on SQL with errors.
2. Tidy up Edit and Explain plan table drill.
3. EZ-XOP unload of sample data processes no data.

1. Provide more detailed messages for SQL that cannot be explained.
2. Disallow restructure of Warehouse if still CM.
3. Allow jump commands from reports viewing.
4. 24 hour repeating traces suffer delays in starting a new trace while prior trace completes consolidation.
5. Tracer Option 2.5 to generate access paths may corrupt trace summary statistics.
6. Impact Analyzer not matching changed statement numbers in DBRMLIB.
7. Impact Analyzer and Unicode Catalog generates wrong package lists.
8. Add new Alerts for V9 Reserved Words.
9. New APAR naming conventions for Database updates.
10. Cater for trace IFCIDs in Unicode.

1. XOPSUMM terminates RC16 processing long table names.
2. Trace/Interval number not reset in summary panels after REXX failure.
3. Cache statistics incorrect with high volume high volatility SQL.
4. UPDATE Where Current of Cursor processing to show Update instead of artificial Select.

1. EZ-Stats edit of table statistics blanks out Nix.
2. Impact Analyzer processing against two LPARs with different Collection Names processes incorrectly.
3. Alerts check of tablespace rows changed to ignore -1 = no statistics.
4. Select of individual instead of all traces in Warehouse Load results in error message No Traces Selected.
5. REXX error drilling on Duplicat.
6. Spurious new statements found messages in Impact Analyzer processing singleton selects in a member of a DBRMLIB.
7. Suppress consolidation of Static SQL in Impact Analyzer.
8. Drill on Access Path controls from Tracer controls disabled for new Workloads.
9. New Alerts for Join SQL coded with SELECT DISTINCT and CURSOR SQL issuing a single FETCH.
10. Trend Analysis Workload name corrupted with procedure to create daily Workloads.
11. XOPMASK corrected.
12. Add 3rd JOBCARD to scheduled traces.
13. Having two concurrent sessions on trace summary data may show wrong results.

1. Fix Repeating Scheduled traces.
2. WITH HOLD not processed properly loading SQL from Catalog results in spurious EXPLAIN errors.
3. Improved algorithms in Index Analyzer.
4. Edit and Explain enhanced for GTT.
5. Some GRANT permissions missing semicolon.
4. Access path drill Narrative field adjusted to help show MC=nn without scrolling.
5. New Tracer parameter under Filter Controls: Keep Traces = nnn - If you want old traces automatically deleted to free DASD then set nnn to the number of traces you want kept. The most recent nnnwill be retained and older trace data deleted.
6. Trace descriptions changed to show DAY of trace.
7. Drill to list of plan tables display changed to indicate existence of all the tables used by EZ-DB2.
8. New procedures for creating new Daily or Monthly Workloads.

1. Allow 00E60084 errors to continue processing when buffer size too small for Group traces.
2. Include zIIP costs in CPU utilization where parallelism is invoked.
3. EXPLAIN failures with host variable as last entry in the SELECT list.
4. SET PROFILE command in Tracer and Cache extended to include Trace Parameters panel values.
5. CREATE abcdefgh in Tracer or Cache will create a new Workload with name ABCDEFGH using the same parameters as the current Workload.
6. In Impact Analyzer VNext qualifier translation only applies to the new Subsys.
7. Fix abend in Tracer Report generation.
8. Trace/Workload Summary connects to correct Subsys.
9. Fix loop on invalid SQL in report generation.
10. Allow EZ-Tracer to process PEOPLESOFT data. New parameter SAP/PEOPLESOFT in the Trace filter parameter panel can be set to S or P repectively. Drill on the value for a pop-up which allows input of up to 12 values for AUTHID and the associated default QUALIFIER.
11. DB2 Bug may result in SQL error in XOPEXP2 with spurious SQL Not Prepared message when explaining large numbers of SQL.
12. Enable WH to use correct STATS datasets with DB2 Groups.
13. New Tracer RESTART number 5 to run the job to populate the Trend Analysis Database.
14. Drill on Program Name in the Plan/Program report in Tracer and Warehouse fails.
15. When importing traces to Warehouse include GTT database.
16. Load SQL From Catalog in Warehouse always connects to WH Subsys.
17. Enhancements to Index Analyzer predicate set analysis.

1. 0CC Abend in XOPPATH.
2. Index Analyzer set costs not calculated correctly.
3. Input SET NO in Index Analyzer command line as short cut to drill on set.
4. Impact Anayzer may fail processing against two different LPARs.

1. Major upgrade to EZ-Index Analyzer including Virtual Indexes for DB2 V8 and above. This new version shows a complete breakdown of all SQL predicate sets showing where they Match, No-Match and Partialy-Match existing user indexes.
2. New FLAG command to highlight SQL or Predicate sets for attention.
3. New COST information in Access Path detail displays. For COST data to be available the Plan Table set must include DSN_STATEMNT, DSN_DETCOST and DSN_STRUCT tables. When EXPLAINing SQL these tables should always be available.
4. New Option 9.11 to FTP a file to Technical Support.
5. Process Common Table Expressions in Impact Analyzer.
6. S0C4 in Tracer processing an SQL with more than 1000 Select List Columns.
7. EZ-Tracer C78 Abend.
8. DRILL to Statistics from Access Path display may fail with Data Not Found.
9. Allow RUNSTATS of the Warehouse Database to be supressed when performing Warehouse loads or Index Analysis.
10. -803 loading predicates in index analyzer.

1. Use hash key to locate entries for Warehouse frequency updates.
2. Ignore SET commands in bulk explains.
3. Show PREPARE costs in SQL Statistics drill for Dynamic SQL.
4. FIND command may fail in some large reports.
5. Some Cache SQL Consolidation counts may be double accounted across intervals.
6. Eliminate redundant spaces in SQL text before Edit and Explain to maximise SQL length that is explainable.
7. Add Unused Indexes to Tracer Index Utilization report.
8. New Plan Names for each EZ-DB2 Component.
9. Warehouse Load SQL from Catalog filters may erroneously say MULTIPLE.
10. DSN_DETCOST_TABLE COMP-1 not COMP-2.
11. Show presence of DSN_DETCOST_TABLE as well as DSN_STATEMNT_TABLE in Plan Name drills.
12. DB2 V7 BIND failure on EZDBEXP.
13. Correct Tracer explain error on SQL with Timestamp functions.
14. Index Analyzer analysis enhancements.
15. Warehouse Load SQL from Catalog produces spurious Tracer Password error.
16. Allow for missing Hidden Tables.
17. In report generation improve performance by reading SQLCP once only for all reports.
18. Where available show COMPCOST and COMPCARD in access path displays.

1. Preserve qualifier translation file when using EZ-Stats to copy statistics.
2. Restructure Warehouse Database for analysis by Plan and Collection.
3. Use DB2 Group as base for statistics collection where applicable.
4. Spurious Broken IFCID Chain messages may be produced for SET commands.
6. Invalid SQL text containing an apparent Table Name or Qualifier in excess of 128 bytes will cause a data corruption.
7. Increase space allocation for SUMTP and FINDQ.
8. EZ-Cache may not fully qualify SQL text with Consolidate Qualifiers = N.
9. APAR CX910064 introduced a error into EZ-Tracer where repeated jobs may not have non-cursor statistics properly aggregated.

1. Eliminate additional "marker" rows from V8 access paths in Impact Analysis.
2. XPRINT will generate REXX errors if the target dataset does not exist.
3. Impact Analyzer report 28 has additional sortable column Estimated CPU Saved.
4. Add QBLOCK_TYPE and TABNO to access path drill reports.
5. Activating Explain Stored Procedure may generate parameters for the wrong Subsystem.
8. Plan/Program reports may generate multiple entries for a Plan/Program combination.
9. Option 9.10 allows changes to the commands used to switch SQL drill displays. E.g. you may change AP for Access Path display to an alternate command of your choice. Hit ENTER repeatedly in Option 9.10 to move through the panel displays.
10. When migrating statistics update the statistics warehouse with the new data for the target subsystem.

1. Free old versions of packages before Re-BIND.
2. Remove 64K limit on SQL from Cache
3. Explain of some SQL may result in CPU or SU costs = -1 which results in an error in processing. Very high Timeron costs may also not be processed correctly.
4. Correct possible error in install panels processing DB2 Groups.

1. Add COMMITs to SQL PREPAREs and EXPLAINs to try to isolate DB2 Bug 00E70005 in V8 CM.
2. New HLQ available for Tracer Log files only. Tracer log files may be allocated with 1000s of CYLS so a unique HLQ allows alternative storage management procedures to be used. Use EZDB2 Option 9.2.2 to set a new HLQ.
3. XOPSQTY update partitioned tablespace corrected.
4. Warehouse Update SQL Frequencies new cost columns added. Enter "X" to delete all SQL from that point apart from DECLARE.
5. Change the way DB2 Groups are controlled. If you have DB2 Groups defined to EZ-DB2 then see the Notes.
6. Index Optimzer (XOP) may fail with duplicate key on INSERT.
7. Change EZ-Stats copy statistics across LPARs so the second job is sumbitted at the end of the first.

1. Add Impact Analyzer batch reports test for changed access paths to implement in user change management procedures.
2. If OPEN CURSOR is missed at the start of the trace, subsequent Fetches may be recorded with SQL text of OPEN cursor-name instead of the SELECT statement.
3. New option on the Tracer reports menu to view the filter and consolidation parameters that applied to each trace. The data will only be present for traces generated after applying this APAR. Enter the trace number at the top of the panel to view the parameters for that trace.
4. SHIFT and F9 will now perform SWAP NEXT.

1. Tracer drill on blank DBNAME filter fails to list all DBNAMEs. * allowed as well as % for prefix delimiter.
2. S0C1 in Trace SCOPE(GROUP) when a member of the group generates no trace data.
3. Update SQL Parser to allow for use of WITH Common Table Expression.
4. Add missing ALERTS to Trend Analysis Database.
5. Add CONSOLIDATION COUNT to Warehouse Database.
6. When drilling to get a list of available Plan Tables you may now use wild cards % and _. E.g A_B% to get all Plan Tables with A in 1st position, B in 3rd position and any suffix.
7. Clear down Plan Tables every 100 Explains to prevent data building up when performing bulk explains.
8. Allow for Workloads with zero predicates and/or global Temporary Tables in Index Analyzer and Optimizer.

1. Trace summary GETPAGE counts incorrect.
2. Trace summary SQL totals by Table or Index incorrect when Bind Access Paths loaded.
3. STOP Group Trace for all DEST OPn when OPn may vary across members of the group.
4. When renaming EZ-DB2 software datasets omit authorized load library.
5. New function in Warehouse Manage SQL Workload. Enter X against an SQL to exclude that and all subsequent SQL from the Workload.
6. Workload name of "CACHE" causes REXX failure.
7. S0C4 in Impact Analyzer batch reports.
8. Faster drill to object statistics for large databases.
9. Allow duplicate statement names in DBRM.
10. Trace filter wildcards aligned to DB2 V9 so use * as a prefix delimiter, e.g. ABC* for anything starting ABC, and _ for wildcard, e.g. A_C* for anything starting with A in position 1 and C in position 3.
11. XPRINT prints the original report not the current filtered or sorted report.
12. When drilling on DBNAMEs you may use the wildcard character _ as well as %.
13. EZ-Stats copy statistics may fail with a REXX error allocating datasets.
14. Batch report options will remember target dataset or SYSOUT. Use DRILL to access report options.
15. Imapct Analyzer Report 25 filters do not work.

1. Terminate group traces with scope group. Process all group member data.
2. CALL SP procedure statements may cause an abend processing workload data.
3. Impact Analyzer VNext filter processing incorrect where existing access paths are not available. Performance overhead reduced.
4. Impact Analyzer reports sort on CPU savings results in REXX abend.
5. Continuous Cache Traces fail to switch traces.

Notes : APAR CX910047 introduced capture of SQL issuing CALL to Stored Procedure. A bug in DB2 corrupted the program name and statement number in IFCID 233 which resulted in Tracer corrupting the data in XOPSQLFP. APAR CX910060 repairs this corruption. IBM APAR PK60771 corrects the bug in DB2.

1. Impact Analyzer compare current access paths with VNext performs an unnecessary explain when the two systems are on separate LPARs.
2. Prepare error in V7 Index Analysis.
3. Activating multiple subsystems in succession retains first subsytsem name.
4. IVP trace filters incorrect.

1. Change APAR panels to add database update options.
2. Correct errors in Tracer Filter panel defaults and allow wild cards in Correlation ID.
3. Reduce run times in XOP by only explaining SQL that might be affected by an index change and only using DESC when there is an ORDER or GROUP BY on the column DESC.
4. Stop XOP eliminating columns used in existing user indexes.
5. Allow input of Group Name in Subsystem Install which will enable the software for all the members of the group.
6. Support Trace at DB2 Group level. The DB2 Group Name must first be defined with DB2 Group = Y in the Activate Subsystem control panels. The panels will then allocate a member in ISPPROF for each member of the DB2 Group. In Tracer you may then opt to trace a single member of the Group or the entire Group.
7. Refinements to EZ-Index Analyzer Analysis.
8. Impact Analysis incorrect with filter on PLAN where members of the Plan are members of many other Plans.
9. New FILTER command on most reports. You may FILT on Program, DBRM, Package, Plan, Collid, Authid, Table and Index.E.g. FILT PROG ABC% to display only those report lines where program name start ABC. This only applies to drillable fields highlighted in yellow.

1. Fix occasional abend when processing 'SET CURRENT SQLID=?'.
2. Add checks to verify the correct log file is being used.

1. Process load of current cache only will not use secondary log files.
2. Repeating traces may terminate early.
3. New Option in Impact Analyzer VNext processing where existing access paths do not exist using DBRMLIB as filter.
4. Add new Trace Filters for CONNID, WRKSTN, APPNAME and USERID. Use new trace filters permitted in DB2 V9, for earlier DB2 the filter is performed manually. Allow eXclude.
5. Eliminate duplicate explains from preparation for Index Analysis.
6. DRILL on Impact Analyzer filter parameters reinstated.
7. Subsystem Install panels updated to allow entry of SCHENV parameter.
8. EZ-Stats may get Dynamic Allocation error generating JCL.
9. Index Analyzer reports may have errors where there are a large number of predicate sets on one table.

1. Use default table qualifier for PeopleSoft.
2. Reduce thread array size, clear down inactive data.
3. Increase default log file size for process of current cache data only.
4. Left scroll in SQL Statistics Drill may not work.
5. DB2 V9 plan tables generated incorrectly.

1. Add TOTAL-COST processing for DB2 V9.
2. Get around DB2 V9 bug giving spurious -910 errors.
3. Correct error handling comma as decimal point.
4. New Subsystem activation may generate the job for the wrong subsystem.
5. Trend Analysis database generation suppressed when not needed.
6. Possible GETMAIN failures or S0C1 abend processing large volumes of Cache.
7. Reduce region requirements processing Tracer log files by deleting redundant threads.
8. Tracer may not populate the Trend Analysis database on the first trace.
9. In Impact Analyzer alerts for SQL exceeding the average Timeron threshold may be lost.

1. NEW format SQL Statistics drill panel with DRILL to breakdown of Open/FETCH Costs.
2. Allow HLQ prefix changes through EZDB2I.
3. When loading data from Tracer into Warehouse you may now opt to replace the existing Warehouse Workload with the trace data being imported. This deletes the current data prior to the load.
4. Allow "Jobname" to be used more than once in the default jobcard and be correctly translated.
5. Allow restart of report generation on old traces.
6. XOPPATH may round Timerons to zero. Greater precision using Timerons for low cost SQL.
7. Reduce I/O drilling on consolidated SQL.
8. Edit and Explain may calculate incorrect percentage saved depending on Drill Level.
9. Abend in XOPPARS processing very large predicate set.
10. Very long Free Form SQL text may be truncated importing it into EZ-DB2.

This APAR upgrades EZDB2 R8.2 to R9.1

1. Make EZ-DB2 Version 9 compliant and bring EZDB2 R8.2 up to R9.1.
2. EZ-Tracer now reports on all calls to Stored Procedures using IFCID 233.
3. Alerts not generated by default.
4. Fixed abend on invalid input in Add Free-Form SQL Text.
5. Eliminate need for LPAR specific control of Workloads, Traces and Versions.
6. Correct error in EZ-Stats update catalog statistics using statistics from a different subsystem.

1. EZ-DB2 Warehouse Database changes - this APAR should ONLY be applied if the EZ-DB2 warehouse database has been installed in a DB2 V8 system in NEW Function Mode.

1. EZ-DB2 Warehouse Database changes - this APAR should ONLY be applied if the EZ-DB2 warehouse database has been installed in a DB2 V7 subsystem or a V8 system in Compatibility Mode.

1. EZ-DB2 Warehouse Database changes.

1. EZ-DB2 Warehouse Database changes.

1. Drill on Cache Filter Parameters inactive.
2. EZ-STATS CAF attach error.
3. Abend when processing certain invalid SQL.
4. Consolidation when JOIN predicate has 'IN'.
5. Minor bug fixes.

1. Fix consolidation for singleton SELECTs.
2. Fix interval switching when filtering on AUTHID.
3. Add CPU ID to password expiry messages.
4. Spurious Tracer Password expired messages.

1. Add new SET PROFILE command to Tracer SQL Consolidation options panel and to Alerts Controls panel.
2. Correct errors in qualifying SQL from programs with a mix of Static and Dynamic SQL.
3. Add bufferpools to option to create explain Plan Table.
4. Allow for long names in Tracer summary reports Table and Index drills.
5. Ignore Pruned access paths in Index Analyzer.
6. Load SQL from catalog parameters reset if database name changed.
7. Concurrent traces may experience dataset contention against ISPTLIB.
8. Link edit for z/OS.e will be generated for all subsequent APARs.

1. Correct failed link edit for z/OS.e

1. Add Table Filters to Load SQL from Catalog.
2. Consolidate SQL reports now show number of duplicated SQL where Program Name is listed as "Duplicat".
3. Correct errors in Alerts reports drill down.

1. Change EZ-DB2 install panel to allow entry of full DSN for SCEERUN and SCEELKED.
2. Allow SQL up to 256Meg but note SQL > 32K will not EXPLAIN under z/OS.
3. GETPAGES added to Trace and Interval Summary reports.
4. EZ-Tracer now provides a count of the number of times an SQL fails on Resource Limits.
5. New ALERT on SQL that fail on Resource Limits.
6. If the Trend Analysis Database is not installed the Consolidation and Trend Controls panel will indicate such.
7. Prepare error in XOPSTATU after ROLLBACK for missing Objects.
8. Drill errors in EZ-Stats.
9. Erroneous Tracer authorization check in Imapct Analyzer.
10. Index Analyzer WITH UR on catalog Access.
11. Impact Analyzer Alert reports sort on Alert ID and Description. Table Scan alerts suppressed if CARDF < Threshold.
12. Warehouse load SQL from Catalog had DD statement missing if Database Filter active.

1.S0C4 in XOPTRC2.
2. Some Statement Numbers and Cursor Names may be corrupted in long running jobs spanning log files. Typically only batch jobs affected.
3. Spurious "Job Not Submitted" messages may be output by Impact Analyzer creating new Workloads.
4. Impact Analyzer jobs split into two where two subsystems are different releases.
5. Possible database error in Index Analysis in DB2 V8 Full Function Mode.

1. Spurious messages for missing CONTOKEN processing new SQL in DBRMLIB in Impact Analyzer.
2. Impact Analyzer processing two subsystems on different LPARs requiring different Job Class will have corrupt JobCard.
3. Impact Analyzer Batch Reports fails S0C7.
4. Pass QUOTE and COMMA values though Impact Analyzer. Reduce Catalog access for Qualifier.
5. DRILL on SQL processes unnecessary data.
6. CACHE statistics not consolidated correctly.
7. Display PREPARE Statement Number in regular trace reports to be consistent with Cache reports.
8. Index Analyzer may not match Predicate Sets completely against existing User Indexes.

1. Make Hints in bulk may issue spurious No SQL Found message.
2. Prepare error in Index Analyzer when more than 100 SQL reference views.
3. Load Free Form SQL Text in Impact Analyzer sets SQL as Dynamic instead of Static and are ignored for Explains.
4. JCL errors in Export Warehouse Workloads.
5. New Alert for SQL that use UPPER/LOWER.
6. Include SDSNEXIT in JOBLIB for RUNSTATS steps.
7. Parser changes for CAST and arithmetic operators to avoid Explain failures.
8. Parser changes for - in cursor names.
9. Eliminate retrieval locks in Imapct Analayzer.

1. Allow Trace Existing SQL Only with SQL Consolidation OFF on a Workload populated with Free Form SQL Text to track all distinct occurrences of the SQL. You then see all the distinct combinations of parameter values to see which incur exceptional costs.
2. New SORT HASH command in Tracer report 22 to sort all the SQL by their post-normalization key. This groups all distinct occurrences of the same SQL together in descending order of Average CPU. Add the parameter TOTAL_CPU to sort by descending Total CPU.
3. NEW Tracer Restart Option 4 to allow restart of OLD traces to complete or regenerate the Summary, Trace and Workload Reports.
4. On-line HELP in EZDB2I brought up to date.
5. Use SYSOUT=(*,INTRDR) instead of SYSOUT=(A,INTRDR).
6. Terminate trace after DIAGnnnn complete.
7. Possible S0C4 in XOPTRC2.
8. Possible S0C1 in XOPANLZ.
9. Manage memory requirements in online reports processing. Display full SQL text on SQL drill if sufficient memory available.
10. Update to optional explain stored procedure to alter CCSID to 1047.
11. Correct parser errors.

1. NEW: CPU, Elapsed Time and GetPage Threshold filters added to EZ-Tracer enable you to trace only SQL that exceed the thresholds.
2. NEW: Option to load Free Form SQL Text into Tracer Workloads.
3. NEW: Option 9.1 facility to refresh the Job card from default.
4. XOPPATH may abend U4308 in Workloads with more than 50,000 SQL. Also U1006.
5. Index Analysis to terminate RC 16 when there are no valid SQL to process.
6. EZ-Tracer Index Utilization reports generated after manually explaining the SQL.
7. APAR Backout may submit job to wrong LPAR.

1. XOPTRC2 may abend S0C4 processing carried forward threads in the last log file.
2. XOPSTATD may fail if there is no GTT database defined.

1. Cursor names > 16 characters may not be processed properly in DB2 V8 leading to a U4038 abend in XOPPATH and SQL Nos of 52576.

1. CPU improvements to SQL consolidation.
2. Lower region size required for SQL consolidation.
3. XOPTRC2 abend U1006 on certain bad SQL text.
4. REFRESH text captured for MQTs. Note there is no IFCID to enable capture of statistics for the execute of REFRESH.
5. Tracer and Warehouse summary drills show full page reports.
6. New Tracer and Warehouse summary report on Indexes used in the EXPLAIN access paths.
7. FIND and RFIND may be used on Summary Reports.
8. DRILL for a list of Plan Tables now shows the DB2 Version valid for the Plan Table.
9. Correct errors in Thread counts where the thread overlaps log switches and Statement Type where a package contains a mixture of Static and Dynamic SQL.
10. Load ALL SQL from catalog may result in S0C4 in SQL consolidation.

1. Eliminate performance overhead in SQL consolidation.

1.Drill from Table Name in access path detail will display all indexes for Table Name regardless of Creator.
2. EZ-XOP check for SQLCODEs when creating an an Index with DEFINE NO.
3. DDF SQL with statement number zero may result in NO SQL TEXT.
4. XEQ sometimes generated on Job Cards instead of SYSAFF.
5. In EZ-Stats hitting ENTER reverts to page 1 of a multi-page display.
6. Updates of statistics in scrollable displays ignored without paging forward.

1. Fix problem with Tracing SQL from Stored Procedures called via DDF.

1. Processing costs reduced generating Alerts.
2. Change BIND parameters to use ENCODING(EBCDIC) to ensure local CCSID used by EZ-DB2 processes.
3. Index Optimizer Controls not saved on ENTER.
4. Drill on Authid GLBLTBL fails (Wrong Case).
5. Drill to SQL text shown NO SQL TEXT for DDF with statement number zero.

1. EZ-DB2 abends S0C7 processing a Hex string with more than 130 characters.
2. REXX error processing trace descriptions panel.
3. Dataset allocations errors may result where datasets are archived by HSM.

1. Edit and Explain of SQL Prepare Error.
2. Corruption of SQL text length in DB2 V7 for certain length values and CCSIDs.
3. Make sure stats for DSNDB06 get loaded.
4. Fix parameter and JCL error when loading from Catalog in Warehouse.

1. EXPLAINs of INSERTs may fail with authorization failures when using the explain stored procedure.
2. Tracer may not process DECLARE GLOBAL TABLE properly.
3. New OWNER parameter added for BIND of the Explain Stored Procedure.

1. Correct Impact Analyzer processing of DECLARE Global Temporary Table where DECLARE is not ordered before SQL referencing the GTT.

1. Impact Analyzer gets SQL unmatched in DB2 V7 plan members where QUERYNO = -1.
2. APAR panel doesn't process OWNER.
3. Export Workload REXX error.

1. Correct Impact Analyzer processing partially qualified columns in Select Lists in DBRMLIB members.
2. Add new JOB LOG drill on Impact Analyzer Summary report to view the process activity log.
3. Impact Analyzer may abend when provided an empty DBRMLIB.
4. A bug in DB2 may result in EZ-Tracer sharing an OPx destination with another trace and cause Abends.
5. Add support for Long Columns in EZ-Stats displays.

1. Add Qualifier Translation to SQL Drill Make Hint command.
2. Allow for IBM_SERVICE_DATA not defined WITH DEFAULT.
3. Impact Analyzer may fail using Package Version Filters.

1. EZ-Tracer deal with DB2 bug passing IFCID 239 in the trace.
2. EZ-Tracer check correct version of DB2.
3. EZ-Stats corrected for long fields in Tablespace name.
4. Workload Import/Export procedures enhanced.
5. New z/OS.e option in Install procedures.
6. Impact Analyzer may fail with Workloads created under EZDB2 V8.1.

1. Add new parameters to allow translation of COLLID between one version and another in Impact Analyzer.
2. Impact Analyzer updated to use QUERYNO when coded in SQL statements.
3. Impact Analyzer enhanced to allow entry of multiple Plan/DBRM and/or Collection/Package/ Version in filter parameters.
4. Trend Analysis fails in second and subsequent traces using 24x7 repeat traces.

1. Improve messaging in HINT creation.
2. Indicate DSN_STATEMENT_TABLE present in Plan Table Lists.
3. Qualifier translation file allocations may violate SMS storage management rules.
4. Possible S0C7 in SQL Parser.

1. DB2 trace data managed better when there are gaps with missing IFCIDs in the trace.
2. RID failures were missed.
3. Parallelism CPU may not be captured.
4. Possible cursor sort failure in Tracer report number 22 on z/OS.e systems.
5. Alerts on V8 reserved words in predicate list.
6. Batch SPUFI SQL rejected.

1. XOPPATH may Abend processing Global Temporary Tables.
2. Final SQL Consolidation run of XOPTRC2 may wait on log dataset.
3. Allow DECLAREs of GTT to be imported into workloads.
4. Add Filter by TABLE and CICS Transaction ID to EZ-Tracer.
5. Tracer Option to generate access paths DRILL function enabled.

1. Add options to Impact Analyzer to create HINTs for all, or a subset, of the SQL in a Workload using the selected Version of Access Paths within the Workload.
2. Add options in Impact Analyzer to use HINTs for a new EXPLAIN.
3. Impact Analyzer processing packages with SQL identical to SQL in other packages but using a different qualifier may consolidate them into one SQL.
4. Link edits changed to facilitate activation under z/OS-e.
5. New ALERTS added.
6. Update Impact Analyzer to deal with SYNONYMs when processing a DBRMLIB.
7. EZ-Stats database selection panels enhanced to simplify the process. Statistics update jobs may now be generated to run repeatedly.
8. EZ-Cache is now available for analyzing Dynamic SQL in cache. Free to existing users of EZ-Tracer it is a separate option for new users.

1. Add Qualifer Translation to Impact Analyzer to allow generation of Access Paths against any environment.
2. Match Access Paths in Plan Tables correctly where multiple versions of a package or member of plan exist bound to different qualifiers.
3. Add MAKE HINT command (MH) from Access Path displays. Use this command to make a HINT from your favorite Access Path.
4. Suppress Timeron Alerts when comparing against BIND access paths for which Timerons do not exist.
5. Add DRILL to Tracer Filter parameter options.
6. Invalid SQL text parsed correctly. Correct (CAST ? AS FLOAT).
7. Clearer messaging in Impact Analyzer logs.
8. Job cards may be tailored to include SYSAFF if required.

1. 20-40% reduction in CPU processing Trace data.
2. Split EZ-Tracer controls for Full and Cache Traces so each has their own control panel. Cache Filter parameters panel tailored to Cache requirements. New DRILL to lower level panels.
3. New controls in Trace Filter options to run traces collecting no Fetches and to run Sample traces where the trace is not permanently active.
4. Warehouse SQL explains enhanced to Declare Global Temporary Tables first.
5. Alerts Summary report and reports menu enhanced. New reports created for DBRMs, Collections and Packages.
6. Consolidate In-List for UPDATE SQL corrected.
7. Add new Alert 110 for SQL with Stage 2 Row Statistics.
8. The CPU cost of producing Tracer Reports has been cut by 50%.
9. New RESTART controls for Tracer to allow the appropriate JCL to be regenerated depending on which part of the process failed.
10. Trace Filters for PLAN, AUTHID and PROGRAM now allow Wildcard * to specify any character as well as % to define a prefix.
11. EZ-Tracer clears the current trace buffer at the end of each interval to ensure SQL appear in the interval in which they were executed in a quiet DB2 System.
12. A Trace that captures zero SQL will now run to completion to produce a nil return.
13. A new option has been added to CACHE Traces. Include Current Stats at Start = Y/N/O.
14. A new consolidation control for Table qualifiers has been added to always fully qualify Table names before consolidating.
15. Possible program failure in Impact Analyzer processing a DBRMLIB.
16. CACHE Statistics not processed correctly.

1. Increase default max report lines in Tracer report generation.
2. Increase default trace buffer size.
3. Correct possible invalid Trace entries in XOPSUMTP generated under an earlier release.
4. Add IVP to non-Warehouse install.
5. Allow temporary report files HLQ to be just USERID with no additional qualifier.

This APAR brings EZ-DB2 V8.1 up to EZ-DB2 V8.2