 |
» |
|
|
|
Attaches previously detached DBEFileSets and DBEFiles to the
DBEnvironment and makes them available for normal access. Scope | |
SQLUtil Only SQLUtil Syntax | |
>> ATTACHFILE DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord Enter DBEFileSet name
or Carriage Return to Finish: DBEFileSetName Enter DBEFileSet name or Carriage Return to Finish: Enter DBEFile name or Carriage Return to Finish: SystemFileName Enter DBEFile name or Carriage Return to Finish: Do you wish to attach (y/n) { y [es] n [o]} Parameters | |
- DBEnvironmentName
is the name of the DBEnvironment associated with the DBEFileSets and DBEFiles
to be attached.
- MaintenanceWord
is the Maintenance Word.
- DBEFileSetName
is the name of the DBEFileSet to be attached.
You may enter a list of DBEFileSets, one name per line, with a carriage return
to terminate the list. You may enter a carriage return by itself if no
DBEFileSets are to be attached.
- SystemFileName
is the physical name of the DBEFile to be attached.
You may enter a list of DBEFiles, one name per line, with a null line
to terminate the list, or a carriage return by itself if no DBEFiles are
to be added.
Description | |
Attaching a DBEFileset makes all the DBEFiles
in the DBEFileSet available for database access.
Attaching explicitly named DBEFiles makes those specific files available
for database access.
You can determine whether a DBEFile is ATTACHED or DETACHED by looking
at the column "ATTACHED" in the system views SYSTEM.DBEFILE or CATALOG.DBEFILE,
or the "Static DBEFile" screen of SQLMON.
Also refer to the SQLUtil DETACHFILE command.
Authorization | |
You must be the DBECreator,
have SM capability,
or you must supply the
correct Maintenance Word to use this command.
Example | |
>> attachfile
DBEnvironment Name: PartsDBE
Enter DBEFileset name or Carriage Return to Finish): WarehFS
Enter DBEFileset name or Carriage Return to Finish):
Enter DBEFile name or Carriage Return to Finish: OrderDF1
Enter DBEFile name or Carriage Return to Finish:
Do you wish to attach (y/n)? y
File(s) Attached.
|
|
