Preface
Introduction to PowerExchange Utilities
- PowerExchange Utilities Overview
- PowerExchange Utilities by Operating System
- PowerExchange Utilities Syntax Conventions
- Environment Variable Incompatibilities Between PowerExchange and PowerCenter
  - Setting the PowerExchange Environment and Starting a Utility
- PowerExchange Sample JCL
createdatamaps - Data Map Creation Utility
- createdatamaps Utility Overview
- Requirements and Considerations for COBOL Copybooks and DBDs
- createdatamaps Command Syntax
- Creating, Editing, and Testing a Data Map
- Control Files for Data Map Generation
  - Rules for Control Files
  - Control File Structure
- Schema File for Describing Control Files
- Schema File Reference
- Log File for Data Maps Creation Utility
  - JAXB Error Messages
- Redefinitions and Record IDs in COBOL Copybooks
- Copybook and DBD Metadata for IMS Data Maps
- Column Name Filters
- Unavailable Data Map Properties
- Examples
DTLCCADW - Adabas PCAT Utility
- DTLCCADW Utility Overview
- DTLCCADW Utility Functions
DTLCUIML - IMS Log Marker Utility
- DTLCUIML Utility Overview
- DTLCUIML Utility Parameters
- DTLCUIML Utility Reports
DTLINFO - Release Information Utility
- DTLINFO Utility Overview
- Supported Operating Systems for the DTLINFO Utility
- Control Statement Syntax for the DTLINFO Utility
- Control Statement Parameters for the DTLINFO Utility
- Running the DTLINFO Utility on i5/OS
- Running the DTLINFO Utility on Linux, UNIX, and Windows
- Running the DTLINFO Utility on z/OS
- DTLINFO Utility on i5/OS Examples
  - DTLINFO Utility on i5/OS - Example 1
  - DTLINFO Utility on i5/OS - Example 2
- DTLINFO Utility on Linux, UNIX, and Windows Examples
  - DTLINFO Utility on Linux, UNIX, and Windows - Example 1
  - DTLINFO Utility on Linux, UNIX, and Windows - Example 2
- DTLINFO Utility on z/OS Examples
  - DTLINFO Utility on z/OS - Example 1
  - DTLINFO Utility on z/OS - Example 2
DTLREXE - Remote Execution Utility
- DTLREXE Utility Overview
- Supported Operating Systems for the DTLREXE Utility
- Control Statement Syntax for the DTLREXE Utility
- Control Statement Parameters for the DTLREXE Utility
- Running the DTLREXE Utility on i5/OS
- Running the DTLREXE Utility on Linux and UNIX
- Running the DTLREXE Utility on Windows
- Running the DTLREXE Utility on z/OS
- DTLREXE Utility Usage Notes
- DTLREXE Utility on z/OS Example
  - DTLREXE Utility on z/OS Example JCL
  - DTLREXE Utility on z/OS Output Data Set
DTLUAPPL - Restart Token Utility
- DTLUAPPL Utility Overview
- Supported Operating Systems for the DTLUAPPL Utility
- DTLUAPPL Control Statement Syntax
- Connection Statement
- ADD and MOD Statements
- END APPL Statement
- PRINT APPL Statement
- Running the DTLUAPPL Utility on i5/OS
- Running the DTLUAPPL Utility on Linux, UNIX, and Windows
- Running the DTLUAPPL Utility on z/OS
- DTLUAPPL Utility Examples
DTLUCBRG - Batch Registration Utility
- DTLUCBRG Utility Overview
- Supported Operating Systems for the DTLUCBRG Utility
- DTLUCBRG Utility Parameters
- DTLUCBRG Code Page Processing
  - Code Page Processing for DB2 Registrations in Local Mode on z/OS
- Running the DTLUCBRG Utility
- DTLUCBRG Utility Example Reports
  - DTLUCBRG Utility with RPTCOLS=N Report Description
  - DTLUCBRG Utility with RPTCOLS=Y Report Description
