Herschel: PACS/FM_ILT_Procedures/DatabaseProcedures

Pacs Database Setup during ILT

• attachment:dbsetup2.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 >& tmingestion.log  &

  • 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