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 number
IZ49406
Reported component name
TEMA
Reported component ID
5724C04TE
Reported release
620
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-04-15
Closed date
2009-06-29
Last modified date
2009-07-21
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
TEMA
Fixed component ID
5724C04TE
Applicable component levels
R620 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCTLMR","label":"ITM Tivoli Enterprise Mgmt Agent V6"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"620","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 July 2009