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  !!

      > emacs .cshrc
         ---> change PCSS_ROOT
      > emacs .pcss/props
         ---> change var.pcss.dir = /home/pacs/pcss-20050706
      >psetup

      > setenv PCSS_ROOT /home/pacs/<version>
      > emacs .pcss/props
         ---> change var.pcss.dir = /home/pacs/pcss-20050706
      > psetup  

3. backup

   > vbackup -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1

   > vbackup -level 1 -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1

   > vbackup -level 2 -dev pacseqmimt1_<date>.vbck -backup pacseqmimt1

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

    > 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 !)

    > removedb -rmdir  pacseqmimt1A

    > dbinfo -m pacseqmimt1
   
    > makedb pacseqmimt1A 

    > dbtool -F pacseqmimt1

    > emacs /dbOper/versant/pacseqmimt1A/profile.be  --> set SYSVOL to 8000M

    > vcopydb pacseqmimt1 pacseqmimt1A  

    > dbuser -add -P pacseqmimt1A

    > dbid -r  pacseqmimt1A
    > dbid -d  pacseqmimt1A
    > dbid -C 12013 pacseqmimt1A 

5. check the schema of the database / adopt if necessary (may be time consuming !)

   > schema_tool -v pacseqmimt1A

   > setenv MALLOC_CHECK_ 1

   > dbinfo -1  pacseqmimt1A   

   > schema_evolver pacseqmimt1A 

   > dbinfo -m pacseqmimt1A

Herschel: PACS/EQM_IMT_Procedures/DataTransfer (last edited 2009-07-15 14:32:38 by localhost)