IV50626: MKTIME FUNCTION ERRORS WHEN A ZERO TIME VALUE IS PROVIDED.

IBM Tivoli Monitoring 6.2.3 Fix Pack 5 (6.2.3-TIV-ITM-FP0005)

APAR status

• Closed as program error.

Error description

• Approver Initials:  HT
  
  The MQ monitoring application returns a zero value for a
  timestamp for the QLASTPUT column in the KMQ.QMQUEUES
  table which is associated to the
  Queue_Statistics.Last_Put_Date_and_Time attribute.
  
  Messages like the following will be issued to the TEMS RAS1
  trace log:
  
  (52415F4C.0001-166C:kdsxoc2.c,2062,"VXO2_MakeTime") MKTIME
  result is not a valid timestamp (mktime returned -1)
  (52415F4C.0002-166C:kdsxoc2.c,2068,"VXO2_MakeTime") Rejected
  timestamp fields:
  (52415F4C.0003-166C:kdsxoc2.c,2069,"VXO2_MakeTime")   Years
  since 1900
  ... 0
  (52415F4C.0004-166C:kdsxoc2.c,2070,"VXO2_MakeTime")   Months
  ............. 0
  (52415F4C.0005-166C:kdsxoc2.c,2071,"VXO2_MakeTime")   Days
  ............... 0
  (52415F4C.0006-166C:kdsxoc2.c,2072,"VXO2_MakeTime")   Hours
  .............. 6
  (52415F4C.0007-166C:kdsxoc2.c,2073,"VXO2_MakeTime")   Minutes
  ............ 0
  (52415F4C.0008-166C:kdsxoc2.c,2074,"VXO2_MakeTime")   Seconds
  ............ 0
  (52415F4C.0009-166C:kdsxoc2.c,2075,"VXO2_MakeTime")
  Milliseconds
  ....... 0
  
  RECREATE INSTRUCTIONS:
  Execute SQL like the following using kdstsns:
  
  SELECT QMQUEUES.QLASTPUT,
         QMQUEUES.ORIGINNODE
  FROM   KMQ.QMQUEUES, O4SRV.LOCALTIME
  WHERE  QMQUEUES.ORIGINNODE = "Q7G1:SYS:MQESA" AND
         MKTIME(QMQUEUES.QLASTPUT, '-', '6M') < LOCALTIME.SYSTIME;
  
  The above is a specific example to a particular TEMS and MQ
  agent.  Some values will need to be modified.
  

Local fix

• N/A
  

Problem summary

• The monitoring server issues many messages like the following to
   the trace log file:
  
  ... kdsxoc2.c,2062,"VXO2_MakeTime") MKTIME result is not a valid
  timestamp (mktime returned -1)
  ... kdsxoc2.c,2068,"VXO2_MakeTime") Rejected timestamp fields:
  ... kdsxoc2.c,2069,"VXO2_MakeTime") Years since 1900 ... 0
  ... kdsxoc2.c,2070,"VXO2_MakeTime") Months ............. 0
  ... kdsxoc2.c,2071,"VXO2_MakeTime") Days ............... 0
  ... kdsxoc2.c,2072,"VXO2_MakeTime") Hours .............. 0
  ... kdsxoc2.c,2073,"VXO2_MakeTime") Minutes ............ 30
  ... kdsxoc2.c,2074,"VXO2_MakeTime") Seconds ............ 0
  ... kdsxoc2.c,2075,"VXO2_MakeTime") Milliseconds ....... 0
  

Problem conclusion

• The code has been changed to not generate any error level trace
  messages if a TIMESTAMP value of 0000000000000000 is provided to
   the *TIME function.
  
  The fix for this APAR is contained in the following maintenance
  packages:
  | fix pack | 6.2.3-TIV-ITM-FP0005
  

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:

  OA44514

Fix information

• Fixed component name

  TEMS

• Fixed component ID

  5724C04MS

Applicable component levels

• R623 PSY

     UP