1. Database Structure › 1.3 Data Content › 1.3.1 OS/390 Data Set Naming Conventions

1.3.1 OS/390 Data Set Naming Conventions

The Database is physically organized as a series of online
and archived OS/390 data sets, which associate to the
Timespan level.  The following data set names are the
standard names assigned to these OS/390 data sets:

 Database Online Storage

  prefix.MICS.DETAIL,       DETAIL Timespan
  prefix.MICS.DAYS,         DAYS Timespan
  prefix.MICS.WEEKS,        WEEKS Timespan
  prefix.MICS.MONTHS,       MONTHS Timespan
  prefix.MICS.YEARS,        YEARS Timespan
  sharedprefix.MICS.TABLES, TABLES AREA

 Database Archive Audit Storage

  tapeprefix.MICS.AUDIT.xxxxxx(n),
     xxxxxx is the SAS File Name

 Database Archive Weekly History Storage

  tapeprefix.MICS.HISTW.xxxxxx(n),
     xxxxxx is the SAS File Name

 Database Archive Monthly History Storage

  tapeprefix.MICS.HISTM.xxxxxx(n),
     xxxxxx is the SAS File Name

The data set name 'prefix' and 'tapeprefix' used above
is defined by the installation.

Since these files may appear in every database in the
Database Complex, the DD names used are formed from a root
name plus a prefix character.  The character used as a prefix
is the character specified as the database identifier in the
DATABASE statement of the JCLDEF parameter member.  For
example, if a Database Unit had a suffix of 'P' then the DD
names would be as follows:

  For the Online Files:

                       PDETAIL
                       PDAYS
                       PWEEKS
                       PMONTHS
                       PYEARS
                       PTABLES

  For the Archive Files:

                       PAUxxxxxx
                       PHWxxxxxx
                       PHMxxxxxx

                       (where xxxxxx is a SAS file name)