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
Modified date:
17 June 2018
UID
swg21111774