APAR status
Closed as program error.
Error description
The Export Performance Data zip file contains csv files with a Time column. That column has changed since the 2Q21 Storage Insights update to display the data in GMT. Additionally, if you try to sort by the Time column, the only options are A to Z or Z to A. The column no longer can be sorted oldest to newest or newest to oldest, which would be more appropriate for a time value. Example old timestamp: 7/1/2021 5:01:00 AM Example new timestamp: Fri Jul 02 12:57:13 GMT 2021
Local fix
None, but can use the following formula in a separate Excel column as a workaround to be able to sort the Time from oldest to newest or newest to oldest. =DATEVALUE(TEXT(MID(C22,FIND(" ",C22)+1,FIND(" GMT",C22)-4),"m/d/yy")) + TIMEVALUE(TEXT(MID(C22,FIND(" ",C22)+1,FIND(" GMT",C22)-4)," h:mm"))
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Storage Insights users exporting performance data * **************************************************************** * PROBLEM DESCRIPTION: * * The Export Performance Data zip file contains csv files with * * a * * Time column. That column has changed since the 2Q21 Storage * * Insights update to display the data in GMT. Additionally, * * if * * you try to sort by the Time column, the only options are A * * to Z * * or Z to A. The column no longer can be sorted oldest to * * newest * * or newest to oldest, which would be more appropriate for a * * time * * value. * * * * Example old timestamp: * * 7/1/2021 5:01:00 AM * * * * Example new timestamp: * * Fri Jul 02 12:57:13 GMT 2021 * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Storage Insights 3Q21 [ 54X-IBM-SI ] ( release target 3Q 2021 / September ) The target dates for future releases do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT37827
Reported component name
STORAGE INSIGHT
Reported component ID
5608TPCSI
Reported release
54X
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-29
Closed date
2021-08-04
Last modified date
2021-08-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
STORAGE INSIGHT
Fixed component ID
5608TPCSI
Applicable component levels
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSQRB8","label":"IBM Storage Insights"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"54X"}]
Document Information
Modified date:
08 February 2022