Although you can specify a fully qualified file name, (that is, a complete path followed by the file name) for store, retrieve, and update operations, it's preferable to specify a relative file name. In AIX, HP-UX, or Solaris, a relative file name is any file name that does not begin with a slash; in OS/2 and Windows, a relative file name is any file name that does not begin with a drive letter followed by a colon and backslash.
If you specify a relative file name, the extenders will use the directory specifications in various client and server environment variables to resolve the file name. This allows files to be moved in a client/server environment without changing the file name. A fully qualified file name would have to be changed every time a file is moved.
The following table lists and describes environment variables that you can
set for use by the Image, Audio, and Video Extenders in resolving file
names.
Table 16. Environment variables for DB2 extenders
Image Extender | Audio Extender | Video Extender | Description |
---|---|---|---|
Server environment variables | |||
DB2IMAGEPATH | DB2AUDIOPATH | DB2VIDEOPATH | Used to resolve source file name for store, retrieve, and update operations from a server file. |
DB2IMAGESTORE | DB2AUDIOSTORE | DB2VIDEOSTORE | Used to resolve target file name for store and update operations to a server file. |
DB2IMAGEEXPORT | DB2AUDIOEXPORT | DB2VIDEOEXPORT | Used to resolve target file name for retrieve operations to a server file. |
DB2IMAGETEMP |
|
| Used to resolve target file name for operations that create temporary server files. However, if the TMP environment variable is specified, the directory TMP is used to resolve file names. |
Client environment variables | |||
DB2IMAGEPATH | DB2AUDIOPATH | DB2VIDEOPATH | Used to resolve source file name for display and play operations on a client file. |
DB2IMAGETEMP | DB2AUDIOTEMP | DB2VIDEOTEMP | Used to resolve target file name for operations that create temporary client files. However, if the TMP environment variable is specified, the directory TMP is used to resolve file names. |
If you don't set the appropriate environment variable for the specific
extender, the extender will use the following environment variables to resolve
file names:
Environment variable | Description |
---|---|
DB2MMPATH | Used to resolve source file name for store, retrieve, and update operations |
DB2MMSTORE | Used to resolve target file name for store and update operations |
DB2MMEXPORT | Used to resolve target file name for retrieve operations |
DB2MMTEMP | Used to resolve file name for operations that create temporary files |