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