Schéma de Base de données

ALAMODE

! Champs ! Type ! Taille !  ! TYPE | VARCHAR2 | 20 | not null  ! INT_VAL | NUMBER | 22 |  ! STR_VAL | VARCHAR2 | 255 |

ALARM

! Champs ! Type ! Taille !  ! EOID | VARCHAR2 | 12 | not null  ! ALARM | NUMBER | 22 |  ! ALARM_TIME | NUMBER | 22 |  ! JOB_NAME | VARCHAR2 | 30 |  ! JOID | NUMBER | 22 |  ! EVT_NUM | NUMBER | 22 |  ! STATE | NUMBER | 22 |  ! THE_USER | VARCHAR2 | 60 |  ! STATE_TIME | NUMBER | 22 |  ! EVENT_COMMENT | VARCHAR2 | 255 |  ! LEN | NUMBER | 22 |  ! RESPONSE | LONG | 0 |

AUDIT_INFO

! Champs ! Type ! Taille !  ! AUDIT_INFO_NUM | NUMBER | 22 | not null  ! ENTITY | VARCHAR2 | 80 | not null  ! TIME | NUMBER | 22 | not null  ! TYPE | VARCHAR2 | 1 | not null

AVG_JOB_RUNS

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! AVG_RUNTIME | NUMBER | 22 |  ! NUM_RUNS | NUMBER | 22 |

CALENDAR

! Champs ! Type ! Taille !  ! NAME | VARCHAR2 | 30 | not null  ! DAY | DATE | 7 | not null

CHASE

! Champs ! Type ! Taille !  ! NSTART | NUMBER | 22 | not null  ! JOID | NUMBER | 22 | not null  ! JOB_NAME | VARCHAR2 | 30 |  ! JOB_TYPE | CHAR | 1 |  ! STATUS | NUMBER | 22 |  ! RUN_MACHINE | VARCHAR2 | 30 |  ! PID | NUMBER | 22 |  ! JC_PID | NUMBER | 22 |

CONFIG

! Champs ! Type ! Taille !  ! FLD | VARCHAR2 | 30 | not null  ! CODE | CHAR | 1 | not null  ! TEXT | VARCHAR2 | 30 |

CRED

! Champs ! Type ! Taille !  ! CRED_DOMAIN | VARCHAR2 | 8 | not null  ! DOMAIN_NAME | VARCHAR2 | 64 | not null  ! PRINCIPAL | VARCHAR2 | 64 | not null  ! CRED_VALUE | VARCHAR2 | 64 |  ! OWNER | VARCHAR2 | 80 |

EVENT

! Champs ! Type ! Taille !  ! EOID | VARCHAR2 | 12 | not null  ! JOID | NUMBER | 22 |  ! JOB_NAME | VARCHAR2 | 30 |  ! BOX_NAME | VARCHAR2 | 30 |  ! AUTOSERV | VARCHAR2 | 30 |  ! PRIORITY | NUMBER | 22 |  ! EVENT | NUMBER | 22 |  ! STATUS | NUMBER | 22 |  ! ALARM | NUMBER | 22 |  ! EVENT_TIME_GMT | NUMBER | 22 |  ! EXIT_CODE | NUMBER | 22 |  ! MACHINE | VARCHAR2 | 30 |  ! PID | NUMBER | 22 |  ! JC_PID | NUMBER | 22 |  ! RUN_NUM | NUMBER | 22 |  ! NTRY | NUMBER | 22 |  ! TEXT | VARCHAR2 | 255 |  ! QUE_PRIORITY | NUMBER | 22 |  ! STAMP | DATE | 7 |  ! EVT_NUM | NUMBER | 22 |  ! QUE_STATUS | NUMBER | 22 | not null  ! QUE_STATUS_STAMP | DATE | 7 | not null

EXT_JOB

