Directory Structure Outside SAP Systems

In the software installation outside SAP systems, you have the option of installing the database software and at the same time creating a database instance, or of only installing the database software for now.

You also have the option of subsequently creating additional database instances that all use the same server software (same dependent path). However, you can also perform additional software installations for additional database software, so that an installation of the server software is only used by one database instance (multiple dependent paths).

Depending on what is already installed on your system and whether you are only installing software, only creating one database instance, or both at the same time, the system provides various default values for the directories in which the database software is installed and the files of the database system saved.

Therefore, the directory structures presented in the following are only for orientation purposes.

Case 1: First installation of the database software with creation of a database instance

  • An Independent Program Path
  • A Dependent Path
  • An Independent Data Path
  • A run directory of the database instance
  • A path for storing the log volumes
  • A path for storing the data volumes

Path

Default Value
(Microsoft Windows)

Default Value
(UNIX/Linux)

Independent Program Path

<drive>:\Program Files\sdb\programs

/opt/sdb/programs

Dependent Path

<drive>:\Program Files\sdb\<database_name>

/opt/sdb/<database_name>/db

Independent Data Path

<drive>:\Documents and Settings\All Users\Application Data\sdb\data

/var/opt/sdb/data

Run directory of the database instance

<drive>:\Documents and Settings\All Users\Application Data\sdb\data\wrk\<database_name>

/var/opt/sdb/data/wrk\<database_name>

Path for storing the log volume

<drive>:\Documents and Settings\All Users\Application Data\sdb\<database_name>\log

/var/opt/sdb/data/<database_name>/log

Path for storing the data volumes

<drive>:\Documents and Settings\All Users\Application Data\sdb\<database_name>\data

/var/opt/sdb/data/<database_name>/data

To ensure the downward compatibility of the database software, the database system creates the following directories on UNIX/Linux:

Path

Contents of directory

/var/spool/sql

Links to current directories and files

/usr/spool/sql

Links to current directories and files


Case 2: Creating additional database instances that use this server software

The Independent Program Path and the Independent Data Path have already been defined during the installation of the server software used.

When additional database instances are being created, a path for the Dependent Path is created for each database instance. In addition, below the existing Independent Data Path, the path for the working directory, the path for storing the log volumes, and the path for storing the data volumes, are created for each database instance.

The following new paths are created for each database instance:

  • A run directory of the database instance
  • A path for storing the log volumes
  • A path for storing the data volumes

Path

Default Value
(Microsoft Windows)

Default Value
(UNIX/Linux)

Run directory of the database instance

<drive>:\Documents and Settings\All Users\Application Data\sdb\data\wrk\<database_name>

/var/opt/sdb/data/wrk/<database_name>

Path for storing the log volume

<drive>:\Documents and Settings\All Users\Application Data\sdb\<database_name>\log

/var/opt/sdb/data/<database_name>/log

Path for storing the data volumes

<drive>:\Documents and Settings\All Users\Application Data\sdb\<database_name>\data

/var/opt/sdb/data/<database_name>/data

Example:

The database instances DEMODB, TESTDB and MAXDB are all created with the same, already existing server software. The following path structure results under the Independent Data Path:

<drive>:\Documents and Settings

All Users

--Application Data

---sdb

----data

-----wrk

------DEMODB

------TESTDB

------MAXDB

-----DEMODB

------log

------data

-----TESTDB

------log

------data

-----MAXDB

------log

------data


Case 3: First installation of the database software with the aim of creating the first database instance later on

  • An Independent Program Path
  • A Dependent Path
  • An Independent Data Path

Path

Default Value
(Microsoft Windows)

Default Value
(UNIX/Linux)

Independent Program Path

<drive>:\Program Files\sdb\programs

/opt/sdb/programs

Dependent Path

<drive>:\Program Files\sdb\<version>

/opt/sdb/<version>

Independent Data Path

<drive>:\Documents and Settings\All Users\Application Data\sdb\data

/var/opt/sdb/data

To ensure the downward compatibility of the database software, the database system creates the following directories on UNIX/Linux:

Path

Contents of directory

/var/spool/sql

Links to current directories and files

/usr/spool/sql

Links to current directories and files