 |
Version 5.3.3 |
Spreadsheet Reporter
- XML Report Support update
- Workload Activity Report: Large CPU Service Times may be incorrectly converted (PR110118MAI)
 |
Version 5.3.2 |
Spreadsheet Reporter
 |
Version 5.3.1 |
Spreadsheet Macros
- XCF Trend Report: The System name may appear mutliple times in the system list (PR100110MAI).
- Channel Overview Report: When adding data to the macro, the workload busy percent was incorrectly calculated (PR100115MAI).
- LParsTrd sheet may report incorrect Physical Total Utilization for the Physical Partition (PR100146MAI).
- RMF System Overview Report: Adding data may cause error message "Run-time error 9" (PR100148MAI).
Spreadsheet Reporter
- WLGML Report may be incorrectly converted (PR100088MAI).
- Range names with numeric sign "#" cannot be handled (PR100116MAI).
- Numbers of processors in the Partition Data Report may be incorrectly converted (PR100135MAI).
- Using the CreateRptWset.bat file may cause error message "Internal index files are not accessible." (PR100136MAI).
- The Paging Activity Report may be incorrectly converted (PR100142MAI).
- Invalid XLS file generated based on overview record (PR100143MAI).
- Corrupt RMFOV.XLS file cause SR hangup without any error messages (PR100144MAI).
- The Spreadsheet Reporter cannot delete or rename working sets (PR100149MAI).
- Processing data may cause error message "The Report Working Set may not contain the required..." (PR100114MAI).
- Workload Activity Report: QMPL delays may be incorrectly converted (PR110076MAI).
- To migrate your existing working sets to Microsoft Excel 2007 compatible file format, use the MigrateWSetsToXLS.bat batch file in the Spreadsheet Reporter program files directory. Be aware, that depending on the numbers and size of your existing working set, the conversion may take some minutes.
- This version supports Microsoft Excel 2002, 2003 and 2007.
 |
Version 5.3.0 |
Spreadsheet Macros
- LPAR Trend Report Macro: Processing data may cause error message "The Report Working Set may not contain the required reports or the reports may be corrupted..." (PR100114MAI).
- XCF Trend Report: The System name may appear mutliple times in the system list (PR100110MAI).
- Coupling Facility Trend Report Macro:
Processing data may cause error message "The Report Working Set may not contain the required reports or the reports may be corrupted..." (PR100116MAI).
RepIntCF Sheet shows incorrect scaled CF CPU seconds (PR100131MAI).
- Channel Overview Report: When adding data to the macro, the workload busy percent is incorrect calculated (PR100115MAI).
Spreadsheet Reporter
- This version supports Microsoft Excel 2007.
 |
Version 5.2.7 |
Spreadsheet Macros
- LPAR Trend Report Macro: When adding additional data to existing data using the "Add additional data..." button, the LparsTrd chart only shows the new data (PR100047MAI).
- Workload Overview/ LPAR Overview Report Spreadsheet: Adding data to existing data may cause Visual Basic Runtime Error 9, Subscript out of range (PR100089MAI).
- Coupling Facility Activity Report: the metric average request per second may be incorrect converted (PR1000092MAI).
Spreadsheet Reporter
- Spreadsheet Reporter issues error message "No converted reports available" during working set creation, when running with Turkish or other specific regional language settings (PR1000096MAI)
 |
Version 5.2.5 |
Spreadsheet Macros
- Enhanced error handling if access to working set files is restricted.
- Coupling Facility Trend Report Macro: Data with dynamic number of partition cause incorrect structure data on RepTrdStr sheet (PR100146MAI).
- LPAR Trend Report Macro: WLM capping is incorrect reported on the LparsTrd sheet (PR100171MAI)
Spreadsheet Reporter
- WLGML Interval Report may be assigned with the System ID instead of the Sysplex ID (PR100145MAI)
- Converting WLMGL Report with no data on the first page cause error message ERB9008A (PC/T0315MAI)
- Report Intervals may appear in none-chronlogical sequence, when Working Sets reside on a filesystem server (PR100152MAI)
 |
Version 5.2.4 |
Spreadsheet Macros
- New XCF Trend Report Spreadsheet Macro (Rmfr9xcf.xls):
- This spreadsheet can process XCF Activity RMF Postprocessor reports from multiple systems to create reports on multi-system scope level.
- Workload Overview Report (Rmfy9wkl.xls):
- "Other" bucket may become negative (PC/T0313MAI)
Spreadsheet Reporter
- Using Secure FTP fails with error message "Certificate is invalid" (PC/T0314MAI)
 |
Version 5.2.3 |
Spreadsheet Macros
- LPAR Trend Report Macro (Rmfr9lp.xls):
- Processing RMF V1R2 partition data report with zIIP processors causes the error message "The Report Working Set may not contain the required reports or the reports may be corrupted...." (PC/T0291MAI)
- Data may be skipped when appending data to existing data in the macro (PC/T0293MAI)
- Coupling Facility Trend Report Macro (Rmfr9cf.xls):
- Selecting metric "Total link SCH busy time" on the RepCFSys sheet may cause the error message "Runtime error 9, subscript out of range" (PC/T0295MAI)
- On the RepIntStr data sheet, the option to display only specific structures does not work (PC/T0304MAI)
- Changing the chart metric when reporting data from a Coupling Facility with unallocated structures causes the Visual Basic Error "Run-time error 1004: Select method of Series class failed" (PC/T0305MAI)
- System Overview Report Spreadsheet (Rmfy9ovw.xls):
- Incorrect Weekday on Summary sheet is displayed when using German Regional Settings (PC/T0302MAI)
- Channel Overview Report spreadsheet:
- Processing data with more than 35 channels causes the error message "The Working Set may not contain the required data or the data may be corrupted." (PC/T0306MAI)
- Workload Activity and LPAR Trend Report Spreadsheet offer new zAAP and zIIP support
Spreadsheet Reporter
- Long running Postprocessor job may fail with FTP error message: "I/O error! java.net.SocketTimeoutException: Read timed out" (PC/T0292MAI)
- WLMGL Report: Service classes with subsystem data may be skipped during conversion (PC/T0294MAI)
- Using working set name with an appended blank causes the error message: "An error occurred during extraction of Report Listing ..." (PC/T0297MAI)
- The Cache Subsystem Device Overview report section may be incompletely converted (PC/T0298MAI)
- WLMGL Report: Response time distribution data for the Report class period may be skipped (PC/T0299MAI)
- Service Class goal may be incorrectly converted (PC/T0303MAI)
- Converting the overview record without the data section causes the error message "An error occurred during extraction of Overview Record..." (PC/T0310MAI)
- Adaption to Daylight Saving Time changes in 2007
In March 2007, the effective dates of Daylight Savings Time (DST) in the U.S. and Canada will change.
Dates and times could be affected by this change. If not addressed, time and date calculations could be incorrect.
The RMF Spreadsheet Reporter is affected because of its dependency on the Java JRE.
The JRE of the RMF Spreadsheet Reporter is replaced with a DST-compatible JRE.
 |
Version 5.2.2 |
Spreadsheet Reporter
- Converting Paging Activity Report with Auxiliary Storage Shortage causes error message ERB9080A, 'PWS: *ERROR* - Writing .WK1 subreport trailer 6 failed, RC=1' (PC/T0286MAI)
- Workload Activity Trend Report: subsystem workloads may be converted incorrectly (PR090128MAI)
Spreadsheet Macros
- Workload Activity Trend Report Macro (Rmr9wlm.xls):
- Workload Activity Trend Report Macro shows no Response Time Distribution on RepRsp Sheet for service class periods (PR090122MAI)
- Coupling Facility Trend Report Macro (Rmfr9cf.xls):
- On RepIntStr data sheet, the option to display only specific structures does not work (Display in Chart pulldown box) (PC/T02287MAI)
- Incorrect structure summaries displayed on RepIntCF sheet when the report contains a CF without allocated structures. (PC/T0289MAI)
- Selecting another metric on RepTrdStr sheet may cause error message 'Run time error 1004' (PC/T0290MAI)
 |
Version 5.2.1 |
Spreadsheet Macros
- Summary Report Macro (Rmfr9sum.xls):
- Error message 'The Working Set may not contain the required reports o...' when processing summary report (TOTAL mode) with the Summary Report Spreadsheet (PC/T0285MAI)
 |
