IBM Support

Select from events returns events from current day only.

Troubleshooting


Problem

A "select * from events where scheduled_start>current_timestamp-48 hours" command expecting events from the last two days but only the events from the current day are returned.

Cause

Working as designed for V5 servers. Design changed in V6.1.5, V6.2.3 and V6.3.0.0 levels.

Resolving The Problem

The select command from a Tivoli Storage Manager server V5 uses a subset of the SQL92 and SQL93 standards. The select from the events table is one command that does not follow the standard. By default, the select command returns the events for the current day only. To return events for previous days, it is not sufficient to perform timestamp operation such as "scheduled_start>current_timestamp-48 hours". This will still return events for the current day only. To return events from previous days, it is necessary to specify a *start* date for the scheduled_start. For example :

select node_name, status, scheduled_start from events where scheduled_start >= '1900-01-01' and (status like 'Missed' or status like 'Failed') and scheduled_start>current_timestamp-48 hours

The above command returns missed or failed events for the past two days. This design of the select command from the events table has been modified to be in line with sql standards with apar IC72356, implemented in the 6.1.5 and 6.2.3 levels of the server. The above command may be used to achieve the same results for for lower levels of Tivoli Storage Manager servers.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21579338