HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

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.

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 

MPE/iX 5.5 Documentation