The SHOWWHERE command displays information about cylinder allocation and temperature.
- Displays a summary listing of the cylinders showing one line for every cylinder type .
- This is the default.
- Displays a medium length listing of the cylinders with one line for every cylinder type per AMP (vproc).
- Displays a long listing of the cylinders with one line for every cylinder type per AMP (vproc) per storage device.
Display output is limited to cylinders in the current scope (one or more vprocs, tables, or the WAL log), defined with the SCOPE command. If no scope has been specified, SHOWWHERE shows information for all cylinders.
If temperature information is not available for the current scope, SHOWWHERE returns an error.