Additional directories created on the metadata repository tier computer (IBM Db2)
The directories indicated in this topic are created if a new Db2® instance is installed by the InfoSphere® Information Server installation program or the Db2 installation program. For other database system types, refer to the database system documentation.
- Database server installation directory
This directory contains the database server executable files and libraries.
Db2 must reside on a local file system. Db2 supports running the database software from a mounted NFS volume, but does not support installation to a mounted NFS volume.
The following table provides operating system-specific information about the database server installation directory.
Table 1. Database server installation directory: operating system-specific information Operating system Default directory path Additional requirements AIX /opt/IBM/db2 None Linux /opt/IBM/db2 None Windows C:\IBM\SQLLIB None The installation directory path can contain only the following characters:- 0-9
- [a-z][A-Z]
- - (hyphen)
- _ (underscore)
- . (period)
Do not use accented characters, double byte characters, or the following special characters in the path: ` ! @ # $ % ^ & * ( ) | \/ ? > <, { } [ ]
- Db2 instance owner home directory
- The following table provides operating system-specific information
about the Db2 instance owner
home directory.
Table 2. Db2 instance owner home directory: operating system-specific information Operating system Default directory path Additional requirements AIX Linux Db2 instance owner: /home/db2inst1 The /var file system path must have at least 1 GB of space available for the Db2 temporary directory.
The Db2 instance owner must have read, write, and execute permissions to its home directory, and read permission to its parent directory.
If the directory is on a network file system (NFS), export the file system with the no_root_squash option enabled and the nosetuid option off.
Windows Db2 instance owner:
c:\Documents and Settings\db2admin or c:\Users\db2adminThe Db2 instance owner must have full control of its own home directory. - Database storage directory
- This directory will contain data for the operations of InfoSphere Information Server.
This data is separate and distinct from the data in your data sources,
and can include the following databases or schemas among others:
- Metadata repository. This database is typically named xmeta.
- Analysis databases for IBM InfoSphere Information Analyzer. If there is only one analysis database, it is typically named iadb.
- Test results database for IBM InfoSphere QualityStage® (no default directory)
- Operations database for IBM InfoSphere DataStage®. This database is typically named dsodb.
The directory is created by the InfoSphere Information Server installation program. Put the directory on a file system that has high-speed read-write performance.
Rather than backing up the directory, regularly back up the databases using your database backup facilities. In general, you back up a database by using the method provided by the database system.
The following table provides operating system-specific information about the database storage directory.
Table 3. Additional requirements and default paths for the database storage directory Operating system Default directory path Additional requirements AIX Linux /opt/IBM/InformationServer/Repos - The Db2 database instance owner (db2inst1) must own the directories that store the metadata repository and the analysis databases.
- If the directory is on a network file system (NFS), export the file system with the no_root_squash option enabled and the nosetuid option off.
Windows C:\DB2 None