IC72356: SELECT FROM EVENTS TABLE DOES NOT RETURN EVENTS CONSISTENT WITH SQL STANDARDS ON V6.2.

APAR status

• Closed as program error.

Error description

• The select * from EVENTS table command does not comply with
  SQL standards on V6.2.
  If there is no SCHEDULED_START qualification, the select command
  will return event records for the current day only.
  If the SCHEDULED_START is specified as a column or listed
  in order by clause, all events are returned.
  
  Customer/L2 Diagnostics:
  The following select commands and their results describe the
  inconsistency.
  
  Command :
  Select * from events
  Result  :
  Returns events from current day only
  
  Command :
  Select SCHEDULED_START, SCHEDULE_NAME, NODE_NAME, STATUS
   from events
  Result  :
  Returns all events
  
  Command :
  select * from events order by scheduled_start
  Result  :
  Returns all events
  
  TSM Versions Affected:
  Tivoli Storage Manager server V6.2 on all platforms
  
  Additional Keywords:
  zz62 sched events 56436
  

Local fix

• To return the desired events, specify the scheduled_start
  as a condition on the select command. For example :
  
  select * from events where
   date(scheduled_start)>date('10/28/2010')
  
  This command returns events with scheduled_start greater than
  10/28/2010.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users      *
  *                 of the SELECT command on EVENTS table.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available.           *
  *                 This problem is currently projected          *
  *                 to be fixed in levels 6.1.5 and 6.2.3.       *
  *                 Note that this is subject                    *
  *                 to change at the discretion of IBM.          *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux,
  and Windows.
  Note: SELECT command on EVENTS table cannot display the
  deleted events earlier than the oldest existent records in
  Database and cannot display the future event since tomorrow.
  

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:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP