Table of Contents


  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary



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.
Required for AIX and IBM i
  • 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
    command, which enables you to issue UNIX commands.
  • If you cancel a Listener task by using an operating system command such as
    kill -9
    , the memory-mapped files are orphaned.


We’d like to hear from you!