Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

DBMOVER Configuration File Statements

DBMOVER Configuration File Statements

The DBMOVER configuration file includes the following new and changed statements:
ADA_TIMEZONE_CHECK
New
. The ADA_TIMEZONE_CHECK statement controls whether PowerExchange issues the PWX-03206 message only once for each Adabas database that it accesses and that does not have an Adabas DD statement for timezone (//TZINFO DD) defined. PWX-03206 indicates that the Adabas DD statement for timezone (//TZINFO DD) was not found in the Adabas nucleus JCL.
Use the following syntax:
ADA_TIMEZONE_CHECK={N|
Y
}
Valid values:
  • N.
    PowerExchange issues PWX-03206 only once for each Adabas database that it tries to access that does not have an Adabas DD statement for timezone defined.
  • Y
    .
    PowerExchange issues a PWX-03206 message for each access to an Adabas database that does not have an Adabas DD statement for timezone defined.
Default is Y.
LDAP_OPENSSL
New
. The LDAP_OPENSSL statement enables LDAP secured connections between PowerExchange on Linux, UNIX, or Windows and the LDAP server. This statement also specifies certificate information for a Transport Layer Security (TLS) connection to the LDAP server.
If you are using the OpenLDAP client, define the LDAP_OPENSSL statement and specify OPEN_LDAP for the fourth positional parameter in the SECURITY statement.
If you are using the Oracle LDAP client, use the LDAP_TLS statement instead of the LDAP_OPENSSL statement.
Use the following syntax:
LDAP_OPENSSL=({CAPATH=
directory
|CAFILE=
filepath
} [,CERTFILE=
filepath
,KEYFILE=
filepath
] [,PASS=
passphrase
|EPASS=
encrypted_passphrase
] [,START_TLS={N|Y}] )
The LDAP_OPENSSL statement includes the following parameters:
CAPATH=
directory
Required if CAFILE is not specified. Directory where OpenSSL can find CA certificate files in PEM format.
CAFILE=
filepath
Required if CAPATH is not specified. File that contains one or more CA certificates in PEM format.
CERTFILE=
filepath
Optional. Client signing certificate. Include this parameter if the LDAP server is configured to require a signed certificate from its clients. The certificate and key files must be in PEM format. The certificate file must be named by the hash of the CA certificate.
KEYFILE=
filepath
Required if CERTFILE is specified. Client private key for signing its certificate. The certificate and key files must be in PEM format.
PASS=
passphrase
Optional. If the key file is DES-encrypted, the passphrase that is used to access the private key that is associated with the client certificate. Do not enter both the PASS and EPASS parameters.
EPASS=
encrypted_passphrase
Optional. If the key file is DES-encrypted, the encrypted passphrase that is used to access the private key that is associated with the client certificate. Do not enter both the PASS and EPASS parameters.
START_TLS={N|Y}
Optional. Controls whether PowerExchange uses the StartTLS extended LDAP operation to initiate secure network traffic on a normally unsecured port. Default is N.
LRAP CAPI_CONNECTION
The following new optional parameter can be specified in the LRAP CAPI_CONNECTION statement:
UIDFMTIMS={
UID
|PSB|ALL}
New
. For IMS synchronous CDC data sources, controls the type of value that PowerExchange uses to populate the generated DTL__CAPXUSER column in each change record. Options are:
  • UID
    . Returns the user ID of the user who made the IMS change.
  • PSB
    . Returns the IMS program specification block (PSB) name.
  • ALL
    . Returns both the user ID and PSB name in the format
    userid
    :
    psbname
    .
Default is UID.
This parameter is also available in 9.6.1 HotFix 4. It is not available in 10.0.
SECURITY
Changed
. The SECURITY statement has a new fourth positional parameter. The parameter has the following valid values:
{
ORACLE_LDAP
|OPEN_LDAP}
If you specify LDAP for the third positional parameter, specifies which set of LDAP client libraries to load.
Options are:
  • ORACLE_LDAP.
    PowerExchange loads the Oracle LDAP client libraries.
  • OPEN_LDAP.
    PowerExchange loads the OpenLDAP client libraries.
Default is ORACLE_LDAP.
For more information, see the "DBMOVER Configuration File" chapter in the
PowerExchange Reference Manual
.

0 COMMENTS

We’d like to hear from you!