DETACHFILE

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. The DBEnvironment name may be entered either as an absolute pathname or as a pathname relative to your current working directory.
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, a superuser, or you must 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