File System Information in an SQL Table - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

File System Information in an SQL Table

To see Ferret SHOWBLOCKS-like file system information in an SQL table, use the CreateFsysInfoTable and PopulateFsysInfoTable macros.

The following example creates a volatile, non-fallback table to hold a small display of disk block information:

exec dbc.createfsysinfotable('targetdatabasename','targettablename','volatile','n','showblocks','s');

The next example populates that volatile table with data block histogram and block-level compression details for the specified input table:

exec dbc.populatefsysinfotable('inputdatabasename','inputtablename','showblocks','s','targetdatabasename','targettablename');

For details, see SQL Functions, Operators, Expressions, and Predicates.