! Champs ! Type ! Taille !  ! EXT_JOB_NAME | VARCHAR2 | 30 | not null  ! EXT_AUTOSERV | VARCHAR2 | 4 | not null  ! STATUS | NUMBER | 22 | not null  ! STATUS_TIME | NUMBER | 22 | not null  ! RUN_NUM | NUMBER | 22 |  ! NTRY | NUMBER | 22 |  ! EXIT_CODE | NUMBER | 22 |

GLOB

! Champs ! Type ! Taille !  ! GLO_NAME | VARCHAR2 | 30 | not null  ! VALUE | VARCHAR2 | 100 |  ! VALUE_SET_TIME | NUMBER | 22 |  ! OWNER | VARCHAR2 | 80 |  ! PERMISSION | VARCHAR2 | 30 |

INTCODES

! Champs ! Type ! Taille !  ! FLD | VARCHAR2 | 30 | not null  ! CODE | NUMBER | 22 | not null  ! TEXT | VARCHAR2 | 30 |

JOB

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! JOB_NAME | VARCHAR2 | 30 | not null  ! JOB_TYPE | CHAR | 1 |  ! BOX_JOID | NUMBER | 22 |  ! OWNER | VARCHAR2 | 80 |  ! PERMISSION | VARCHAR2 | 30 |  ! MACHINE | VARCHAR2 | 80 |  ! N_RETRYS | NUMBER | 22 |  ! AUTO_HOLD | NUMBER | 22 |  ! COMMAND | VARCHAR2 | 255 |  ! CONDITION | VARCHAR2 | 255 |  ! DATE_CONDITIONS | NUMBER | 22 |  ! DAYS_OF_WEEK | VARCHAR2 | 80 |  ! RUN_CALENDAR | VARCHAR2 | 30 |  ! EXCLUDE_CALENDAR | VARCHAR2 | 30 |  ! START_TIMES | VARCHAR2 | 255 |  ! START_MINS | VARCHAR2 | 255 |  ! RUN_WINDOW | VARCHAR2 | 20 |  ! DESCRIPTION | VARCHAR2 | 255 |  ! TERM_RUN_TIME | NUMBER | 22 |  ! BOX_TERMINATOR | NUMBER | 22 |  ! JOB_TERMINATOR | NUMBER | 22 |  ! STD_IN_FILE | VARCHAR2 | 80 |  ! STD_OUT_FILE | VARCHAR2 | 80 |  ! STD_ERR_FILE | VARCHAR2 | 80 |  ! WATCH_FILE | VARCHAR2 | 80 |  ! WATCH_FILE_MIN_SIZE | NUMBER | 22 |  ! WATCH_INTERVAL | NUMBER | 22 |  ! MIN_RUN_ALARM | NUMBER | 22 |  ! MAX_RUN_ALARM | NUMBER | 22 |  ! ALARM_IF_FAIL | NUMBER | 22 |  ! CHK_FILES | VARCHAR2 | 255 |  ! FREE_PROCS | NUMBER | 22 |  ! PROFILE | VARCHAR2 | 80 |  ! HEARTBEAT_INTERVAL | NUMBER | 22 |  ! JOB_LOAD | NUMBER | 22 |  ! PRIORITY | NUMBER | 22 |  ! AUTO_DELETE | NUMBER | 22 |  ! NUMERO | NUMBER | 22 |  ! MAX_EXIT_SUCCESS | NUMBER | 22 |  ! BOX_SUCCESS | VARCHAR2 | 255 |  ! BOX_FAILURE | VARCHAR2 | 255 |

JOB2

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! COMMAND2 | VARCHAR2 | 255 |  ! CONDITION2 | VARCHAR2 | 255 |  ! EXTERNAL_APP | VARCHAR2 | 40 |  ! TIMEZONE | VARCHAR2 | 50 |

JOB_COND

