| Title: | Disk File Optimizer (DFO) for OpenVMS | 
| Notice: | Kits and documents: last reply to note 1 | 
| Moderator: | COOKIE::AMEND | 
| Created: | Tue May 16 1989 | 
| Last Modified: | Fri Jun 06 1997 | 
| Last Successful Update: | Fri Jun 06 1997 | 
| Number of topics: | 539 | 
| Total number of notes: | 2544 | 
    We have been successfully using V2.1A for a while, but I recently
    noticed that each node in the cluster is actually using a different DFG
    database! (Something similar to having installed it to point
    DFG$DATABASE to SYS$SPECIFIC instead of SYS$COMMON.) Anyway, I'd like
    to somehow "merge" the two databases into one and put it in a common
    location so that regardless of which machine runs the defrag it is
    accessing the common database. I presume it's tantamount to somehow
    merging the 7 DFG$*.DAT files in the DFG$DATABASEs?
    
    Assuming what I want to do is possible, can someone please give me
    guidance on how I can proceed?
    
    Thanks!
    
    	BD�
| T.R | Title | User | Personal Name | Date | Lines | 
|---|---|---|---|---|---|
| 524.1 | Yes, you can do it | COOKIE::AMEND | Mon Jan 27 1997 16:09 | 41 | |
| BD�
  There is a OpenVMS Merge utility that might do what you want.
  I would have to play with it to see if it works.
  The following is what I would do:
  1.  Extract the data from each database using the following
  command:
  $ defragment show */command/parameter/out=load_db.com
  2.  Edit each file
  Because DCL is limited to 255 characters, you will have to go
  in a edit load_db.com and remove lines that defaults.  Things
  are default are /level=2 -
  3.  Shut down the scheduler on each node.
  $ @SYS$STARTUP:DFG$STOP_SCHEDULER
   
  4.  Define DFG$DATABASE as system/exec where you want it be.
  5.  Create a new database using the following commands:
  $ run sys$system:dfg$create_database
  $ run sys$system:dfg$init_database
  
  6.  Edit SYS$STARTUP:DFG$STARTUP.COM so it points to where you
  want it.
  7.  Startup the schedulers with
  $ @SYS$STARTUP:DFG$START_SCHEDULER
  8.  Reload the database by executing each of the @load_db.com
  
  thanks
    jim amend
  
  
 | |||||
| 524.2 | worth trying | DYPSS1::DYSERT | Barry - Custom Software Development | Tue Jan 28 1997 11:44 | 3 | 
|     Barring any other ideas which may be forthcoming, thanks Jim.
    
    	BD�
 | |||||