Differences between revisions 6 and 7
Revision 6 as of 2006-05-05 10:01:33
Size: 3480
Editor: lalinekw2
Comment:
Revision 7 as of 2006-05-05 10:08:00
Size: 3607
Editor: lalinekw2
Comment:
Deletions are marked like this. Additions are marked like this.
Line 24: Line 24:

Line 30: Line 32:

Line 98: Line 102:
}}    }}}

Line 103: Line 109:

 * Check LD_LIBRARY_PATH (need to point into newest database engine directory e.g. /usr/local/versant/7.0.1

PACS Databases

a. Databases @ MPE 12000 - 12699

  • 12000 - 12250 : public databases for operations <br>

    • 12001 : pacseqmimt1e : database copy from Astrium EQM tests end 2005
    • 12002 : aotcode2 : 20060426 / copy of aotcode for population with Telemetry during warm AOT tests
    • 13283 : sftcode : should be 12000 s.th., but do not touch it any more
    • 13282 : aotcode : should be 12000 s.th., but do not touch it any more, AOT reference database 20060426 / for warm AOT tests
    • 12003 : leuven :
  • 12251 - 12699 : additional datbases

b. Databases @KUL 12700 - 13399

  • 12700 - 13000 : public databases for operations
  • 13001 - 13399 : additional datbases

c. Other databases 13400 - 13500

  • 13400 : EQMILT1@Astrium

d. Spare 13500 - 13999

Seting the Database IDs

dbid -r cusdefinitions -> show DBID
dbid -d cusdefinitions -> delete DBID
dbid -C 12002 cusdefinitions -> set DBID

Updating Database Engine

  • Log in as dbsa on PACS1.
  • Check Database engine :
    •      oscp -i 
           oscp -l
  • Download the new Database engine version from ESA page :
  • Save license file of previous version
    •       cp  /usr/local/versant/<versant-previous>/license.xml ~
  • Sometimes you may request new license file (license.xml) from tzaeschk@rssd.esa.int

  • Log in as root on PACS1.
  • Check disk space /usr/local is quite full already.
    •      df -h
  • Change to /usr/local/versant and make a directory to copy and extract the tar file.
    •      cd /usr/local/versant
           mkdir 7.0.1.1
           cd 7.0.1.1
           tar -zxvf vod7011_rhel.tar
           ./install.bin
  • Just to be sure check again the system setup and restart the xinetd :
    •      oscp -i
           oscp -l
           /etc/rc.d/xinetd restart
  • Install license file of previous version or requested one
    •       cp  license.xml /usr/local/versant/<versant-previous> 
  • Modify psetup scipt on PACS1 : account pcss
    •       emacs /home2/pcss/psetup
      For example :
          # Can use /etc/.osc... instead of these 4 variables
          setenv VERSANT_ROOT      /usr/local/versant/7.0.1
          setenv VERSANT_DB        /dbOper/versant
          setenv VERSANT_DBID      /dbOper/versant
          setenv VERSANT_DBID_NODE pacs1 
      
          set path=( /usr/local/versant/7.0.1/bin $path )
          set LIB_DIR=/usr/local/versant/7.0.1/lib
      
          setenv LD_LIBRARY_PATH /usr/local/versant/7.0.1/lib:${LD_LIBRARY_PATH}
      
          setenv THREADS_FLAG native

Schema evolution

  • Download and install PCSS containing the new Schema.
  • Check LD_LIBRARY_PATH (need to point into newest database engine directory e.g. /usr/local/versant/7.0.1
  • Send out Schema evolution warning.
  • Make sure that Databases are not used :
    •      dbtool -trans -info <DBName>
  • Make a backup of the database :
    •      vbackup -dev <DBName>.vbck -backup <DBName>
  • Set Databases to single user mode :
    •      dbinfo -1 <DBName>
  • Perform schema evolution as described in the Database Administration Manual (HSCDT/TN044) :
    •      schema_evolver <DBName>
  • Set the Database back to multi user mode :
    •      dbinfo -m <DBName>
  • Test from an arbitrary account
    • set in .pcss/props the Database to the schema evolved one
    • start cusgui
  • Send message to user.

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