16.20 - Ferret SHOWSPACE /S Display Enhancement - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

The Ferret SHOWSPACE command /S display option now shows a summary of space information for all AMPs in the current Ferret scope, rather than a separate row for every AMP. The /M and /L display options continue to show a row of output for each AMP, and /S remains the default display option.

Benefits

On systems with many thousands of AMPs, displaying an individual SHOWSPACE output row for each AMP will result in a large amount of output, and can take significant time. Using the /S option now provides a one-line summary output showing the combined space information for all AMPs in the current scope.

Additional Information

For more information on the Ferret utility and the SHOWSPACE command, see Ferret in Teradata Vantageā„¢ - Database Utilities , B035-1102 .