PI19533: CSV TIME FIELDS ARE NOT REPRESENTED CONSISTENTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CSV (Comma separated values) output files, when used as input
  into BigData analytics engines, require consistency of data
  representation, especially for time fields (elapsed and CPU).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Transaction Analysis Workbench           *
  *                 Version 1 Release 2 users                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: CSV time fields not represented         *
  *                      consistently                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  CSV (Comma separated values) output files, when used as input
  into BigData IT analytics, require consistent data
  representation, especially for time fields (elapsed and CPU).
  

Problem conclusion

• CSV time fields (elapsed and CPU) now reported as a decimal
  number in seconds with fractions of seconds after the decimal
  point (S.THMIJU)
  The following additional changes have also been made:
  1.New JSON facility is an alterative to using CSV.
  Metadata and Schema are optionally generated to assisT in the
  loading of CSV or JSON data into DB2 and interpretting it.
  2.The following DB2 IFCIDs are now fully supported:
  001, 002, 106, 173, 193, 194, 195,
  230, 250, 261, 262, 337, 365, 369
  These IFCIDs are now eligible for reporting, browsing,
  CSV and JSON.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI21185

Modules/Macros

•    FUWBATCH FUWBRAPI FUWBRCOP FUWBRFMT FUWBRMIO
  FUWBRPRE FUWBRSCH FUWBRXCM FUWCDOLI FUWCICSI FUWCSMVS FUWCSV
  FUWDB02A FUWDB02B FUWD2NTH FUWEXTRA FUWLCAT  FUWLFMER FUWPRDRV
  FUWPROC  FUWPROL2 FUWRXDSP FUWSTCKN FUW0001J FUW0002J FUW0106J
  FUW0173J FUW0193J FUW0194J FUW0195J FUW0230J FUW0250J FUW0261J
  FUW0262J FUW0337J FUW0365J FUW0369J FUW6E13Z FUW65ZA  FUW74Z
  HAHO120J
  

Fix information

• Fixed component name

  IBM TRANS ANALY

• Fixed component ID

  5697P3700

Applicable component levels

• R120 PSY UI21185

     UP14/09/15 P F409

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.