SQL/MP Installation and Management Guide
Querying SQL/MP Catalogs
HP NonStop SQL/MP Installation and Management Guide—523353-004
6-11
Displaying File and Security Attributes
This command obtains a detailed format listing, including the physical file name, for the
SQL table whose logical name is $VIR1.SALES.ORDERS (only part of the listing is
shown):
>> FILEINFO $VIR1.SALES.ORDERS, DETAIL;
$VIR1.SALES.ORDERS 20 Aug 1996, 11:41
SQL BASE TABLE
CATALOG $VIR1.SALES
|
|
PHYSICAL NAME: $PVOL11.ZYS00025.A045OR02
If you know a physical file name and want to find out the corresponding logical name,
you can use the FILEINFO command. This command displays the logical name
corresponding to a specified physical file name:
>> FILEINFO $PVOL11.ZYS00025.A045OR02, DETAIL;
$PVOL11.ZYS00025.A045OR02 20 Aug 1996, 11:41
SQL BASE TABLE
CATALOG $VIR1.SALES
|
|
LOGICAL NAME: $VIR1.SALES.ORDERS
Suppose that your starting point is a physical volume. You can use the detailed format
of the FILEINFO command to display the names of all the physical files managed by
SMF that reside on a specified physical volume. In addition, the FILEINFO command
displays the logical file names associated with those physical files. To perform this
task, you must include the ZYS prefix in the subvolume part of the qualified file set.
SMF reserves the ZYS prefix for physical file names.
This command displays the physical file names managed by SMF and residing on the
volume $PVOL11. It also displays the logical file names (in addition to other file and
security attributes) associated with those files.
>> FILEINFO $PVOL11.ZYS*.*, DETAIL;
This command omits the ZYS prefix. This example does not display any physical files
managed by SMF. It does display files residing on $PVOL11 that are outside the
control of SMF.
>> FILEINFO $PVOL11.*.*, DETAIL;
For OSS files, these considerations apply:
•
You cannot specify an OSS path name as input to the FILEINFO command, but
you can specify the Guardian ZYQ name associated with the OSS program.
•
The owner and security are displayed as appropriate OSS values.
•
The STATISTICS option is equivalent to the DETAIL option.