Version 5.2.0 |
Spreadsheet Reporter
- Conversion of empty overview record failed with ERB9009A error message (PC/T0212)
- First line of second page of I/O Queue Activity Report was skipped during report conversion (PC/T0301MAI)
- Spreadsheet Reporter didn't start when installation directory contain special NLS characters (PC/T0271MAI)
- Workload classes dropped in Workload Activity Report when WGPER report ist requested (PC/T0270MAI)
- Coupling Facility report with a Coupling facility, where no structure/storage data are reportable, is incorrect converted (PC/T0229MAI)
- Coupling Facility Report with unallocates structures is incorrect converted (PC/T0284MAI, PMR 73227,499,000)
- Working Set Properties may show incorrect Report Period (PR090031MAI)
- Conversion of Partition Data Report fails with error message ERB9083A (PC/T0279MAI)
- Job submission failed with CA TCPAccess (PC/T0280MAI)
- Secure FTP support
- FTP Passive mode
Spreadsheet Macros
- Workload Overview Report Macro (Rmfy9wkl.xls):
- The MonthChart,WeekChart and AllDaysChart doesn't show data when 23:00–23:59 o'clock is defined as the reporting timeframe (PC/T0282MAI)
- Enhanced functionality to process Sysplex Overview Records
- Device Overview Report Macro (Rmfx9dev.xls):
- Processing of data with offline devices overview records cause error message 'The Report Working Set may not contain...' error message (PC/T0213MAI)
- Workload Activity Report Macro (Rmfr9wlm.xls):
- Create Overview Control Statement Set functionality, to create overview control statements needed for the Workload overview report macro, based on the workloads reported in the workload activity report.
- LPAR Trend Report Macro (Rmfr9lp.xls):
- Incorrect data displayed when creating a trend report where the appended report contain no partitions of the initial report (PR090034RWH)
- Create Overview Control Statement Set functionality, to create overview control statements needed for the LPAR overview report macro, based on the Partitions reported in the Partition Data report
- RepTrd sheet: Add counters: Actual MSUs, defined MSUs, WLM Capping
- Incorrect Guaranteed Weight % of CEC is reported with dedicated CPs (PC/T0283MAI)
- Coupling Facility Trend Report (Rmfr9cf.xls):
- RepIntCF sheet: Add metrics of unweighted/weighted requests in the following categories for each interval: List,IXC*, Serialized list, Lock , Cache, CF CPU seconds
- RepCFSys sheet: added following metrics: Total link subchannel Utilization, Average link subchannel Utilization
- All Overview Report Macros:
- Overview macros cannot handle year change correctly (PC/T0260MAI)
- All Macros:
- Automatic preselection on the Working Set selection dialogs
- Processing Working Sets causes error messages 'Cannot process data...' when system regional settings are switched to Turkish (may also apply to other regions) PC/T0273MAI
- All Trend Report Macros:
- Add time filter function to the Working Set selection dialogs
Spreadsheet Macros
- LPAR Trend Report Macro (Rmfr9lp.xls):
- Processing Partition data report with more than 42 LPARs cause error message 'The Report Working Set may not contain the required reports...' (PC/T0267MAI)
- Enhancement:
- Added metrics: Actual MSUs, Defined MSUs and % WLM Capping to RepTrd chart
- Enhanced Info sheet information
- System Overview Report Macro (Rmfy9ovw.xls):
- Enhancement: Display enhanced job dispatch queue on OneCpuCont chart
- Create Overview Control Statements Macro (Rmfx9mak.xls):
- Support for the System Overview Report Macro enhancement
Spreadsheet Reporter
- No FTP Log is written when the working set creation process is aborted using the 'Cancel' button (PC/T0261MAI)
- The response time percentage goal is incorrect converted in the Workload Activity Report (PC/T0266MAI)
- Overview record conversion fails with RC ERB9004A (PC/T0262MAI)
- Conversion of Coupling Facility Report fails with RC ERB9008A (PC/T0264MAI)
- System index for Workload Activity Report may contain the system and not the sysplex ID (PC/T0264MAI)
- System running with an installation default of HEAP(KEEP) option, could increase the storage usage and the execution time of the RMF Postprocessor.
Therefore the PARM='HEAP( FREE)' parameter was added to the JCL.
- Add retry handling for java.net.SocketTimeoutException: Read timed out.
Spreadsheet Reporter
- Incorrect conversion of subsystem service class / periods in the Workload Activity Report (PC/T0256MAI)
- Incorrect conversion of Workload Activity Report cause 'Cannot process data...' macro error message (PC/T0263MAI)
Spreadsheet Macros
- Workload Overview Macro (Rmfy9wkl.xls):
- Function "Keep defined names" on Main sheet doesn't work (PC/T0255MAI)
Spreadsheet Macros
- Coupling Facility Report Trend Macro (Rmfr9cf.xls): For coupling facility duplexed structures, only structure data for the first CF is displayed on the RepIntAct Sheet (PC/T0248MAI)
- Create Overview Control Statements Macro (Rmfx9mak.xls):
- If specifed, EXVEL and PI OVW statements for Service/Report Classes are also generated, which cannot be processed by the RMF Postprocessor (causes error message ERB487I) (PC/T0249MAI)
- Macro loops when 27 workloads are specified for workload overview control statement generation (PC/T0253MAI)
- If a service class is specified as a workload, the macro generates an overview control statement for the first period of a service class. (PC/T0254MAI)
- DASD Activity Report Macro (Rmfr9das.xls): I/O numbers for LCU statistics are rounded to integers (PC/T0252MAI)
Spreadsheet Reporter
- New list items cannot be defined when list exceeds window size
- Allow file dialog for selection of local resources
- Not possible to define a remote resource with a different High Level Qualifier from the one that is specified in the system settings (PC/T0250MAI)
- Add external FTP command execution
- Cleanup message files from job execution
- Add Option DEFINE to Menu Bar
- Add *.txt as filetype for listings
Spreadsheet Macros
- Coupling Facility Report Trend Macro (Rmfr9cf.xls):
- Incorrect data for coupling facility structures displayed on RepStrSheet (PC/T0234MAI)
- When processing multiple intervals and selecting a structure on RepTrdStr that is only within partial intervals available, causes Visual Basic error message 'Runtime Error 1004, Application-defined or Object-defined error' (PC/T0235MAI)
- % Delayed Requests metric on RepsubChn1 chart and Total delayed request metric on RebCFSys chart are always reported as zero. Dropped Link Buffer Utilization metric. (PC/T0239MAI)
- System Overview Report Macro (Rmfr9ovw.xls): Processing reports with partial data in the first interval raises message 'Cannot process data...' (PC/T0236MAI)
- Filter Dasd or Cache Reports (DASDConv.xls): Processing file with more than 50.000 devices causes overflow error message (PC/T0238MAI)
Spreadsheet Reporter
- Using remote GDG SMF Dataset with index of zero and a zero in the name causes error message IEF366I (PC/T0242MAI)
- After starting Application RMF Spreadsheet Reporter, the workstation freezes (PC/T0243MAI)
- Unchecked save password option is not honored if a password was entered. The password is still saved and used for logon (PC/T0246MAI)
- Report Classes of the WLGML report may be skipped and missing in the converted report (PC/T0247MAI)
- Incorrect conversion of CPU fields of Workload activity Goal mode report may cause 'Cannot read record (NAME: CRITICAL_1)' message when processing report with Workload Activity Trend Spreadsheet Macro (PC/T0241MAI)
- Report generation fails if HFS user directory is specified as STARTDIRECTORY in the FTP.DATA file of the server.
Spreadsheet Macros
- Summary Report (Rmfn9sum.xls):
- Changed legend name / legend sort order for JobChart (PC/T0230MAI)
- Coupling Facility Trend Report (Rmfr9cf.xls):
- Selecting a structure on the RepTrdStr sheet which is unallocated causes Visual Basic error message 'Runtime Error 1004, Application-defined or Object-defined error' (PC/T0232MAI)
Spreadsheet Reporter
- CPU Activity Report with page break is incorrectly converted (PC/T0210MAI)
- Spreadsheet Reporter cannot convert files where the filename contains 2 or more consecutive blanks (PCT/0233MAI)
- Spreadsheet Reporter terminates conversion of WLMGL report with RMF2SCW.EXE Windows Exception (PC/T0231MAI)
 |
Version 5.1.0 |
Spreadsheet Macros
- Workload Activity Trend Report (Rmfr9wlm.xls):
- Incorrect storage delay displayed on RepExcD sheet (PC/T0207MAI)
- PI threshold definition is not honored on RepTrd sheet (PC/T0208MAI)
- DASD Activity Report Macro (Rmfr9das.xls):
- Processing DASD activity Reports with zero device activity causes 'Cannot process data....' error message (PC/T0211MAI)
Spreadsheet Reporter
- The 'Alloc Size' of a CF Structure of the Coupling Facility Activity Report is incorrect converted for values above 1G (PC/T0209MAI)
- Large transaction numbers (with K,M,G appendix) are truncated within the transaction section of the WLMGL report (PC/T0227MAI)
| |
|