Herschel: Diff for "PACS/FM_ILT_Procedures/DatabaseProcedures"

Procedure TmIngestion during ILT

• Log into TmIngestion computer

  •      > ssh -X oper@pacs1

• Check whether any TmIngestion is running

  •      > ps -elf | grep tmingestion

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

  •      > emacs .pcss/props
         > Example attached 

  • start TmIngestion

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

  • Check whether we get packets

       > db2tty -d pacseqmimt1 | grep TmSource 

.pcss/props
===========
# The name of the computer where the versant server runs.
var.database.server = @pacs1

# The name of the database.
var.database.devel = pacsilt1@pacs1

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