IZ49406: SITUATIONS WITH UTF-8 DATA FAIL ON Z/OS AND AS/400

APAR status

• Closed as program error.

Error description

• *************
  Environment:
  *************
  ITM 6.1
  ITM 6.2
  
  *********************
  Problem Description:
  *********************
  Situations with utf-8 attributes and complex functions such as
  MIN(), MAX(), AVG(), SUM(), COUNT(), MKTIME JOIN to LOCALTIME
  table fail on z/OS and AS/400.
  
  *******************************
  Detailed Recreation Procedure:
  *******************************
  1) create a situation like this:
  ----------------------------------------------------------------
  <TABLE>
  <ROW>
  <SITNAME>
  Balterio_Datawarehouse
  </SITNAME>
  <TEXT>
  </TEXT>
  <AFFINITIES>
  20000000000000000000000000000000#m00004Q0a3
  </AFFINITIES>
  <PDT>
  <![CDATA[*IF *VALUE i5OS_Integrated_File_System_Object.Path *EQ
  '/QIBM/UserData/IBM/ITM/HIST' *AND *VALUE
  i5OS_Integrated_File_System_Object.Name *EQ 'khdexp.cfg' *AND
  *TIME i5OS_Integrated_File_System_Object.Last_Change *EQ
  'Universal_Time.Timestamp + 10M']]>
  </PDT>
  <REEV_DAYS>
  0
  </REEV_DAYS>
  <REEV_TIME>
  000500
  </REEV_TIME>
  <AUTOSTART>
  *YES
  </AUTOSTART>
  <ADVISE>
  <![CDATA[*NONE]]>
  </ADVISE>
  <CMD>
  <![CDATA[*NONE]]>
  </CMD>
  <AUTOSOPT>
  NNN
  </AUTOSOPT>
  <DISTRIBUTION>
  S655E4DE:KA4
  </DISTRIBUTION>
  <ALERTLIST>
  </ALERTLIST>
  <HUB>
  </HUB>
  <QIBSCOPE>
  E
  </QIBSCOPE>
  <SENDMSGQ>
  *NONE
  </SENDMSGQ>
  <DESTNODE>
  </DESTNODE>
  <LOCFLAG>
  </LOCFLAG>
  <LSTCCSID>
  fr_BE
  </LSTCCSID>
  <LSTDATE>
  1081114134428000
  </LSTDATE>
  <LSTRELEASE>
  V100
  </LSTRELEASE>
  <LSTUSRPRF>
  BEMMA
  </LSTUSRPRF>
  <NOTIFYARGS>
  </NOTIFYARGS>
  <NOTIFYOPTS>
  </NOTIFYOPTS>
  <OBJECTLOCK>
  </OBJECTLOCK>
  <PRNAMES>
  </PRNAMES>
  <REFLEXOK>
  </REFLEXOK>
  <SITINFO>
  <![CDATA[TFWD=Y;TDST=0;~]]>
  </SITINFO>
  <SOURCE>
  </SOURCE>
  </ROW>
  </TABLE>
  
  ----------------------------------------------------------------
  .
  2) Situation never fires
  3) remove the timestamp consition ancreate a sit that monitors
  for file name
  4) Situation works
  
  **************************
  Related Files and Output:
  **************************
  On ecurep
  
  **********
  Approver:
  **********
  LK
  

Local fix

• Work-around:
  Change situation definition and add a condition on any
  non-utf-8 column.  In some cases, depending on how agent
  collector processes utf-8 columns, this work-around might not
  resolve the issue.
  

Problem summary

• Situations with UTF-8 attributes and complex functions such as
  MIN(), MAX(), AVG(), SUM(), COUNT(), MKTIME, JOIN, etc. fail on
  z/OS and i5/OS.
  

Problem conclusion

• New function for UTF-8 data comparison was added.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  
     | interim fix | 6.2.0.3-TIV-ITM-IF0001
  

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:

  IZ52745 OA29604 IZ54467 OA30232

Fix information

• Fixed component name

  TEMA

• Fixed component ID

  5724C04TE

Applicable component levels

• R620 PSY

     UP