Table of Contents

Search

  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. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

Linux, UNIX, and Windows DBMOVER Statements

Linux, UNIX, and Windows DBMOVER Statements

PowerExchange provides DBMOVER statements specific to the Linux, UNIX, and Windows operating systems.
The following table briefly defines the DBMOVER statements specific to the Linux, UNIX, and Windows operating systems and provides cross-references to the complete description of the statements:
Statement
Description
Reference
CAPT_PATH
Specifies the path to the local directory on a Linux, UNIX, and Windows system that contains the control files for CDC.
CAPT_XTRA
Specifies the path to the local directory on a Linux, UNIX, and Windows system that stores extraction maps for CDC.
CMDNODE
Linux, UNIX, and Windows. Specifies connection information for a PowerExchange process to which you want to send pwxcmd commands.
CONSOLE_CODEPAGE
Linux, UNIX, and Windows. Specifies the code page that PowerExchange uses to display message text on consoles.
CONSOLE_MSG
Specifies whether to write certain messages to the domain log in addition to writing them to the PowerExchange log file on the Integration Service machine.
FILEMAPPED_MEMORY_DIR
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.
LDAP_BASE
Specifies the location within an LDAP directory from which to conduct a PowerExchange user search.
LDAP_BIND_DN
Specifies the distinguished name (DN) of an LDAP user with sufficient access rights to connect to LDAP and conduct a search for the PowerExchange user.
LDAP_BIND_EPWD
Specifies the encrypted password for the LDAP search user.
LDAP_BIND_PWD
Specifies the password for the LDAP search user.
LDAP_BIND_TIMEOUT
Specifies the number of seconds that a PowerExchange Listener or Logger waits to authenticate a user against LDAP.
LDAP_FILTER
Specifies a filter to speed up or restrict the LDAP search for a PowerExchange user.
LDAP_HOST
Defines TCP/IP host details for any LDAP servers that PowerExchange might use for user validation.
LDAP_LOGIN_ATTRIBUTE
Specifies an LDAP attribute to use as a search key to match against a PowerExchange user ID.
LDAP_OPENSSL
Specifies Transport Layer Security (TLS) certificate information for a TLS connection to an LDAP server when PowerExchange is configured to use the OpenLDAP client.
LDAP_PORT
Defines the TCP/IP port for LDAP servers that PowerExchange might use for user validation.
LDAP_SASL_MECH
Specifies the authentication mechanism to be used for Simple Authentication and Security Layer (SASL) that is used with LDAP certificate-based security.
LDAP_SCOPE
Defines how deep to search in the LDAP tree within the search base in LDAP searches.
LDAP_SEARCH_TIMEOUT
Specifies the time, in seconds, that a PowerExchange Listener waits to receive a search result during PowerExchange user validation against LDAP.
LDAP_TLS
Specifies Transport Layer Security (TLS) certificate information for a TLS connection to an LDAP server when PowerExchange is configured to use the Oracle LDAP client.
LOG_CODEPAGE
Windows. Specifies the code page that PowerExchange uses to write messages to the log file.
LOGPATH
Linux, UNIX, and Windows. Defines the directory location where PowerExchange writes message log files on Linux, UNIX, and Windows systems.
TEMP_FILES_DIRECTORY
Linux, UNIX, and Windows. Specifies the directory location where PowerExchange writes temporary files if the TMPDIR or TMP environment variable is not set.
TEXT_EOF_FOR_BINARY
Linux, UNIX, and Windows. Controls whether PowerExchange ignores hexadecimal value 1A when reading binary flat files on Linux, UNIX, or Windows.
USE_DB_AUTH
When LDAP authentication is enabled, controls whether or not LDAP validation applies to relational connections.