! Champs ! Type ! Taille !  ! COND_MODE | NUMBER | 22 | not null  ! JOID | NUMBER | 22 | not null  ! INDX | NUMBER | 22 | not null  ! TYPE | CHAR | 1 |  ! COND_JOB_NAME | VARCHAR2 | 30 |  ! COND_JOB_AUTOSERV | VARCHAR2 | 30 |  ! OPERATOR | VARCHAR2 | 2 |  ! VALUE | NUMBER | 22 |  ! INDX_PTR | NUMBER | 22 |  ! TEST_GLOVALUE | VARCHAR2 | 100 |

JOB_RUNS

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! RUN_NUM | NUMBER | 22 | not null  ! NTRY | NUMBER | 22 | not null  ! STARTIME | NUMBER | 22 |  ! ENDTIME | NUMBER | 22 |  ! STATUS | NUMBER | 22 |  ! EXIT_CODE | NUMBER | 22 |  ! RUNTIME | NUMBER | 22 |  ! EVT_NUM | NUMBER | 22 |  ! MACHINE | VARCHAR2 | 80 |

JOB_STATUS

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! STATUS | NUMBER | 22 |  ! STATUS_TIME | NUMBER | 22 |  ! RUN_NUM | NUMBER | 22 |  ! LAST_START | NUMBER | 22 |  ! LAST_END | NUMBER | 22 |  ! NEXT_START | NUMBER | 22 |  ! RUN_WINDOW_END | NUMBER | 22 |  ! NTRY | NUMBER | 22 |  ! APPL_NTRY | NUMBER | 22 |  ! TIME_OK | NUMBER | 22 |  ! EXIT_CODE | NUMBER | 22 |  ! RUN_MACHINE | VARCHAR2 | 80 |  ! QUE_NAME | VARCHAR2 | 62 |  ! RUN_PRIORITY | NUMBER | 22 |  ! NEXT_PRIORITY | NUMBER | 22 |  ! PID | NUMBER | 22 |  ! JC_PID | NUMBER | 22 |  ! LAST_HEARTBEAT | NUMBER | 22 |  ! EVT_NUM | NUMBER | 22 |  ! OVER_NUM | NUMBER | 22 |

KEYMASTER

! Champs ! Type ! Taille !  ! HOSTID | VARCHAR2 | 32 | not null  ! HOSTNAME | VARCHAR2 | 64 | not null  ! PRODUCT | VARCHAR2 | 31 | not null  ! TYPE | CHAR | 1 | not null  ! SERVER | CHAR | 12 | not null  ! DAKEY | VARCHAR2 | 255 | not null

LAST_EOID_COUNTER

! Champs ! Type ! Taille !  ! COUNTER | CHAR | 7 | not null

MACHINE

! Champs ! Type ! Taille !  ! NAME | VARCHAR2 | 80 | not null  ! PARENT_NAME | VARCHAR2 | 80 | not null  ! QUE_NAME | VARCHAR2 | 160 |  ! TYPE | CHAR | 1 |  ! FACTOR | FLOAT | 22 |  ! MAX_LOAD | NUMBER | 22 |

MONBRO

! Champs ! Type ! Taille !  ! ALARM_VERIF | NUMBER | 22 |  ! ALARM | NUMBER | 22 |  ! ALL_EVENTS | NUMBER | 22 |  ! ALL_STATUS | NUMBER | 22 |  ! RUNNING | NUMBER | 22 |  ! SUCCESS | NUMBER | 22 |  ! FAILURE | NUMBER | 22 |  ! TERMINATE | NUMBER | 22 |  ! STARTING | NUMBER | 22 |  ! RESTART | NUMBER | 22 |  ! ON_ICE | NUMBER | 22 |  ! ON_HOLD | NUMBER | 22 |  ! JOB_FILTER | CHAR | 1 |  ! JOB_NAME | VARCHAR2 | 30 |  ! CURRUN | NUMBER | 22 |  ! AFTER_TIME | VARCHAR2 | 20 |  ! AUTOSERV | VARCHAR2 | 30 |  ! NAME | VARCHAR2 | 30 | not null  ! MON_MODE | CHAR | 1 |  ! OUTPUT | CHAR | 1 |  ! SOUND | NUMBER | 22 |

