= Procedure : Database Transfer from Astrium to MPE =
Author  : E. Wieprecht
Version : 3 (16.09.2005)


== Executed : Over night after end of working day ==

== General ==
1. Remote login
{{{ 
   ssh -X pacs@HIEGSE.redirectme.net
}}}

== Database Transfer from Astrium ==
1. Log into database server computer 
{{{
   > ssh -X pacs@hos4-d
   > psetup
}}}

2. Check proper pcss version / set if necessary
{{{
   > echo $PCSS_ROOT 
   ---> Shall be : pcss-20050706A  !!
}}}
   If necessary :
      Permanently :
{{{
      > emacs .cshrc
         ---> change PCSS_ROOT
      > emacs .pcss/props
         ---> change var.pcss.dir = /home/pacs/pcss-20050706
      >psetup
}}}
   or only for this window 
{{{
      > setenv PCSS_ROOT /home/pacs/<version>
      > emacs .pcss/props
         ---> change var.pcss.dir = /home/pacs/pcss-20050706
      > psetup  
}}}

3. backup
   First time make a complete (level 0) backup
{{{
   > vbackup -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1
}}}
   Second time we backup against level 0
{{{
   > vbackup -level 1 -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1
}}}

   Then we do backup only the changes against the last backup
{{{
   > vbackup -level 2 -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1
}}}   

   The level selection has to be done appropriate

4. Copy backup file to transfer computer 
{{{
   > scp pacseqmimt1_<date>.vbck pacs@hosqla4-1:
}}}

5. Log into pacs1 as dbsa
{{{
   > ssh -X dbsa@pacs1
}}}

6. FTP/copy data
{{{
   > scp pacs@HIEGSE.redirectme.net:pacseqmimt1_<date>.vbck .
}}}

== Restore Astrium data into MPE database ==
1. Log into pacs1 as dbsa
{{{
   > ssh -X dbsa@pacs1
   > cd dbbackups
}}}

2. Only the first (!)  time prepare the database
{{{
   > makedb pacseqmimt1
   
   > emacs /dbOper/versant/pacseqmimt1/profile.be
   In this file we set sysvol to 2047M or 8000 ...

   > createdb pacseqmimt1
}}}
   Normally not  necessary :
{{{
    > addvol -n extraspace -p /dbOper/versant/pacseqmimt1/extraspace -s 2047M pacseqmimt1
}}}

3. Set DBID
{{{
   > dbid -d  pacseqmimt1
   > dbid -C 12012 pacseqmimt1 
}}}
 
4. Restore database
{{{
   > vbackup -dev pacseqmimt1_<date>.vbck -restore pacseqmimt1
}}}
 
!!!!!!!!!!!!!!!!!!!!   ONLY if needed   !!!!!!!!!!!!!!!!!!!!!!!!!
We have schema 18 @Astrium - PCSS currently comes with schema 19 

5. Copy DB for schema evolution (time consuming !)
    In case the database exists remove it first : 
{{{
    > removedb -rmdir  pacseqmimt1A
}}}
   Multi user mode
{{{
    > dbinfo -m pacseqmimt1
   
    > makedb pacseqmimt1A 
}}}
    Check size 
{{{
    > dbtool -F pacseqmimt1
}}}
    Expand on size
{{{
    > emacs /dbOper/versant/pacseqmimt1A/profile.be  --> set SYSVOL to 8000M
}}} 
    Copy DB
{{{
    > vcopydb pacseqmimt1 pacseqmimt1A  
}}}

    Public access
{{{
    > dbuser -add -P pacseqmimt1A
}}}
    DBID
{{{
    > dbid -r  pacseqmimt1A
    > dbid -d  pacseqmimt1A
    > dbid -C 12013 pacseqmimt1A 
}}}

5. check the schema of the database / adopt if necessary (may be time consuming !)
   Check schema
{{{
   > schema_tool -v pacseqmimt1A
}}}
   Trick for schema evolution : 
{{{
   > setenv MALLOC_CHECK_ 1
}}}
   Single user mode 
{{{
   > dbinfo -1  pacseqmimt1A   
}}}

   Execute schema evolution
{{{
   > schema_evolver pacseqmimt1A 
}}}
   
   Set to multi user mode 
{{{
   > dbinfo -m pacseqmimt1A
}}}