IV07524: BAD TEMPLATE RECORDS CAN CAUSE AN ABEND IN FTO STAGE II

IBM Tivoli Monitoring 6.2.2 Fix Pack 8 (6.2.2-TIV-ITM-FP0008)
IBM Tivoli Monitoring 6.2.2 Fix Pack 9 (6.2.2-TIV-ITM-FP0009)

APAR status

• Closed as program error.

Error description

• Approver Initials:    RB
  
   PROBLEM DESCRIPTION:
  
  An abend occurs on the MIRROR HUB during FTO stage II when a
  record in the TEMPLATE table contains a blank value for the NAME
  column.
  
  RECREATE INSTRUCTIONS:
  - Create a record in the TEMPLATE table at the primary HUB that
  contains a blank value for the NAME column. It is unknown how
  these records got into the customer's table, so you may have to
  SQL to create this
  record.
  - Start the MIRROR HUB
  - An abend should occur at the MIRROR during the MIRROR's FTO
  stage II processing.
  
  Secondary symptom: One customer experienced a flood of
  
  "sequence number overflow, reusing 999"
  
  at hundreds of times a second. The TEMS was virtually unusable.
  

Local fix

• Delete the bad records. The following SQL can be used to list
  the records in the table:
  
  
    SELECT TEMPLATE, NAME, STATE, TYPE, LOCFLAG
      FROM O4SRV.TTMPLSIT;
  
  The following SQL can be used to delete a bad record in the
  table:
  
    DELETE FROM O4SRV.TTMPLSIT
      WHERE TEMPLATE = 'XXXXX' AND NAME = " ";
  
  Replace the "XXXXX" value with the record's value in the
  TEMPLATE
  column.
  

Problem summary

• An abend can occur on either the primary or secondary management
  servers during FTO stage II when a record in the TEMPLATE table
  contains a blank value for the NAME column.
  

Problem conclusion

• The monitoring server now prevents the abend if an invalid
  record is encountered. A message will be written to the RAS1
  log, and the record will be dumped to the log.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  
    | fix pack | 6.2.2-TIV-ITM-FP0007
    | fix pack | 6.2.3-TIV-ITM-FP0001
  

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:

  OA38223 OA39001

Fix information

• Fixed component name

  TEMS

• Fixed component ID

  5724C04MS

Applicable component levels

• R622 PSY

     UP