- DTLUCBRG Utility Usage Notes
DTLUCDEP - CDEP Maintenance Utility
- DTLUCDEP Utility Overview
- Supported Operating Systems for the DTLUCDEP Utility
- Control Statement Syntax for the DTLUCDEP Utility
- Control Statement Parameters for the DTLUCDEP Utility
  - CDEP Definition Examples
- Running the DTLUCDEP Utility on i5/OS
- Running the DTLUCDEP Utility on Linux, UNIX, and Windows
- Running the DTLUCDEP Utility on z/OS
- DTLUCDEP Utility on i5/OS Example
- DTLUCDEP Utility on Linux, UNIX, and Windows Example
- DTLUCDEP Utility on z/OS Example
DTLUCSR2 - IDMS SR2 and SR3 Records Utility
- DTLUCSR2 Utility Overview
- Running the DTLUCSR2 Utility
DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
- DTLUCUDB Utility Overview
- Running the DTLUCUDB Utility
  - DTLUCUDB Utility Syntax
  - Command Options for the DTLUCUDB Utility
- Gathering Diagnostic Information to Resolve a DB2 Capture Problem
DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
- DTLULCAT and DTLULOGC Utilities Overview
- Running the DTLULCAT Utility
- Running the DTLULOGC Utility
- Manually Manipulating the Log Catalog
- Guidelines for Adding Logs to the Catalog with the DTLULCAT and DTLULOGC Utilities
DTLURDMO - Data Map Utility
- DTLURDMO Utility Overview
- Supported Operating Systems for the DTLURDMO Utility
- Control Statement Overview for the DTLURDMO Utility
- Control Statement Syntax for the DTLURDMO Utility
- Control Statements and Parameters for the DTLURDMO Utility
- Scope of Operands
- Running the DTLURDMO Utility on i5/OS
- Running the DTLURDMO Utility on Linux, UNIX, and Windows
- Running the DTLURDMO Utility on z/OS
- DTLURDMO Control Statement Examples
- DTLURDMO Report Examples
DTLUTSK - Task Control Utility
- DTLUTSK Utility Overview
- DTLUTSK Command Line Utility on i5/OS
- DTLUTSK Command Line Utility on Linux, UNIX, and Windows
  - Displaying DTLUTSK Utility Help
- DTLUTSK Job on z/OS
  - Example JCL for a DTLUTSK Job on z/OS
  - Example Output from a DTLUTSK Job on z/OS
- DTLUTSK Command Line Utility on z/OS
- Running the DTLUTSK Utility in the PowerExchange Navigator
- DTLUTSK Utility Security
EDMLUCTR - Log Scan and Print Utility
- EDMLUCTR Utility Overview
- Supported Operating Systems for the EDMLUCTR Utility
- Control Statement Syntax for the EDMLUCTR Utility
- Control Statement Parameters for the EDMLUCTR Utility
  - -SEL Statement
  - -MASK Statement
- Running the EDMLUCTR Utility
- EDMLUCTR Utility Usage Notes
- EDMLUCTR Utility Examples
EDMXLUTL - Event Marker Utility
- EDMXLUTL Utility Overview
- Creating an Event Marker in Batch Mode
- EDMXLUTL Utility JCL Statements
- EDMXLUTL Utility Control Statements
- EDMXLUTL Utility EVENT Command
  - EVENT Command Syntax
  - EVENT Command Usage
- Keyword Sets for the BASEEDM Category
  - MARK Keyword Set
  - NOTIFY Keyword Set
- EDMXLUTL Utility Example
HOSTENT - TCP/IP Address Reporter Utility
- HOSTENT Utility Overview
- Supported Operating Systems for the HOSTENT Utility
- Running the HOSTENT Utility on i5/OS
- Running the HOSTENT Utility on Linux and UNIX
- Running the HOSTENT Utility on z/OS
- HOSTENT Utility Usage Notes
  - HOSTENT Utility Resolver Details
- HOSTENT Utility Output
- HOSTENT Utility on i5/OS Example
- HOSTENT Utility on Linux and UNIX Example
- HOSTENT Utility on z/OS Example
PWXCATMY - MySQL Catalog Utility
- PWXCATMY Utility Overview
- Supported Operating Systems for the PWXCATMY Utility
- PWXCATMY Operation Types
- Command Syntax and Parameters
PWXUCCLPRT - Print Log Summary Utility
- PWXUCCLPRT Utility Overview
- Supported Operating Systems for the PWXUCCLPRT Utility
- Command Syntax for the PWXUCCLPRT Utility
- PWXUCCLPRT Utility Parameters
  - PWXUCCLPRT INPUT Statement Parameters
  - PWXUCCLPRT OUTPUT Statement Parameters
- Example PWXUCCLPRT Parameter File
- Examples of PWXUCCLPRT Output
PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
- PWXUCDCT Utility Overview
- Supported Operating Systems for the PWXUCDCT Utility
- Control Statement Syntax for PWXUCDCT Commands
- PWXUCDCT Commands and Parameters
  - Commands
  - Parameter Descriptions
- Running the PWXUCDCT Utility
- Usage Notes for the PWXUCDCT Utility
- Examples of PWXUCDCT Utility Commands
PWXUCREG - Capture Registration Suspend Utility
- PWXUCREG Utility Overview
- PWXUCREG Usage Considerations
- Supported Operating Systems for the PWXUCREG Utility
- Suspending Change Capture for Registered Sources Temporarily
- General Syntax for PWXUCREG Commands
- Summary of PWXUCREG Commands
- Global SET_CONTROL_VALUE Parameters
- Registration-specific Command Parameters
- Running the PWXUCREG Utility
- Examples of PWXUCREG Utility Commands
  - Example 1. Suspending a Capture Registration
  - Example 2. Reactivating a Capture Registration
PWXUCRGP - Capture Registrations Print Utility
- PWXUCRGP Utility Overview
- Supported Operating Systems for the PWXUCRGP Utility
- Control Statement Syntax for the PWXUCRGP Utility
- PWXUCRGP Parameters
- Running the PWXUCRGP Utility
- PWXUCRGP Report Levels of Detail
- Examples of PWXUCGRP Reports
PWXUDMX - Data Maps Update Time ECSA Memory Utility
- PWXUDMX Utility Overview
- Supported Operating Systems for the PWXUDMX Utility
- Running the PWXUDMX Utility on z/OS
- PWXUDMX Commands and Parameters
PWXUGSK - SSL Reporting Utility for z/OS
- PWXUGSK Utility Overview
- Supported Operating Systems for the PWXUGSK Utility
- PWXUGSK Control Statement Syntax
- PWXUGSK Commands and Parameters
- Running the PWXUGSK Utility
- PWXUGSK Utility Reports
PWXUMAP - Map List Utility
- PWXUMAP Utility Overview
- Supported Operating Systems for the PWXUMAP Utility
- General Syntax for the PWXUMAP Utility
- PWXUMAP Commands and Parameters
- Running the PWXUMAP Utility
- Examples of PWXUMAP Reports
- PWXUMAP Utility Usage Notes
PWXUSSL - PowerExchange SSL Reporting Utility
- PWXUSSL Utility Overview
- Supported Operating Systems for the PWXUSSL Utility
- Control Statement Syntax for PWXUSSL Commands
- PWXUSSL Commands and Parameters
- Running the PWXUSSL Utility
- PWXUSSL Utility Reports

Utilities Guide

10.4.0
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

Example 6. Printing the CDCT File Contents

Informatica Global Customer Support requests that you print the CDCT file contents and send it to them in a text file for debugging use.

From the command line, navigate to the PowerExchange installation directory and enter the following command:

