SHOWBLOCKS Per AMP Information | Advanced SQL Engine 17.00 | Teradata Vantage - 17.00 - Ferret SHOWBLOCKS Per AMP Information - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Summary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
September 2020
category
Release Notes
featnum
B035-1098-170K

The SHOWBLOCKS command of the Ferret utility displays information about data blocks for tables and sub-tables in the Advanced SQL Engine file system. This new feature adds a PERVPROC option to SHOWBLOCK that displays data block information per AMP vprocs within the current scope.

Benefits

  • Displays data block information for specified AMPs.
  • Allows scoping to AMPs and maps, to display information about only the specified AMPs that are within the specified map.

Considerations

  • The PERVPROC option is not supported by the CreateFsysInfoTable and PopulateFsysInfoTable macros.

Additional Information

  • For more information about the Ferret utility, see Teradata Vantage™ - Database Utilities , B035-1102 .
  • For more information about the CreateFsysInfoTable and PopulateFsysInfoTable macros, see Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.