Differences between revisions 1 and 6 (spanning 5 versions)
Revision 1 as of 2006-04-26 10:18:57
Size: 475
Editor: lalinekw2
Comment:
Revision 6 as of 2006-05-05 10:01:33
Size: 3480
Editor: lalinekw2
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
== DBIDs for PACS Databases == = PACS Databases =
Line 5: Line 5:
* 12000 - 12250 : public databases for operations <br>
* 12001 : pacseqmimt1e
* 12002 : cusdefinitions (warm tests of cus scripts : 20060426
 * 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 :
Line 9: Line 12:
* 12251 - 12699 : additional datbases  * 12251 - 12699 : additional datbases
Line 13: Line 16:
* 12700 - 13000 : public databases for operations
* 13001 - 13399 : additional datbases
 * 12700 - 13000 : public databases for operations
 * 13001 - 13399 : additional datbases
Line 17: Line 20:
* 13400 : EQMILT1@Astrium  * 13400 : EQMILT1@Astrium
Line 20: Line 23:

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

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

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.
      
       * 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)