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

Teradata Vantage™ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1098-171K
Language
English (United States)

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.