|
Size: 580
Comment:
|
Size: 2542
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = DBIDs for PACS Databases = | = PACS Databases = |
| Line 6: | Line 6: |
| * 12001 : pacseqmimt1e * 12002 : cusdefinitions (warm tests of cus scripts : 20060426 |
* 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 23: | Line 26: |
| dbid -d cusdefinitions dbid -C 12002 cusdefinitions |
dbid -r cusdefinitions -> show DBID dbid -d cusdefinitions -> delete DBID dbid -C 12002 cusdefinitions -> set DBID |
| Line 26: | Line 30: |
= 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 * 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 }}} = 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 :
ftp://ftp.rssd.esa.int/pub/HERSCHEL/csdt/temp/ teamCSDT : usecases
- 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
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.