DSDS(1)



NAME

     dsds - data strorage and distribution system


SYNOPSIS

     N/A


DESCRIPTION

     dsds consists of the dsds_svc program and the  Oracle  data-
     base.

     dsds_svc is launched by pe when the map file  specified  for
     pe  indicates  that  database  support  is required for data
     retrieval or data storage. pe will only launch a dsds_svc if
     it  does  not detect that one is currently running. Normally
     dsds_svc is lauched on the same host that pe is executed on.
     dsds_svc remains running after a pe exits. There is only one
     dsds_svc that serves all the pe's of a user.

     dsds_svc is run as a PVM (Parallel Virtual Machine) task.  A
     pvm daemon must be running on each host specified in the map
     file.

     The Oracle database consists of the Oracle Version 7 distri-
     bution and the schema for the SSSC tables.


SCHEMA

     SQL> desc dsds_test;
      Name                            Null?    Type
      ------------------------------- -------- ----
      PROG_NAME                       NOT NULL VARCHAR2(20)
      PROG_NUM                        NOT NULL NUMBER(8)
      LEVEL_NAME                      NOT NULL VARCHAR2(20)
      SERIES_NAME                     NOT NULL VARCHAR2(20)
      SERIES_NUM                      NOT NULL NUMBER(8)
      LEVEL_NUM                                NUMBER(8)
      S_SERIAL_NUM                             NUMBER(8)
      E_SERIAL_NUM                             NUMBER(8)
      ONLINE_STATUS                            CHAR(5)
      ONLINE_LOC                               CHAR(80)
      ARCHIVE_STATUS                           CHAR(5)
      ARCH_TAPE_ID                             NUMBER(5)
      WORK_TAPE_ID                             NUMBER(5)
      SAFE_TAPE_ID                             NUMBER(5)
      HISTORY_COMMENT                          CHAR(60)
      BYTES                                    NUMBER(20)
      CREATE_UID                               NUMBER(38)
      SVC_VERSION                              NUMBER(10)
      SVC_NAME                                 VARCHAR2(20)
      CREAT_DATE                               DATE
      TAPE_POSITION                            VARCHAR2(15)
      TAPE_FILE_NUM                            NUMBER(5)
      AVAIL_OBJECT_VAL                         VARCHAR2(15)
      AVAIL_MASK_VAL                           VARCHAR2(10)
      AVAIL_OBSMODE_VAL                        VARCHAR2(8)
      AVAIL_PATH_VAL                           VARCHAR2(10)
      AVAIL_BINNING_VAL                        VARCHAR2(15)
      AVAIL_CALW_VAL                           VARCHAR2(15)
      AVAIL_PAW_VAL                            VARCHAR2(15)
      AVAIL_MTM1_VAL                           VARCHAR2(15)
      AVAIL_MTM2_VAL                           VARCHAR2(15)
      AVAIL_POLARIZATION_VAL                   VARCHAR2(5)
      AVAIL_TUNING_VAL                         VARCHAR2(8)
      AVAIL_FOCUS_VAL                          VARCHAR2(15)
      AVAIL_ENVIRONMENT_VAL                    VARCHAR2(15)
      AVAIL_OVEN_TEMP_VAL                      VARCHAR2(10)
      AVAIL_CCD_TEMP_VAL                       VARCHAR2(10)
      AVAIL_SPECIAL_VAL                        VARCHAR2(225)

     SQL> desc open_pe;
      Name                            Null?    Type
      ------------------------------- -------- ----
      U_ID                            NOT NULL NUMBER(38)
      PE_ID                           NOT NULL NUMBER(20)

     SQL> desc partn_avail;
      Name                            Null?    Type
      ------------------------------- -------- ----
      PARTN_NAME                      NOT NULL VARCHAR2(80)
      TOTAL_BYTES                     NOT NULL NUMBER(20)
      AVAIL_BYTES                     NOT NULL NUMBER(20)

     SQL> desc partn_alloc;
      Name                            Null?    Type
      ------------------------------- -------- ----
      WD                              NOT NULL VARCHAR2(80)
      U_ID                            NOT NULL NUMBER(38)
      STATUS                          NOT NULL NUMBER(5)
      BYTES                                    NUMBER(20)

     SQL> desc image_cat;
      Name                            Null?    Type
      ------------------------------- -------- ----
      PROG_NAME                       NOT NULL VARCHAR2(20)
      PROG_NUM                        NOT NULL NUMBER(8)
      LEVEL_NAME                      NOT NULL VARCHAR2(20)
      SERIES_NAME                     NOT NULL VARCHAR2(20)
      SERIES_NUM                      NOT NULL NUMBER(8)
      SERIAL_NUM                               NUMBER(8)
      LEVEL_NUM                                NUMBER(8)
      SVC_VERSION                              NUMBER(10)
      SVC_NAME                                 VARCHAR2(20)
      OBJECT                                   VARCHAR2(15)
      MASK                                     VARCHAR2(10)
      OBSMODE                                  VARCHAR2(8)
      PATH                                     VARCHAR2(10)
      BINNING                                  VARCHAR2(15)
      CALW1                                    VARCHAR2(15)
      CALW2                                    VARCHAR2(15)
      PAW                                      VARCHAR2(15)
      MTM1                                     VARCHAR2(15)
      MTM2                                     VARCHAR2(15)
      POLARIZATION                             VARCHAR2(5)
      TUNING                                   VARCHAR2(8)
      FOCUS                                    VARCHAR2(15)
      ENVIRONMENT                              VARCHAR2(15)
      OVEN_TEMP                                VARCHAR2(10)
      CCD_TEMP                                 VARCHAR2(10)
      SPECIAL                                  VARCHAR2(225)
      DB_OBS_DATE                              DATE
      DATE_OBS                                 VARCHAR2(10)
      TIME_OBS                                 VARCHAR2(10)
      NAXIS1                                   NUMBER(8)
      NAXIS2                                   NUMBER(8)


SEE ALSO

     SOI-TN-109 "SSSC Implementation Version 1.0"


AUTHOR

     Jim Aloise


HISTORY

     1994-02-24     SOI Version 0.8