beautypg.com

Shorthand views – HP NonStop G-Series User Manual

Page 148

background image

Database Design of DSM/TC

DSM/Tape Catalog User’s Guide — 520233-008

9 - 14

Shorthand Views

Shorthand Views

SQL shorthand views let you make customized reports based on the fields of the
DSM/TC database described in this section. These views can be used for read access
only because the DSM/TC database cannot be updated by software other than
DSM/TC.

These shorthand views do not change. They will always reflect the original database
structure regardless of future database enhancements.

For more information on using views, see the SQL/MP Installation and Management
Guide
.

Table Name

Shorthand View Name

CONFIG

CONFGV10

TAPEFILE

TFV10

TFTOV

TFTOVV10

DISKFILE

DFV10

DFTOV

DFTOVV10

POOL

POOLV10

POOLV20

VOLUME

VOLV10

VOLV20

VTOFC

VTOFCV10

VTOFCV20

This manual is related to the following products: