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
  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. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

PowerExchange Data Source Tab

PowerExchange Data Source Tab

On the
PowerExchange Data Source
tab in the
PowerExchange Data Source
wizard, enter the following properties to define a PowerExchange ODBC data source:
Name
A name for the data source.
Corresponding ODBC Parameter: Entry in odbc.ini file
Location
The location of the data source.
The locations that appear in the
Location
list are defined by NODE statements in the PowerExchange dbmover.cfg configuration file on the local machine.
Corresponding ODBC Parameter: LOCATION
Type
The data source type.
If you use the DB2400C access method for a DB2 for i5/OS 7.2 source and specify SECURITY=(2,
x
) in the DBMOVER configuration file, bulk data movement operations that use ODBC fail with an SQL error. This restriction is related to an IBM change to the DB2 interface that the DB2400C access method uses. Use the DB2 access method or specify a different value for the first positional parameter in the SECURITY statement.
Corresponding ODBC Parameter: DBTYPE
Local Codepage
Code page to be used.
Default is
Default
, which causes the code page value in the PowerExchange dbmover.cfg configuration file or the default code page for the system to be used for the code page.
Database
For the MSSQL or ODBC data source type only, the name of the database.
Corresponding ODBC Parameters: For the MSSQL or ODBC data source type, DBQUAL2.
DB Qual2
For the CAPX or CAPXRT data source type only, the application name.
Corresponding ODBC Parameter: DBQUAL2
SSID or DBName
For the DB2, DB2UDB, or DB2400C data source type only, the DB2 SSID or database name.
Corresponding ODBC Parameter: DBQUAL1
Write Mode
For the DB2, DB2UDB, DB2400C, MSSQL, NRDB, NRDB2, ODBC, or ORACLE data source type only, the write mode.
Select one of the following options:
  • Confirm Write On
    . Enables confirm write. Ensures that data sent to the PowerExchange ODBC driver is immediately sent to, rather than buffered by, the PowerExchange Listener. Additionally, a success or no success response is sent, which improves error recovery. However, sending a response can slow data transfer rates.
  • Confirm Write Off
    . For DB2, DB2 UDB, and Oracle data sources only. Disables confirm write. Before using this setting, contact Informatica Global Customer Support.
  • Asynchronous With Fault Tolerance
    . Enables asynchronous write with fault tolerance. For more information about asynchronous write, see the
    PowerExchange Bulk Data Movement Guide
    .
Default is
Confirm Write On
.
Corresponding ODBC Parameter: CONFIRMWRITE
Reject File
If you select the
Asynchronous With Fault Tolerance
option in the
Write Mode
list, the location and file name of the reject file that is used during asynchronous write operations.
Maximum length is 384 characters. Enter a value of PWXDISABLE to disable reject file logging.
For more information, see the
PowerExchange Bulk Data Movement Guide
.
Corresponding ODBC Parameter: REJECTFILE
Stop On Errors
If you select the
Asynchronous With Fault Tolerance
option in the
Write Mode
list, the number of non-fatal errors that are allowed in the write phase before processing is terminated.
Valid values are from 0 to 2147483647.
For more information, see the
PowerExchange Bulk Data Movement Guide
.
Corresponding ODBC Parameter: STOPONERRORS
SSID
For the DB2390IMG data source type only, the DB2 SSID.
Corresponding ODBC Parameter: DBQUAL1
Wait Time
For the CAPXRT data source types only, the maximum approximate time, in seconds, to wait for data before returning end-of-file (EOF).
Specify one of the following options:
  • 0
    . The EOF is returned when the end of the current log is reached. The end of the log is determined at the start of the extraction process, because the actual end point constantly changes.
  • 2
    to
    86399
    . The number of seconds to wait for data before returning EOF.
  • 86400
    . The EOF is never returned. The job waits forever.
Corresponding ODBC Parameter: WAITTIME
DSN
For the MSSQL or ODBC data source type only, the DSN name.
Corresponding ODBC Parameter: DBQUAL1
SQL *Net Name
For the ORACLE data source type only, the SQL *Net name.
Corresponding ODBC Parameter: DBQUAL1