About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
Filtering a select statement filter on an empty, null, or blank field.
Cause
Looking for situations where a value in a field has not been set. For example, when looking for all volumes that don't have a location.
Resolving The Problem
The syntax used to filter on empty/null fields for Tivoli Storage Manager (TSM) server select statement is "{field} is null".
To locate and identify all volumes that don't have a value for LOCATION, the following select statement could be used:
select volume_name,location,access from volumes where location is null
[{"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"}}]
Product Synonym
TSM
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager
Software version:
All Supported Versions
Document number:
71699
Modified date:
17 June 2018
UID
swg21111774