IBM z/OS RMF Spreadsheet Reporter change history

Servers >

Spreadsheet Reporter change history

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

Version 5.1.5

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.

Version 5.1.4

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)

Version 5.1.3

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

Version 5.1.2

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.

Version 5.1.1

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)

Version 4.8.3

Spreadsheet Macros

I/O Subsystem Report Macro (Rmfr9mdv.xls):
- Added Queue Intensity to MulDevD/C, LCUBySys, DevBySys and Summary Sheet. (PC/T0197MAI)
Workload Activity Trend Report (Goal Mode) (Rmfr9wlm.xls):
- Macro issues message 'SrvClass: xxxxPeriod: 1 not found' when no Service Class Period Response Time Distribution data is available. (PC/T0192MAI)
System Summary Macro (Rmfn9sum.xls):
- Processing summary reports with partial data in the first interval raises message 'Cannot process data....' (PC/T0191MAI)

Spreadsheet Reporter

Incorrect number of logical CP converted (for CPs >9). (PC/T0202MAI)
Incorrect conversion of large DASD RESP values of RMF Summary Activity Report. (PR050207RWH)
Incorrect sysplex name generated of overview record. (PR050218MAI)
Transaction END/SEC value of WLMGL Activity Report truncated. (PC/T0205MAI)
Operating system with Chineese language setting:
- Using the Spreadsheet Icon in the Spreadsheet Reporter Launchpad causes 'Unable to Execute xxxx\macro. Please contact IBM support center. Error number 60' error message. (PMR62357,000,738)

Version 4.8.2

Spreadsheet Macros

Combined Workload-CPU-Paging Report (Compatibility Mode) (Rmfr9wcp):
- Using with Excel 97 causes the 'Compile Error: Sub or Function not defined.' error message. (PMR 24097,180,000, PC/T0193MAI)
Device Overview Report Macro (RMFX9DEV.XLS):
- RepOneDev chart shows incorrect x-axis labels. (PC/T0194MAI)
Summary Report Macro (Rmfn9sum.xls):
- DASD Response time/DASD Rate labels are mixed on the SumChart chart (PC/T0199MAI)

Spreadsheet Reporter

Adaption to changed report layout: Channel Path Activity Report, I/O Queueing Activity Report, Magnetic Tape Device Activity Report (Report changes with OW56656)
Converter cannot handle report listings with incorrect line length (PC/T0200MAI)

Version 4.8.1

Spreadsheet Macros

Using Reports Macros with Excel 97 causes 'The Report Working Set may not contain...' error message (PC/T0178MAI)
Workload Overview Report Macro (RMFY9WKL.XLS):
- The x-axis labels for the WklChart are overlaid when multiple intervals are displayed using Excel 2002 (PC/T0177MAI)
LPAR Trend Report Macro (RMFR9LP.XLS):
- Metric-selection for RepTrd chart works incorrectly (PC/T0181MAI)
- Metric-selection/LPAR selection for RepWeight chart works incorrectly (PC/T0184MAI)
- Incorrect LPAR Management Times are calculated (PC/T0185MAI)
- Processing a partition data report that contains asterisks in the Physical LPAR management column causes 'No reports available for processing...' error message (PC/T0186MAI)
Workload Activity (Goal Mode) Report Macro (RMFR9WLM.XLS):
- Processing Report Working Sets extracted with extract option 'Workload Activity (Goal Mode)' but without
  extract option 'Workload Activity' causes 'No reports available for processing' error message (PC/T0182MAI)
LPAR Overview Report Macro (RMFX9CPC.XLS):
- Processing overview data causes message 'Can not process data...' (PC/T0175MAI)
- Processing overview data when no actual MSU data for a partition are available causes 'Can not process data...' (PC/T0176MAI)
- LPAR selection dialog of LPARs chart may show incorrect LPARs that are not available (PC/T0179MAI)
- Processing Overview data with day-gaps causes 'The Report Working Set may not contain...' error message (PC/T0189MAI)
Tape Mount Report Macro (Rmfr9tap.xls):
- Processing Magnetic Tape Device Activity Report with devices within state 'Now Offline' causes 'The Report Working Set may not contain...' error message (PC/T0188MAI)
Create Overview Control Statements Macro (RMFX9MAK.XLS):
- No Overview Statements for Report Class/Report Class Period generated (PC/T0180MAI)

Spreadsheet Reporter

Incorrect conversion of Cache Subsystem Reports when the first Cache Subsystem in the Cache Report is terminated (PR050173MAI)
Last Bucket of Response Time Section of Workload Activity Goal Mode Report may missing (PC/T0183MAI)

Version 4.8.0