MSG_ACK

! Champs ! Type ! Taille !  ! EOID | VARCHAR2 | 12 | not null  ! WHO | VARCHAR2 | 30 |  ! TIMEIN | NUMBER | 22 |  ! TIMEACK | NUMBER | 22 |  ! COMM | VARCHAR2 | 80 |

NEXT_OID

! Champs ! Type ! Taille !  ! OID | NUMBER | 22 |  ! FIELD | VARCHAR2 | 31 | not null

NEXT_RUN_NUM

! Champs ! Type ! Taille !  ! RUN_NUM | NUMBER | 22 |

OVER_JOB

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! MACHINE | VARCHAR2 | 80 |  ! N_RETRYS | NUMBER | 22 |  ! AUTO_HOLD | NUMBER | 22 |  ! COMMAND | VARCHAR2 | 255 |  ! CONDITION | VARCHAR2 | 255 |  ! DATE_CONDITIONS | NUMBER | 22 |  ! DAYS_OF_WEEK | VARCHAR2 | 80 |  ! RUN_CALENDAR | VARCHAR2 | 30 |  ! EXCLUDE_CALENDAR | VARCHAR2 | 30 |  ! START_TIMES | VARCHAR2 | 255 |  ! START_MINS | VARCHAR2 | 255 |  ! RUN_WINDOW | VARCHAR2 | 20 |  ! TERM_RUN_TIME | NUMBER | 22 |  ! PROFILE | VARCHAR2 | 80 |  ! STD_IN_FILE | VARCHAR2 | 80 |  ! STD_OUT_FILE | VARCHAR2 | 80 |  ! STD_ERR_FILE | VARCHAR2 | 80 |  ! WATCH_FILE | VARCHAR2 | 80 |  ! WATCH_FILE_MIN_SIZE | NUMBER | 22 |  ! WATCH_INTERVAL | NUMBER | 22 |  ! MIN_RUN_ALARM | NUMBER | 22 |  ! MAX_RUN_ALARM | NUMBER | 22 |  ! OVER_NUM | NUMBER | 22 | not null  ! ENTITY | VARCHAR2 | 80 |  ! RUN_NUM | NUMBER | 22 |  ! SETUP_TIME | NUMBER | 22 |  ! START_TIME | NUMBER | 22 |

REQ_JOB

! Champs ! Type ! Taille !  ! JOB_NAME | VARCHAR2 | 30 | not null  ! REQ_AUTOSERV | VARCHAR2 | 4 | not null  ! REQ_JOB_NAME | VARCHAR2 | 30 | not null  ! PENDING_DELETE | CHAR | 1 |

SEND_BUFFER

! Champs ! Type ! Taille !  ! EOID | VARCHAR2 | 12 | not null  ! SERVERDB | VARCHAR2 | 40 | not null  ! STAMP | DATE | 7 |  ! SEND_STATUS | NUMBER | 22 |

SVARCHIVE_TBL

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 | not null  ! RUN_NUM | NUMBER | 22 | not null  ! NTRY | NUMBER | 22 | not null  ! AVG_MEM_USAGE | NUMBER | 22 | not null  ! CPU_USAGE | NUMBER | 22 | not null  ! IO_READS | NUMBER | 22 | not null  ! IO_WRITES | NUMBER | 22 | not null  ! END_TIME | NUMBER | 22 | not null

TIMEZONES

! Champs ! Type ! Taille !  ! NAME | VARCHAR2 | 50 | not null  ! TYPE | CHAR | 1 | not null  ! ZONE | VARCHAR2 | 50 | not null

WAIT_QUE

! Champs ! Type ! Taille !  ! JOID | NUMBER | 22 |  ! JOB_LOAD | NUMBER | 22 |  ! QUE_NAME | VARCHAR2 | 62 |  ! MAX_LOAD | NUMBER | 22 |  ! PRIORITY | NUMBER | 22 |

Accès rapide