Reference Manual

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

FILEMAPPED_MEMORY_DIR Statement

The FILEMAPPED_MEMORY_DIR statement specifies the directory that stores temporary file-mapped memory files for PowerExchange Listener statistics on AIX PPC64, i5/OS (IBM i), and Solaris SP64 systems.

If you set the STATS statement to MONITOR in the DBMOVER configuration file, the memory statistics are generated when either the optional monitoring interval in the MONITOR parameter elapses or when you issue the DISPLAYSTATS or pwxcmd displaystats command.

Informatica strongly recommends that you use this statement to specify a directory that is dedicated to the storage of temporary file-mapped memory files for PowerExchange Listener statistics. Specify a directory that is on a locally mounted disk for better performance and to avoid complications that might result from network mountings, such as name clashes, disk usage problems, and the unnecessary inclusion of NFS files.

All

STATS

Required for AIX and IBM i

FILEMAPPED_MEMORY_DIR=path/directory

For operating systems where the FILEMAPPED_MEMORY_DIR statement is optional, temporary file-mapped memory statistics files are written to the current directory of the user, or if the current directory is not available, to the root directory of the file system. On IBM i, the installer defaults this value to /tmp.

Monitor the directory that the FILEMAPPED_MEMORY_DIR statement specifies. On AIX, you can use the

command to delete the files that are not being used by an active PowerExchange process. On IBM i, you can use the

command if you run the

STRQSH

command, which enables you to issue UNIX commands.

If you cancel a Listener task by using an operating system command such as

ENDJOB *IMMED

kill -9

, the memory-mapped files are orphaned.

DBMOVER Statements

Download Guide

Watch