[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference cookie::aim$notes:disk_defrag

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

524.0. "merging separate DFG$DATABASEs (both V2.1A)?" by DYPSS1::DYSERT (Barry - Custom Software Development) Mon Jan 27 1997 09:45

    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.RTitleUserPersonal
Name
DateLines
524.1Yes, you can do itCOOKIE::AMENDMon Jan 27 1997 16:0941
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.2worth tryingDYPSS1::DYSERTBarry - Custom Software DevelopmentTue Jan 28 1997 11:443
    Barring any other ideas which may be forthcoming, thanks Jim.
    
    	BD