pwxucdct cmd=report_cdct >C:\Informatica\PowerExchangev.r.m\reports\cdct_debug.txt cs=C:\Informatica\PowerExchangev.r.m\resources\pwxccl_orcl.cfg

To print the information to a file, include a greater than (>) sign followed by the output path and file name. Otherwise, the information is displayed on screen.

Review the report contents.

The following example report shows the CDCT contents for a PowerExchange Logger with only one group:

DTL-33314 TIMEOUTS configuration parameter is deprecated
DTL-25404 Processing console program. PWXUCDCT cs=C:\Informatica\PowerExchange\v.r.m\resources\capt\pwxccl_ORCL.cfg CMD=REPORT_CDCT 
--------------------------------------------------------------------------------
------------------------------   CCL INCARNATION  ------------------------------
--------------------------------------------------------------------------------
Incarnation: 20141217080907000000
             Instance Name:       ORCL
             Image Type:          Before and After Images
             Group Count:         1
             Status:              Current
             Create Rsn:          Cold Start
             File Encryption:     AES256 

Restart Information:   Sequence                                                                   Restart              Timestamp           
Begin                  D40000007B0198000000000000000000000000000000000000000000000000000000000000 0000007B0198D35844C4 20141217080913000000
End                    D40000007CFC67000000000000FFFFFFFFFFFFFFFFFFFF0000016D000046300108FFFF0000 0000007CFC66D35844C4 20141217102535000000

--------------------------------------------------------------------------------
------------------------------      CCL GROUP     ------------------------------
--------------------------------------------------------------------------------
Incarnation: 20141217080907000000 Group #: 0
             Name:                DEFAULT
             File Prefix:         C:\Informatica\PowerExchangev.r.m\resources\ccl\group1\grp2
             Reg Count:           6
             File Count:          4
             Status:              Active
             First File Seq:      1412170809001
             Current File Seq:    1412171025001
             Oldest File TStamp:  20141217080942000000

--------------------------------------------------------------------------------
---------------------------   CCL REGISTRATIONS   ------------------------------
--------------------------------------------------------------------------------
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 5
             Name:                ORAORCLbonus1
             Status:              Active
             Activation Date:     20141217102409000000
             Inactivation Date:   
             Default Schema:      ORAAUS1
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 4
             Name:                ORAORCLdatetime1
             Status:              Active
             Activation Date:     20141217080907000000
             Inactivation Date:   
             Default Schema:      ORAAUS1
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 3
             Name:                ORAORCLdept1
             Status:              Active
             Activation Date:     20141217080907000000
             Inactivation Date:   
             Default Schema:      ORAAUS1
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 2
             Name:                ORAORCLemp1
             Status:              Active
             Activation Date:     20141217080907000000
             Inactivation Date:   
             Default Schema:      ORAAUS1
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 1
             Name:                ORAORCLempencr1
             Status:              Active
             Activation Date:     20141217080907000000
             Inactivation Date:   
             Default Schema:      ORAAUS1
Incarnation: 20141217080907000000 Group #: 0 Reg Seq#: 0
             Name:                ORAORCLtable11
             Status:              Active
             Activation Date:     20141217080907000000
             Inactivation Date:   
             Default Schema:      ORAAUS1

--------------------------------------------------------------------------------
------------------------------      CCL FILES     ------------------------------
--------------------------------------------------------------------------------
Incarnation: 20141217080907000000 Group #: 0 File Seq#: 1412170809001
             Name:                C:\Informatica\PowerExchangev.r.m\\resources\ccl\group1\grp0.CND.CP141217.T0809001 resources\ccl\group1\
             Open TimeStamp:      20141217080917000000
             Close TimeStamp:     20141217080942000000
             Record Count:        180
             Commit Count:        20
             Has Uncommitted data No
             Is encrypted:        Yes
             Status:              Closed
             Fmt Version:         961
             Encryption Key Test: 277790D3E372B2623D2CFD98FF2ACD62FC92A267D2095013C7FC2D3C44339F6E

