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.