Differences between revisions 1 and 16 (spanning 15 versions)
Revision 1 as of 2006-09-06 08:38:33
Size: 3368
Comment:
Revision 16 as of 2006-11-02 15:41:45
Size: 3347
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
== Procedure TmIngestion during ILT== = Pacs Database Setup during ILT =
The PACS operational setup :

attachment:PacsDataDis.jpg


attachment:dbsetup7.jpg
 * email from Tilmann :
    This is were replication would come in.
    Replication can be used to re-route data to a second database-node while
    maintaining links to and from the first database node (all in the same database
    system, and therefore transparent to all applications).

    Please remember that there are currently some issues with mixing replication/propagation.
    This is described in the DBA-Manual under current restrictions (Issue 0.18,
    chapter 8.4, section 2, bullet 2 and 3).

    When is ILT testing planned to start? By when would you require the issues to be resolved?
    In case ILT produces < 250GB data, I recommend to use a single database node.

== Procedure TmIngestion during ILT ==
Line 11: Line 31:
Line 22: Line 43:
   > tmingestion < /dev/null >& /dev/null  &    > tmingestion < /dev/null >& /dev/null &
Line 32: Line 53:
=========== ==============
#hcss.test.database = accesslayer2${var.database.server}
Line 34: Line 57:
var.database.server = @pacs1 var.database.server = @pacs1.mpe-garching.mpg.de
 
# The name of the database.
#var.database.devel = pacspreilt
var.database.devel = pacspreilt@pacs1
Line 36: Line 63:
# The name of the database.
var.database.devel = pacsilt1@pacs1
# The directory where the raw mib is located.
#var.mib.raw = ${var.mib.data}/4.4
hcss.access.instrumentmodel =PACS
 
#Replication
hcss.store.factory = herschel.versant.store.ReplStoreFactoryImpl
#hcss.store.factory = herschel.versant.store.StoreFactoryImpl
hcss.ccm.mission.config = democonfig
Line 39: Line 72:
# 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
# TM Ingestion
hcss.tmingest.tmpacketprocessor.pacs.name = herschel.pacs.spu.PacsTmPacketProcessor
hcss.tmingest.fifo.threadsleepduration = 1
hcss.tmingest.server = irsun01
hcss.tmingest.transactions = 100
hcss.tmingest.tmpacketprocessor.pacs = Y
hcss.tmingest.port = 9877
hcss.tmingest.name = TelemetryIngestion
hcss.tmingest.retry = 600
hcss.tmingest.fifo.queueinitialsize = 2000
hcss.tmingest.apid1156 = Y
Line 78: Line 84:
hcss.tmingest.apid1159 = Y
hcss.tmingest.apid1284 = N
hcss.tmingest.apid1286 = N
# TM Ingestion (S/C Apids)
# TM I
ngestion (EGSE Apids)
#
DBASE
#
pcss
# Simulator
# BoloSimulator
# SpectrSimulator
# Variables
hcss.tmingest.apid1160 = Y
hcss.tmingest.apid1161 = Y
hcss.tmingest.apid1162 = Y
hcss.tmingest.apid1163 = Y
hc
ss.tmingest.apid1164 = Y
Line 90: Line 90:
#Access
hcss.access.router.host = irsun01
hcss.access.router.port = 9877
Line 91: Line 94:
#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
# For CUS
hcss.cus.instrument = PACS
hcss.cus.database = sftcode@pacs1.mpe-garching.mpg.de
Line 97: Line 98:
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
Line 111: Line 100:
== Indexing the Database ==
Make sure that you have enough space in the database left:
=== Procedure for TCHistoory and OOL Ingestion during ILT ===
Line 114: Line 102:
dbtool -space -volume -all <dbname> ssh -X oper@pacs5
Line 116: Line 104:
Free space should be at least 20%.
Check .pcss/props and whether TC History and OOL Ingestion is already running
Line 119: Line 106:
java -Xmx512M herschel.access.db.CreateIndexes <dbname> > ps -elf | grep thfser
> ps -elf | grep tchi
> ps -elf | grep orf
> ps -elf | grep ool
Line 121: Line 111:

Alternatively, using the versant commands:
If not running, start it :
Line 124: Line 113:
dbtool -index -create -btree herschel.versant.ccm.TmSourcePacketImpl _time <dbname> > thfserver < /dev/null >& /dev/null &
> orfserver < /dev/null > & /dev/null &
> tchingest < /dev/null >& /dev/null &
> oolingest < /dev/null > & /dev/null &

Pacs Database Setup during ILT

The PACS operational setup :

attachment:PacsDataDis.jpg

attachment:dbsetup7.jpg

  • email from Tilmann :
    • This is were replication would come in. Replication can be used to re-route data to a second database-node while maintaining links to and from the first database node (all in the same database system, and therefore transparent to all applications). Please remember that there are currently some issues with mixing replication/propagation. This is described in the DBA-Manual under current restrictions (Issue 0.18, chapter 8.4, section 2, bullet 2 and 3). When is ILT testing planned to start? By when would you require the issues to be resolved?

      In case ILT produces < 250GB data, I recommend to use a single database node.

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
==============
#hcss.test.database  =  accesslayer2${var.database.server} 

# The name of the computer where the versant server runs.
var.database.server = @pacs1.mpe-garching.mpg.de
 
# The name of the database.
#var.database.devel = pacspreilt
var.database.devel = pacspreilt@pacs1

# The directory where the raw mib is located.
#var.mib.raw = ${var.mib.data}/4.4
hcss.access.instrumentmodel =PACS
 
#Replication
hcss.store.factory = herschel.versant.store.ReplStoreFactoryImpl      
#hcss.store.factory = herschel.versant.store.StoreFactoryImpl  
hcss.ccm.mission.config = democonfig 

# TM Ingestion
hcss.tmingest.tmpacketprocessor.pacs.name = herschel.pacs.spu.PacsTmPacketProcessor
hcss.tmingest.fifo.threadsleepduration = 1 
hcss.tmingest.server                   = irsun01
hcss.tmingest.transactions             = 100
hcss.tmingest.tmpacketprocessor.pacs   = Y
hcss.tmingest.port                     = 9877
hcss.tmingest.name                     = TelemetryIngestion
hcss.tmingest.retry                    = 600
hcss.tmingest.fifo.queueinitialsize    = 2000
hcss.tmingest.apid1156 = Y
hcss.tmingest.apid1157 = Y
hcss.tmingest.apid1160 = Y
hcss.tmingest.apid1161 = Y
hcss.tmingest.apid1162 = Y
hcss.tmingest.apid1163 = Y
hcss.tmingest.apid1164 = Y

#Access
hcss.access.router.host = irsun01
hcss.access.router.port = 9877

# For CUS
hcss.cus.instrument = PACS
hcss.cus.database = sftcode@pacs1.mpe-garching.mpg.de

Procedure for TCHistoory and OOL Ingestion during ILT

ssh -X oper@pacs5

Check .pcss/props and whether TC History and OOL Ingestion is already running

> ps -elf | grep thfser
> ps -elf | grep tchi
> ps -elf | grep orf
> ps -elf | grep ool

If not running, start it :

> thfserver < /dev/null >& /dev/null &
> orfserver < /dev/null > & /dev/null &
> tchingest < /dev/null >& /dev/null &
> oolingest < /dev/null > & /dev/null &

Herschel: PACS/FM_ILT_Procedures/DatabaseProcedures (last edited 2009-07-15 14:32:37 by localhost)