Restart Information:   Sequence                                                                   Restart              Timestamp           
Begin:                 D40000007BC97C0000000000000000007BC97B00000000000001680000B64E001000020000 0000007BC97BD35844C4 20141215150331000000
End:                   D40000007CE166000000000000FFFFFFFFFFFFFFFFFFFF0000016D000011D30084FFFF0000 0000007CE165D35844C4 20141217080931000000

Incarnation: 20141217080907000000 Group #: 0 File Seq#: 1412170809002
             Name:                C:\Informatica\PowerExchangev.r.m\\resources\ccl\group1\grp0.CND.CP141217.T0809002
             Open TimeStamp:      20141217080950000000
             Close TimeStamp:     20141217081055000000
             Record Count:        36
             Commit Count:        4
             Has Uncommitted data No
             Is encrypted:        Yes
             Status:              Closed
             Fmt Version:         961
             Encryption Key Test: 277790D3E372B2623D2CFD98FF2ACD62FC92A267D2095013C7FC2D3C44339F6E

Restart Information:   Sequence                                                                   Restart              Timestamp           
Begin:                 D40000007CE1710000000000000000007CE170000000000000016D000011DC001000020000 0000007CE170D35844C4 20141217080948000000
End:                   D40000007CE189000000000000FFFFFFFFFFFFFFFFFFFF0000016D000011F7008CFFFF0000 0000007CE188D35844C4 20141217081032000000

Incarnation: 20141217080907000000 Group #: 0 File Seq#: 1412170811001
             Name:                C:\Informatica\PowerExchangev.r.m\resources\ccl\group1\grp0.CND.CP141217.T0811001
             Open TimeStamp:      20141217081102000000
             Close TimeStamp:     20141217081117000000
             Record Count:        36
             Commit Count:        4
             Has Uncommitted data No
             Is encrypted:        Yes
             Status:              Closed
             Fmt Version:         961
             Encryption Key Test: A2649CDC44DB6CF714E0739CB1F9FCD035CC834E90AB3E2059F7BBEC41D62742

Restart Information:   Sequence                                                                   Restart              Timestamp           
Begin:                 D40000007CE1980000000000000000007CE197000000000000016D000011FA001000020000 0000007CE197D35844C4 20141217081101000000
End:                   D40000007CE19D000000000000FFFFFFFFFFFFFFFFFFFF0000016D0000120A01E8FFFF0000 0000007CE19CD35844C4 20141217081101000000

Incarnation: 20141217080907000000 Group #: 0 File Seq#: 1412171025001
             Name:                C:\Informatica\PowerExchangev.r.m\resources\ccl\group1\grp0.CND.CP141217.T1025001
             Open TimeStamp:      20141217102522000000
             Close TimeStamp:     20141217102605000000
             Record Count:        1
             Commit Count:        1
             Has Uncommitted data No
             Is encrypted:        Yes
             Status:              Closed
             Fmt Version:         961
             Encryption Key Test: CB9202C5D9D0E01CAA57C0128D6244C2964AAEB866613EA0C7E3EE5151C3C255

Restart Information:   Sequence                                                                   Restart              Timestamp           
Begin:                 D40000007CFC610000000000000000007CFC60000000070000016D00004624001000020000 0000007CFC60D35844C4 20141217102520000000
End:                   D40000007CFC67000000000000FFFFFFFFFFFFFFFFFFFF0000016D000046300108FFFF0000 0000007CFC66D35844C4 20141217102535000000

The report contains separate sections for the PowerExchange Logger (CCL) configuration incarnation, the groups that are defined in the group definition file that is specified in the pwxccl.cfg configuration file, the capture registrations for the tables, and the associated Logger log files. In the CCL Files section, the information that is reported for each log file includes whether the log file is encrypted and the restart tokens.

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

Example 6. Printing the CDCT File Contents

Example 6. Printing the CDCT File Contents