TABELLA SELEZIONATA DELLO SCHEMA: LOGGER
NOME TABELLA:
DATAREC_LOGGER
STRUTTURA TABELLA:

Schema Selezionato: LOGGER

Tabella Selezionata: DATAREC_LOGGER


Fields description:


Field nameField typeCan be Null?Description
RUN_NR INTEGER No Run number
VERSION INTEGER No Version of the reconstruction executable
OFFLINE_ID CHAR ( 3 ) No Reconstruction machine identifier
DATAREC_NR INTEGER No Process identifier
STREAM_ID INTEGER No Stream identifier
GB_NR INTEGER No Sequential number
FILENAME VARCHAR ( 64 ) No File name
TSERVER_ID CHAR ( 3 ) Yes Manca descrizione
FILESPACE_ID INTEGER Yes Manca descrizione
SIZE INTEGER Yes File size
TOTAL_EVENTS INTEGER Yes Number of events inside the file
FIRST INTEGER No Manca descrizione
LAST INTEGER No Manca descrizione
CREATION_TIME TIMESTAMP No Creation time
CLOSURE_TIME TIMESTAMP Yes Closure time
Can be used to find out if the file is still being written(NULL value)
ARCHIVED INTEGER No Is the file archived or archiving?
(0-not archived,1-archiving,2-archived)
ANALYZED INTEGER Yes Not used at the moment

Indici:


Indice primario:
(con relativa lista di colonne)

  • ('SYSIBM', 'SQL990703102001640')
    • RUN_NR
    • VERSION
    • OFFLINE_ID
    • DATAREC_NR
    • STREAM_ID
    • GB_NR
Indici di unicita`:
(con relative liste di colonne)
  • ('SYSIBM', 'SQL990703102001900')
    • FILENAME
Indici rimanenti:
(con relative liste di colonne)
  • ('LOGGER', 'DATAREC_ARCH')
    • ARCHIVED
    • STREAM_ID
    • RUN_NR
    • VERSION
  • ('LOGGER', 'DATAREC_CLOSURE')
    • CLOSURE_TIME
  • ('LOGGER', 'DATAREC_STREAM')
    • STREAM_ID
    • RUN_NR
    • VERSION
  • ('LOGGER', 'DATAREC_VERRUN')
    • VERSION
    • RUN_NR
    • STREAM_ID
  • ('LOGGER', 'DATAREC_VERSTR')
    • VERSION
    • STREAM_ID
    • RUN_NR


Foreing Keys:


Local fields(s)Foreign field(s)Foreign field(s)
RUN_NR
RUN_LOGGER RUN_NR
STREAM_ID
STREAM_OFFLINE STREAM_ID
TSERVER_ID
STREAM_ID
FILESPACE_ID
FILESPACE_OFFLINE TSERVER_ID
STREAM_ID
FILESPACE_ID
ARCHIVED
ARCHIVED_STATUS STATUS