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

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

2820.0. "Merging DOCDB and DAF" by ANGLIN::HARRISA (user vicious) Mon Jun 07 1993 23:16

    ALL-IN-1 2.4 (patched to K603)
    VMS 5.5-2
    
    i need to merge 2 DOCDB.DAT and DAF.DAT files for 2 users.
    i've read the description of OA$CNV_MERGE function...is there anything
    else that needs to be done?
    
    why merge the files you ask...
    
    	1. the hardware on systemA went away. 
    	2. had to blend 360+ users from systemA to systemB
    	3. systemB was an existing system with 2000+ users and ALL-IN-1 2.4
    	4. the powers that be decided to unshare the mail on systemA
    	   and then backup and restore accross the network the accounts.
    
    this worked fine for about 98% of the accounts.  the 2 that I have a
    problem with had 2000+ documents in their file cabinets on systemA.
    after doing the backup etc onto systemB, they had most of their
    documents, a number of them were header/notext.
    
    i was able to restore and re-unshare these 2 account on systemA before
    the hardware went away. so now i have these 2 accounts on systemB that
    the users are using AND i have a saveset of the accounts from systemA.
    
    this is what i want to do -
    
    	1. restore the saveset to [user1.OA]. append _OLD to the docdb and
    	daf from the saveset
    	2. MERGE the 2 docdb.dat and daf.dat files together
    
    does this sound resonable?
    
    	thanks - ann
    
T.RTitleUserPersonal
Name
DateLines
2820.1SIOG::T_REDMONDThoughts of an Idle MindMon Jun 21 1993 16:059
    Don't use OA$CNV_MERGE (I'm surprised that no-one has said this
    before).
    
    Use the standard OpenVMS CONVERT utility to merge the files together.
    
    You may, however, hit duplicate entries in DOCDB.DAT.  Hasn't everyone
    got a document number 000001?
    
    Tony
2820.2Holes don't get filledIOSG::SHOVEDave Shove -- REO2-G/M6Tue Jun 22 1993 12:5910
�    You may, however, hit duplicate entries in DOCDB.DAT.  Hasn't everyone
�    got a document number 000001?
    
    No. my first one is 002361
    
    Anyway, the primary key is <folder:30><fixer> so the chances of your
    getting duplicates are much reduced (unless you leave everything in
    READ :-))
    
    D.
2820.3SIOG::T_REDMONDThoughts of an Idle MindTue Jun 22 1993 20:461
    Like some managers in IOSG... ????
2820.4Not any longer....IOSG::PYEGraham - ALL-IN-1 Sorcerer&#039;s ApprenticeWed Jun 23 1993 10:136
    No, the one with 23,000 documents in his READ folder left at Christmas.
    It only took me four or five hours to delete that folder :-)
    
    The remaining IOSG managers are quite well behaved!
    
    Graham