Procedure : Database setup and Telemetry Ingestion @Astrium

Author : E. Wieprecht Version : 3 (16.09.2005)

General

1. Remote login

   > ssh -X pacs@HIEGSE.redirectme.net

Setup Database

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

• If necessary / permanently :

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

• or only for this window

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

3. Makedb

   > makedb   pacseqmimt1
   > oscp -d
   > emacs /data/versant/db/pacseqmimt1/profile.be
   --->  In this file we set sysvol to 2047M

4. set proper DBID

   > dbid -d  pacseqmimt1
   > setdbid -C 12011 pacseqmimt1 
   Update profile.be
   > dbadmin -p pacseqmimt1

5. Initialize the database

   > db_admin -i pacseqmimt1@hos4-d

6. set access rights

   > dbuser -add -P pacseqmimt1

7. Expand database volum - if necessary

   check volume 
   > dbtool -F pacseqmimt1  # VERSANT 6
   > dbtool -space -volume -all pacseqmimt1 # VERSANT 7 -- man ! I neede quite some time to get this syntax change ...

   > addvol -n extraspace -p /data/versant/db/pacseqmimt1/extraspace -s 2047M pacseqmimt1

Procedure TmIngestion

1. Log into TmIngestion computer

   > ssh -X pacs@hos4-d

2. Check whether any TmIngestion is running

   > ps -elf | grep tmingestion

3. Check settings (APIDs/ Router/ Database) in property file :

   > emacs .pcss/props
   > Example attached 

4. Check proper pcss version / set if necessary

   > echo $PCSS_ROOT 
   Shall be : pcss-20050706A !!

   If necessary :
   Permanently :
   > emacs .cshrc
   ---> change PCSS_ROOT

   or only for this window 
   > setenv PCSS_ROOT /home/pacs/<version>
   > psetup  

5. start TmIngestion

   > tmingestion
   or
   > tmingestion < /dev/null >& /dev/null  &

6. Check whether we get packets

   > db2tty -d pacseqmimt1 | grep TmSource 

.pcss/props
===========
#
# Ekw 16.09.05 in order to use TmIngestion 
# Version 1.0
# -------------- PCSS 
# PCSS installation directory --> pcss is a link to active version
var.pcss.dir = /home/pacs/pcss-20050706A

# The name of the computer where the versant server runs.
var.database.server = @hos4-d

# The name of the database.
var.database.devel = pacseqmimt1@hos4-d

# Mission configuration
#hcss.ccm.mission.config = CQMconfig
hcss.ccm.mission.config = democonfig
# The location of the MIB
#var.mib.raw = ${user.home}/data/mib/pacs/merged/MIB-AUX-DATA
# -------------- TM Ingestion
# Replication 
#hcss.store.factory = herschel.versant.store.ReplStoreFactoryImpl
# Database name
hcss.tmingest.database = ${var.database.devel}
# Router server
hcss.tmingest.server = hos4-d
# Router port
hcss.tmingest.port = 9877
# Router reconnect
hcss.tmingest.routerretry = 60000
# Router client name
hcss.tmingest.name = PacsTelemetryIngestion
# HIFI packet processor
hcss.tmingest.tmpacketprocessor.hifi  = N
hcss.tmingest.tmpacketprocessor.hifi.name = herschel.tmproc.fifo.HifiTmPacketProcessor
# PACS packet processor
hcss.tmingest.tmpacketprocessor.pacs  = N
hcss.tmingest.tmpacketprocessor.pacs.name = herschel.tmproc.fifo.PacsTmPacketProcessor
# SPIRE packet processor
hcss.tmingest.tmpacketprocessor.spire = N
hcss.tmingest.tmpacketprocessor.spire.name = herschel.tmproc.fifo.SpireTmPacketProcessor
#Store commit
hcss.tmingest.transactions  = 200
# Store timer - commit in milliseconds every 2 min
hcss.tmingest.timerduration = 120000
# -------------- TM Ingestion (Inst Apids)
hcss.tmingest.apid1024 = N
hcss.tmingest.apid1026 = Y
hcss.tmingest.apid1028 = N
hcss.tmingest.apid1030 = N
hcss.tmingest.apid1153 = Y
hcss.tmingest.apid1155 = Y
hcss.tmingest.apid1157 = Y
hcss.tmingest.apid1159 = Y
hcss.tmingest.apid1284 = N
hcss.tmingest.apid1286 = N
# TM Ingestion (S/C Apids)
# TM Ingestion (EGSE Apids)
# DBASE
# pcss
# Simulator
# BoloSimulator
# SpectrSimulator
# Variables


#The tool uses the following properties to control the MissionConfiguration:
hcss.ccm.mission.basic.models = { HIFI.FLIGHT, PACS.FLIGHT, SPIRE.FLIGHT}
hcss.ccm.mission.basic.tp_registry = true
# For
# 12.09.05 end

var.mib.raw=${user.home}/mib
#
TcPacketDumper.router.hostname=hos4-d
TcPacketDumper.router.portnumber=9877
TcPacketDumper.router.clientname=TcPacketDumper
TmPacketDumper.router.hostname=hos4-d
TmPacketDumper.router.portnumber=9877
TmPacketDumper.router.clientname=TmPacketDumper
#
hcss.cus.instrument=PACS
#
hcss.ccshandler.instrumentName=PACS

Indexing the Database

Make sure that you have enough space in the database left:

dbtool -space -volume -all <dbname>

Free space should be at least 20%.

java -Xmx512M herschel.access.db.CreateIndexes <dbname>

Alternatively, using the versant commands:

dbtool -index -create -btree herschel.versant.ccm.TmSourcePacketImpl _time <dbname>