SHOWACCESS [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
SHOWACCESS
The SHOWACCESS command displays the file access mode for all the DBEFiles
in a DBEnvironment.
Scope
SQLUtil Only
SQLUtil Syntax
>> SHOWACCESS DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord
Parameters
DBEnvironmentName is the name of a DBEnvironment containing
DBEFiles whose access mode you wish to display.
MaintenanceWord is the maintenance word.
Description
* Use this command to display the access mode of the DBEFiles in a
DBEnvironment with the MOVEFILE command.[REV BEG]
_________________________________________________________________
NOTE Pseudo-mapped files are no longer supported. If any files
are currently pseudo-mapped, use the SQLUtil MOVEFILE
command to convert them to mapped files.
_________________________________________________________________
[REV END]
Authorization
Any user may execute this command.
Example
[REV BEG]
>> SHOWACCESS
DBEnvironment Name: PARTSDBE.SOMEGRP.SOMEACCT
Maintenance Word: Return
PARTSF0 mapped
PURCHDF1 mapped
PURCHXF1 mapped
WAREHDF1 mapped
WAREHXF1 mapped
ORDERDF1 mapped
ORDERXF1 mapped
RECDF1 mapped
[REV END]
MPE/iX 5.5 Documentation