 |
» |
|
|
|
Detaches DBEFileSets and DBEFiles from the DBEnvironment and makes them
unavailable for normal access.
Scope |  |
SQLUtil Only SQLUtil Syntax |  |
>> DETACHFILE 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 detach (y/n)? { y [es] n [o]} Parameters |  |
- DBEnvironmentName
is the name of the DBEnvironment from which the DBEFileSets or DBEFiles
are to be detached.
- MaintenanceWord
is the Maintenance Word.
- DBEFilesetName
is the name of the DBEFileset to be detached.
You may enter a list of DBEFileSets, one name per line,
followed by a null line to terminate the list.
- SystemFileName
is the physical name of the DBEFile to be detached.
You may enter a list of DBEFiles, one name per line,
followed by a null line to terminate the list.
Description |  |
DBEFileSets and DBEFiles may be detached for partial recovery operations,
security reasons, or because they are infrequently used.
If you detach a DBEFileset, all the DBEFiles in the DBEFileset are detached.
You cannot detach the SYSTEM DBEFileSet, DBEFile0, or any
other DBEFiles that you have added to the SYSTEM DBEFileSet
to expand its size.
You can determine if a DBEFile is attached or detached by looking at the
column "ATTACHED" in the system views SYSTEM.DBEFILE and CATALOG.DBEFILE, or
the "Static DBEFile" screen of SQLMON.
Also see the SQLUtil ATTACHFILE command.
Authorization |  |
You must be the DBECreator, have SM capability, or supply the
correct Maintenance Word to use this command.
Example |  |
>> detachfile
DBEnvironment Name: PartsDBE
Maintenance Word: MaintenanceWord
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 proceed (y/n)? y
|
|