Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
PowerExchange for CDC and Mainframe
10.5.2
10.5.2
10.5.1
10.5
10.4.1
10.4.0 HotFix 1
10.4.0
10.2 HotFix 2
10.2 HotFix 1
10.2
H2L
Reference Manual
PowerExchange for CDC and Mainframe 10.5.2
PowerExchange for CDC and Mainframe 10.5.2
All Products
Rename Saved Search
Name
* This field is required
Overwrite saved search
Confirm Deletion
Are you sure you want to delete the saved search?
Table of Contents
Search
No Results
Preface
Introduction to PowerExchange
PowerExchange Overview
PowerExchange Components
DBMOVER Configuration File
DBMOVER Configuration File Overview
DBMOVER Statement Summary Tables
Summary of All DBMOVER Statements
Summary of Data Source-Specific DBMOVER Statements
Adabas DBMOVER Statements
CA IDMS/DB DBMOVER Statements
Db2 for IBM i DBMOVER Statements
DB2 for Linux, UNIX, and Windows DBMOVER Statements
DB2 for z/OS DBMOVER Statements
IMS DBMOVER Statements
Microsoft SQL Server DBMOVER Statements
MySQL DBMOVER Statements
Nonrelational DBMOVER Statements
Oracle DBMOVER Statements
PostgreSQL DBMOVER Statements
SAP HANA DBMOVER Statements
VSAM DBMOVER Statements
Summary of Operating System-Specific DBMOVER Statements
i5/OS DBMOVER Statements
Linux, UNIX, and Windows DBMOVER Statements
z/OS DBMOVER Statements
Syntax of DBMOVER Statements
Syntax Rules and Guidelines for DBMOVER Statements
Notational Conventions for DBMOVER Statements
DBMOVER Statements
ABEND_SW Statement
ADA_L3_ALLOW Statement
ADA_TIMEZONE_CHECK Statement
ADABAS_DEFAULT_DBID Statement
ADABAS_MU_SEARCH Statement
ADABAS_PREFIX Statement
ADABASCODEPAGE Statement
ADAOPT Statement
ADAOPTM Statement
ADAPREFETCH Statement
ADASTATS Statement
ADAUSER Statement
APPBUFSIZE Statement
APPBUFSIZEDYN Statement
AS400EVENTMSGQ Statement
AS400USRJRNCODE Statement
AS400USRMSGQ Statement
BS Statement
CAPI_CONN_NAME Statement
CAPI_CONNECTION - AS4J Statement
CAPI_CONNECTION - CAPX Statement
CAPI_CONNECTION - HANA Statement
CAPI_CONNECTION - LRAP Statement
CAPI_CONNECTION - MSQL Statement
CAPI_CONNECTION - MYSQL Statement
CAPI_CONNECTION - ORAD Statement
CAPI_CONNECTION - PG Statement
CAPI_CONNECTION - UDB Statement
CAPI_CONNECTION - UOWC Statement
CAPI_SRC_DFLT Statement
CAPT_PATH Statement
CAPT_XTRA Statement
CMDNODE Statement
CODEPAGE Statement
COLON Statement
COMPRESS Statement
CONSOLE_CODEPAGE Statement
CONSOLE_MSG Statement
CONSOLE_TRACE Statement
CONVCHAR Statement
CONVERT_CODEPAGES_WITH_ICONV Statement
CPX_DIR Statement
CREDENTIALS_CASE Statement
DATAMAP_SERVER Statement
DATERANGE Statement
DB2_BIN_AS_CHAR Statement
DB2_BIN_CODEPAGE Statement
DB2_ERRORFILE Statement
DB2CODEPAGE Statement
DB2DEF_ENCODING Statement
DB2ID Statement
DB2PLAN Statement
DECPOINT Statement
DEFAULTCHAR Statement
DEFAULTDATE Statement
DISABLE_PARTITIONS Statement
DISP Statement
DM_RESOURCE Statement
DM_SUBTASK Statement
DMXCACHE_DELETEECSA Statement
DMXCACHE_MAX_MEMORY_MB Statement
DMXCACHE_MULTIPLEJOBS Statement
DMX_DIR Statement
DTLMSG_CODEPAGE Statement
DTLMSG_LANGUAGE Statement
ENABLE_AUTOCOMMIT Statement
ENCRYPT Statement
ENCRYPTLEVEL Statement
ENQMAJORNAME Statement
ENQSYSTEMS Statement
ERRROWNOTFOUND Statement
EXT_CP_SUPPT Statement
FILEMAPPED_MEMORY_DIR Statement
GDGLOCATE Statement
GSBUFSIZE Statement
HOSTNAME Statement
IBMI_2ND_LEVEL_HELP
IBMI_SUPPRESS_OUTPUT
IBMI_USE_DB2_SYSTEM_COLUMN_NAMES
ICUALIAS Statement
ICUCNVPROPERTY Statement
ICUCONVERTER Statement
ICUDATADIR Statement
IMSBSDS Statement
IMSID Statement
JOBCLASS Statement
JOB_START_MINIMUM_MEMORY_MB Statement
LDAP_BASE Statement
LDAP_BIND_DN Statement
LDAP_BIND_EPWD Statement
LDAP_BIND_PWD Statement
LDAP_BIND_TIMEOUT Statement
LDAP_FILTER Statement
LDAP_HOST Statement
LDAP_LOGIN_ATTRIBUTE Statement
LDAP_OPENSSL Statement
LDAP_PORT Statement
LDAP_SASL_MECH Statement
LDAP_SCOPE Statement
LDAP_SEARCH_TIMEOUT Statement
LDAP_TLS Statement
LISTENER Statement
LOADCTLFILE Statement
LOADJOBFILE Statement
LOG_CODEPAGE Statement
LOG_LINE_LIMIT Statement
LOGPATH Statement
LOGSID Statement
LOWVALUES Statement
LRECL Statement
LU00FILE Statement
MAXTASKS Statement
MSSQL_SERVER_CONNECT_TIMEOUT Statement
MSSQL_SERVER_STATEMENT_TIMEOUT Statement
MSGPREFIX Statement
MSGPREFIX-HYPHEN Statement
MSS_ERRORFILE Statement
MVSDB2AF Statement
NEGSIGN Statement
NETPORT Statement
NODE Statement
NOGETHOSTBYNAME Statement
NRDB_WRITE_CHAR_NULL_FILL Statement
NRDB_WRITE_NUM_NULL_FILL Statement
NUMERICSIGN Statement
ODBASUPP Statement
ODBC_CONN_PARAMS Statement
OPENPOLL Statement
ORA_ERRORFILE Statement
ORACLE_CAPTURE_TYPE Statement
ORACLE_UNHANDLED_NUMASCHAR Statement
ORACLECODEPAGE Statement
ORACLEID Statement
OUSP Statement
PC_AUTH Statement
PIPE Statement
POLLTIME Statement
PRE861_COMPAT Statement
PRGIND Statement
PRGINT Statement
PWXSOMAXCONN Statement
QAQQINILIB Statement
RACF_CLASS Statement
RDBMSINSRTDFLT Statement
RECFM Statement
REJECT_FILE_DELIMITER Statement
RELEASE Statement
RMTRDBDIRE Statement
RMTSYSNAME Statement
SECURITY Statement
SECURITY_MSGSUPP Statement
SERVICE_TIMEOUT Statement
SESSID Statement
SHOW_THREAD_PERF Statement
SPACE Statement
SSL Statement
SSL_ALLOW_SELFSIGNED Statement
SSL_CIPHER_LIST Statement
SSL_CONTEXT_METHOD Statement
SSL_REQ_CLNT_CERT Statement
SSL_REQ_SRVR_CERT Statement
SSL_TOLERATE_UNTRUSTED_ISSUER Statement
START_UP_USER_EXIT Statement
STATS Statement
SUBMITTIMEOUT Statement
SUP_FUNC Statement
SUP_REQUEST Statement
SUP_SSNAME Statement
SUP_SSTYPE Statement
SUPPRESS_DATA_LOGGING Statement
SVCDUMP Statement
SVCNODE Statement
SYSOUT_TIMESTAMP Statement
TAPEWAIT Statement
TEMP_FILES_DIRECTORY Statement
TCPIP_ACCEPT_NONBLOCK Statement
TCPIP_DIAGNOSTICS_TRACE Statement
TCPIP_DIAGNOSTICS_TRACE_SZ Statement
TCPIP_SHOW_POOLING Statement
TCPIPBUFSIZE Statement
TCPIPVER Statement
TEMPHLQ Statement
TEXT_EOF_FOR_BINARY Statement
TIMEZONE Statement
TRACE Statement
TRACING Statement
UNIT Statement
UNLOGGED_ERROR_MESSAGES_DEST
UPDATE_USER_ACTIVITY Statement
USE_DB_AUTH Statement
USE_TYPE1_FALLBACKS Statement
USESUP Statement
VOLSER Statement
VSAM Statement
WAITDSN Statement
WORKCLASS Statement
WRT_ERROR_HANDLING Statement
Consumer API (CAPI) Connection Statements
Multiple CAPI Connections and Overrides
Order of Precedence for CAPI Statements and Overrides
Source-Specific CAPI_CONNECTION Statements
DBMOVER Statements for Commands Issued through the pwxcmd Program
Sample DBMOVER Configuration Files
Netport Jobs
Netport Jobs Overview
Configuring Netport Jobs
Sample Netport Jobs
Job Status Messages for Netport Jobs
PowerExchange Substitution Variables for Netport Jobs
Example of IMS SSID and PSB Substitution for an IMS Netport Job
Netport Jobs and Offload Processing
Netport Jobs and DB2 Bulk Data Loads
Using Netport Jobs for Generation Data Sets
Setting Up Netport Jobs for GDGs
PowerExchange Message Logs and Destination Overrides
PowerExchange Message Logs
PowerExchange Message Log File
PowerExchange Alternative Log Files
Determining the Size of the Alternative Log Data Sets on z/OS
Allocation Options for Alternative Log Data Sets on z/OS
PowerExchange Message Destination Overrides
DTLMSGO File and Statements
SMF Statistics Logging and Reporting
SMF Statistics Logging and Reporting Overview
Configuring Statistics Logging to SMF
Configuring Statistics Logging to a PowerExchange File
Generating Reports of SMF Statistics
Defining the Set of SMF Data Sets to Use for Reporting
Sample JCL for Generating Reports
Example Reports
Viewing Statistics Written to an SMF Data Set from the PowerExchange Navigator
Viewing Statistics Written to a PowerExchange File from the PowerExchange Navigator
SMF Record Format
Standard SMF Header with Subtype
SMF Triplet Section Descriptor
PowerExchange Header/Descriptor
Extended Section Descriptor
General Section
Extended Section for the PowerExchange Listener
Extended Section for the PowerExchange Client
Extended Section for Data Access
Function/Access Method Section (DB2)
SMF Record Layout
PowerExchange File Record Layout
PowerExchange Security
PowerExchange Security Overview
SECURITY Statement
i5/OS Security
Resource Access Requirements on i5/OS
Access Requirements for PowerExchange Jobs
Access Requirements for Journals and Files
Authorization to Run PowerExchange Listener Commands on i5/OS
User Authentication for the pwxcmd Program on i5/OS
Authorization to Run pwxcmd Commands on i5/OS
Linux, UNIX, and Windows Security
Authorization to Run PowerExchange Listener Commands on Windows
Authorization to Run pwxcmd and infacmd pwx Commands on Linux, UNIX, and Windows
User Authentication for the pwxcmd or infacmd pwx Programs on Linux, UNIX, and Windows
User Authentication on Linux and UNIX
User Authentication on Windows
z/OS Security
Resource Access Requirements on z/OS
Data Set Access Requirements for PowerExchange Jobs
Data Set Access Requirements for PowerExchange ECCRs
Security for Capture Registrations and Extraction Maps on z/OS
Data Set Level Security for Capture Registrations and Extraction Maps
RACF Class Security for Capture Registrations and Extractions Maps
Resources Profiles for Capture Registrations and Extraction Maps
Granting Access to Capture Registrations and Extraction Maps
Security for Capture Registrations and Extraction Maps - Examples
Security for Data Maps
Resource Profiles for Data Maps
Security for PowerExchange Listener Commands
Resources Profiles for PowerExchange Listener Commands
Adabas Security
Resource Profiles for Controlling Write Access to Adabas Files
Datacom Security
Resource Profiles for Controlling Read Access to Datacom Tables
DB2 for z/OS Security
IMS Security
Resource Profiles for Controlling Write Access to IMS Databases
User Authentication for the pwxcmd Program on z/OS
Authorization to Run pwxcmd Commands on z/OS
Preventing a PowerExchange User ID From Being Reported as Inactive
PowerExchange Passphrases
PowerExchange LDAP User Authentication
PowerExchange LDAP Authentication Components
Supported Environments for LDAP Authentication
Supported Platforms For LDAP Authentication
Supported LDAP Client Libraries
Supported LDAP Servers
LDAP Search User
Controlling the LDAP Search
LDAP Transport Layer Security
Levels of LDAP Security
LDAP StartTLS Extended Operation
LDAP Server Failover
Configuration Tasks
Setting Environment Variables
Summary of DBMOVER Statements for LDAP Configuration
Example DBMOVER LDAP Configurations
Example: Basic LDAP Configuration
Example: LDAP Configuration with a Filter and Login Attribute
Example: LDAP Configuration with Multiple Search Bases
Example: LDAP Configuration with Multiple Search Bases and a Filter
Example: LDAP Configuration with Failover
Example: Level 1 LDAP Security - Secure LDAP Configuration with Encryption and Server Authentication
Example: Level 2 LDAP Security - Secure LDAP Configuration with Client Authentication
Example: Level 3 LDAP Security - Secure LDAP Configuration with SASL External Authentication
Example: Level 1 LDAP Security - Secure LDAP Configuration with Encryption, Server Authentication, and StartTLS Extension
Example: Level 2 LDAP Security - Secure LDAP Configuration with Client Authentication and StartTLS Extension
Example: Level 3 LDAP Security - Secure LDAP Configuration with SASL External Authentication and StartTLS Extension
Example: Level 1 LDAP Security - Secure OpenLDAP Configuration with Encryption and Server Authentication
Example: Level 2 LDAP Security - Secure OpenLDAP Configuration with Client Authentication
Example: Level 3 LDAP Security - Secure OpenLDAP Configuration with SASL External Authentication
PowerExchange Selective Sign-on
Configuring PowerExchange Selective Sign-on
PowerExchange Sign-on File
PowerExchange Sign-on File Syntax
PowerExchange Sign-on File Statements
AUTHGROUP Statement
USER Statement
PowerExchange Sign-on File Examples
PowerExchange Selective Sign-on Examples
pwxcmd and infacmd pwx Command Authorization Examples
Secure Sockets Layer Support
SSL Security on a PowerExchange Network
PowerExchange SSL Architecture
FIPS 140-2 Compliance
FIPS 140-2 Compliant Cipher Suites
FIPS 140-2 Compliance Considerations on z/OS
PWXUGSK Utility
PWXUSSL Utility
PowerExchange SSL Configuration Steps
SSL Server Configuration on z/OS
Updating the AT-TLS Policy File
Setting Up the AT-TLS Infrastructure
Adding an AT-TLS Rule
Example AT-TLS Policy File for PowerExchange
Creating a Personal Certificate on z/OS
Configuring the PowerExchange Listener on the z/OS SSL Server
SSL Client and Server Configuration on Linux, UNIX, and Windows
OpenSSL in a PowerExchange SSL Environment
Creating a CA Certificate with OpenSSL
Creating a Personal Certificate with OpenSSL
Creating a Certificate By Using the z/OS RACDCERT Command
Customizing the DBMOVER Configuration File on the SSL Server
Customizing the DBMOVER Configuration File on the SSL Client
SSL Configuration on IBM i
Record Certificate Details
Creating a CA Certificate using IBM Navigator for i and IBM Digital Certificate Manager
Creating a Server or Client Certificate using IBM Navigator for i and IBM Digital Certificate Manager
Customizing the DBMOVER Configuration File on the SSL Server (IBM i)
Verifying Connections
PowerExchange Alternative Network Security
PowerExchange Alternative Network Security Overview
Modes of PowerExchange Encryption
PowerExchange Encryption Standard
AES Encryption Standard
Setting Encryption Defaults in the DBMOVER Configuration File
PowerExchange Nonrelational SQL
PowerExchange Nonrelational SQL Overview
PowerExchange Nonrelational SQL Syntax
SQL Syntax for a Basic Comparison
LIKE Comparison
BETWEEN Comparison
NULL Comparison
Allowed Keywords in the SQL Syntax
Accessing Data with Column Names the Same as SQL Keywords
Using SQL with User-Defined Fields
IMS Call Considerations
DTLDESCRIBE Metadata Syntax
DTLDESCRIBE TABLES Qualifier
DTLDESCRIBE TABLES Returned Information
DTLDESCRIBE PROCEDURES Qualifier
DTLDESCRIBE PROCEDURES Returned Information
DTLDESCRIBE PROCEDURECOLUMNS Qualifier
DTLDESCRIBE PROCEDURECOLUMNS Returned Information
DTLDESCRIBE COLUMNS Qualifier
DTLDESCRIBE COLUMNS Returned Information
DTLDESCRIBE RECORDS Qualifier
DTLDESCRIBE RECORDS Returned Information
DTLDESCRIBE PKEYS Qualifier
DTLDESCRIBE FKEYS Qualifier
DTLDESCRIBE FKEYS General Notes
DTLDESCRIBE FKEYS Table Information Retrieval
DTLDESCRIBE FKEYS Column Information Retrieval
DTLDESCRIBE FKEYS Primary Keys Information Retrieval
DTLDESCRIBE FKEYS Foreign Keys Information Retrieval
DTLDESCRIBE SCHEMAS Qualifier
DTLDESCRIBE Qualifiers
DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources
DTLDESCRIBE Qualifiers for DB2 for z/OS Sources
DTLDESCRIBE Qualifiers for DB2 for Linux, UNIX, and Windows Sources
DTLDESCRIBE Qualifiers for NRDB Sources
DTLDESCRIBE Qualifiers for NRDB2 Sources
DTLDESCRIBE Qualifiers for Oracle Sources
Restrictions on PowerExchange Nonrelational SQL
Truncating a Target Table
Inserting Rows into a Table
PowerExchange Globalization
PowerExchange Globalization Overview
Default Code Pages Installed with PowerExchange
General Code Pages Available with PowerExchange
Source-Specific Code Pages
How PowerExchange Determines Internal Code Page Numbers by Data Source
DB2 for i5/OS Code Page Parameters
DB2_BIN_AS_CHAR Statement
DB2_BIN_CODEPAGE Statement
DB2 for z/OS Code Page Parameters
DB2CODEPAGE Statement Usage
DB2CODEPAGE Statement Examples
Oracle Code Page Parameters
User-Defined Code Pages
Adding User-Defined ICU-Compatible Code Pages
Creating the UCM File
Running the ICU makeconv Utility
Adding a Custom ICU Code Page
Viewing Data from the PowerExchange Navigator
PowerExchange Static Code Pages
Determining How the External Code Page File Is Specified
ICUCHECK Utility
ICUCHECK Syntax
Report 1. Power Exchange Control Table for Simple Code Pages
Report 2. PowerExchange Control Table for ICU Code Pages
Creating a Custom ICU Code Page
PowerExchange Control Table for ICU Code Pages Sample Report
Report 3. Comparing Name and Character Size Information with ICU
Report 4. Comparing ICU Code Page Information with PowerExchange
Report 5. PowerExchange Code Page Names and Aliases
Report 6. PM Locale Code Pages
Report 7. Control Counts
Report 8. Errors
Code Pages Shipped with PowerExchange
PowerExchange Static Code Pages
Code Pages That Handle All Supported Unicode Characters
Code Pages Based on ASCII Encoding
ICU Code Pages Based on EBCDIC Encoding
Specialized ICU Code Pages
Handling Conversion Errors and Special Situations
Code Page Conversion Errors
Unexpected Data in a Code Page
Example 1. Using ICUALIAS to Remap CCSID 37 to Thai 878
Example 2. Using DB2 Data Maps to Remap CCSID 37 to Thai CCSID 87
Type 1 Fallback Mappings and Multibyte Data
Using the PowerExchange ODBC Drivers
PowerExchange ODBC Driver Overview
PowerExchange ODBC Data Sources on Windows
Creating an ODBC Data Source on Windows
Creating an ODBC Data Source on Windows to Be Used with the PowerExchange ODBC Unicode Driver
Updating PowerExchange ODBC Data Sources on Windows
PowerExchange Data Source Wizard Properties
PowerExchange Data Source Tab
General Tab
AS/400 Properties Tab
CAPX Properties Tab
CAPXRT Properties Tab
DB2/S390 Bulk Load Properties Tab
PowerExchange ODBC Data Sources on Linux or UNIX
Example PowerExchange Data Source Specifications
Accessing Multibyte Metadata with ODBC
PowerExchange ODBC Driver Data Source Parameters
General PowerExchange ODBC Driver Parameters
PowerExchange ODBC Driver for DB2 for z/OS Bulk Parameters
SQL Escape Sequences
SQL Escape Sequences with PowerCenter
SQL Escape Sequences Available in PowerCenter
{DTLADAPREFETCH=Y|N} Escape Sequence
{DTLADAPWD= } Escape Sequence
{DTLAPP= } Escape Sequence
{DTLARRAYSIZE= } Escape Sequence
{DTLCONFWRITE=N|Y|T} Escape Sequence
{DTLCONNOVR= } Escape Sequence
{DTLDATAPWD= } Escape Sequence
{DTLDB2DEGREE= } Escape Sequence
Using DTLDB2DEGREE on DB2 for z/OS
Using DTLDB2DEGREE on DB2 for i5/OS
{DTLDSN= } Escape Sequence
{DTLEVENTTB= } Escape Sequence
{DTLFILELIST=Y|N} Escape Sequence
{DTLIMTYPE=BA|AI|TU} Escape Sequence
{DTLIMGOV=Y|N} Escape Sequence
{DTLINSMODE=LOAD|UPDATE} Escape Sequence
{DTLJRNL= } Escape Sequence
{DTLLIBRARYLIST= } Escape Sequence
{DTLLOGSID=} Escape Sequence
{DTLMODELDCB=} Escape Sequence
{DTLNOUPDATECDEP=Y|N} Escape Sequence
{DTLORACOLL= } Escape Sequence
{DTLORACONN= } Escape Sequence
{DTLORAINST= } Escape Sequence
{DTLORASCHEMA= } Escape Sequence
{DTLOVRDBF= } Escape Sequence
{DTLREJECTFILE= } Escape Sequence
{DTLSESSID=} Escape Sequence
{DTLSTOPONERRORS =} Escape Sequence
{DTLSTRIPORDERBY=Y|N} Escape Sequence
{DTLTIMEOUT= } Escape Sequence
{DTLUDBDB= } Escape Sequence
{DTLUPDELSEINS=Y} Escape Sequence
{DTLUSECATALOGMETADATA=Y|N} Escape Sequence
{DTLWORKERS= } Escape Sequence
{DTLXTRASCHEMA= } Escape Sequence
{DTLXTYPE=RS|SL} Escape Sequence
PowerExchange Datatypes and Conversion Matrix
PowerExchange Datatype Conversions
ODBC and PowerExchange Datatype Equivalencies
Appendix A: DTL__CAPXTIMESTAMP Time Stamps
Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source
Appendix B: PowerExchange Glossary
Glossary of Terms
access method
active logs
after image
Agent
APF
application group
application name
application service
Application Transparent - Transport Layer Security (AT-TLS) file
archive logs
asynchronous capture
asynchronous write
authorized program facility (APF)
batch extraction mode
Batch Message Processing (BMP)
before image
BMP
bulk data extraction
CAPI
CAPI connection
CAPTPARM configuration member
capture catalog table
capture directory tables
capture registration
CAPX
CAPXRT
CCT
CDC
CDCT file
CDEP file
change data capture (CDC)
change stream
checkpoint files
CmdPrefix
commit record
complex table
Condense
condense files
consumer API (CAPI)
continuous extraction mode
cross-system coupling facility (XCF)
data extraction
data map
data replication
data source
data target
datatype conversion
DBMOVER configuration file
DTLCCADW utility
DTLCUIML utility
DTLINFO utility
DTLMSG file
DTLREXE utility
DTLUAPPL utility
DTLUCBRG utility
DTLUCDEP utility
DTLUCSR2 utility
DTLUCUDB utility
DTLULCAT and DTLULOGC utilities
DTLURDMO utility
DTLUTSK utility
ECCR
EDMC
EDMLUCTR utility
EDMMSG data set
EDMNAME
EDMSDIR options module
EDMUOPTS utility
EDMUPARM options module
EDMXLUTL utility
emergency restart data set (ERDS)
encryption mode
end-UOW
Environmental Change Capture Routine (ECCR)
ERDS
error action file
event marker
extended recovery facility (XRF)
extraction
extraction group
extraction map
extraction mode
Flexible Target Key Custom Transformation
full condense
group definition file
group source processing
group target processing
HOSTENT utility
ICU
in-doubt UOWs
International Component for Unicode (ICU)
key range partitioning
listener
local mode
location
Log Read API (LRAPI)
Log Write API (LWAPI)
log-based capture
Logger
logger token
logical partition (LPAR)
LRAPI
LWAPI
makeconv utility
materialization
message destination override
MUFplex
Navigator
near real time
netport job
node
nonrelational source
nonrelational target
normalization
ODBC
Open Database Connectivity (ODBC)
open UOW
partial condense
pass-through partitioning
personal metadata
Post-Log Merge
PowerExchange Agent
PowerExchange Call Level Interface (SCLI)
PowerExchange Change Data Capture (CDC)
PowerExchange client
PowerExchange Client for PowerCenter (PWXPC)
PowerExchange Condense
PowerExchange Condense group definition file
PowerExchange Listener
PowerExchange Logger for Linux, UNIX, and Windows
PowerExchange Logger for z/OS
PowerExchange Logger group definition file
PowerExchange Navigator
PWXCCL configuration file
PWXPC
PWXUCDCT utility
PWXUCREG utility
PWXUCRGP utility
PWXUDMX utility
PWXUGSK utility
PWXUMAP utility
PWXUSSL utility
reader partitioning
real time
real-time extraction mode
register
registration group
registration tag
reject file
relational source
relational target
replication
repository
restart tokens
row test
schema
SCLI
sequence token
Shadow MUF
simple table
source
SQL escape sequence
synchronization
synchronous capture
synchronous write
tag
target
unit of work (UOW)
UOW
UOW Cleanser
UOW spill file
UOWC
writer partitioning
XCF
XRF
Reference Manual
Reference Manual
10.5.2
10.5.1
10.5
10.4.1
10.4.0 HotFix 1
10.4.0
10.2 HotFix 2
10.2 HotFix 1
10.2
Back
Next
Modes of PowerExchange Encryption
Modes of PowerExchange Encryption
PowerExchange alternative network security supports the following modes of data encryption when moving data:
No encryption
PowerExchange encryption
AES encryption
PowerExchange Alternative Network Security
PowerExchange Encryption Standard
AES Encryption Standard
Updated May 17, 2022
Download Guide
Send Feedback
Resources
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next