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 :

  • ftp://ftp.rssd.esa.int/pub/HERSCHEL/csdt/temp/ teamCSDT : usecases

• 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.