PH35013: FAIL WITH ERROR LOADING SEVERAL SMF_79* VIRTUAL TABLES WITH RMF DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running load job of the SMFV_07914_SMF79HDR, field SMF79GIE
  cause a failure with invalid data:
  HLOU5807W - Column SMF79GIE has invalid data in Record=1 PART=0
  IGNORE BELOW DURING APAR CREATION:
  Getting the following errors on field SMF79GIE when running Load
  job.
  HLOU5807W 054 12:27:24.66 Column SMF79GIE has invalid data in
  Record=1 PART=0
  HLOU5807W 054 12:27:24.66 Column SMF79GIE has invalid data in
  Record=1 PART=0
  HLOU5807W 054 12:27:24.66 Column SMF79GIE has invalid data in
  Record=1 PART=0
  HLOU5807W 054 12:27:24.66 Column SMF79GIE has invalid data in
  Record=1 PART=0
  SMF79GIE is defined in our SMF Map as Timestamp but it looks
  like we are not converting it correctly.  Here is what is
  being returned when running the following query on RS28/HLV2:
  SELECT SMF79GIE
  FROM SMFV_07914_SMF79HDR__CSD_SUPPORT_JL_T4921635_JAN27_RMFOUT
  SMF79GIE
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
   0002-11-30 00:00:00.0
  SMF79GIE define:
  |80|50|SMF79GIE|8|binary|Projected gathering interval end (STCK
  format) GMT time.|
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Fail with error loading several         *
  *                      SMF_79* virtual tables with RMF data    *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  Fail with error loading several SMF_79* virtual tables with
  RMF data
  

Problem conclusion

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:

Modules/Macros

• HLV$4FEE HLV$4FEM HLV$741E HLV$741M HLV$IA40 HLV$IA42 HLV$IAL1
  HLV$IAO1 HLV$KE32 HLV$KE33 HLV$KFE1 HLV$MEP0 HLV$N830 HLV$N850
  HLV$N860 HLV$N870 HLV$N880 HLVCADRD HLVCTGRD HLVCTSRD HLVCTVRD
  HLVCTZRD HLVOBRTV HLVSQ29D HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD
  HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N
  HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD
  HLVSQLDN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI74789

     UP21/04/08 P F104

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.