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 2. Summary Report

When you run the PWXUCGRP utility with the REPORT_LEVEL=SUMMARY parameter setting, the report displays summary information for each capture registration.

The following command can be used to produce the example summary report:

C:\Informatica\PowerExchangev.r.m PWXUCRGP OUTPUT_FILE=.\Files\LOCAL\Summary_TABLE.txt LOCATION=local UID=user_name PWD=password REPORT_SEQUENCE=TABLE REPORT_LEVEL=SUMMARY DBTYPE=* INSTANCE=* STATUS=* CRNAME=*

The following example report shows the SUMMARY format, sorted by table name and with no filtering applied:

2017-12-12 11:49:31                  PWXUCRGP REPORT                  LOCAL
================================================================================

Output file          : .\Files\LOCAL\Summary_TABLE.txt
Location             : LOCAL

Report content
--------------
Report Sequence      : TABLE
Report Level         : SUMMARY

Filters for selecting Registrations
-----------------------------------
Database type        : *
Instance             : *
Status               : *
CR Name              : *

Registration Counts Summary
===========================

DB Type   Instance    Total | Active |  Part  None      
-------   --------    ----- | ------ |  ----  ----      
IDL       LOGSID          1 |      1 |     1     0      
                            |        |                  
MSS       CYRI000         6 |      6 |     6     0      
          RB02CYR         1 |      1 |     1     0      
MSS       *all*           7 |      7 |     7     0      
                            |        |                  
ORA       EL111DTL        1 |      1 |     1     0      
                            |        |                  
UDB       SAMPLE          3 |      3 |     3     0      
-------   --------    ----- | ------ |  ----  ----      
All       *all*          12 |     12 |    12     0      
-------   --------    ----- | ------ |  ----  ----      


DBTYPE=IDL      INSTANCE=LOGSID
===============================

CRNAME=aa         STATUS=A CNDSOPT=Part TAG=IDLLOGSIDaa1         TABLE=aaempss01.map1_INSURANCE_PLAN
----------------------------------------------------------------------------------------------------
User Name: 'ABCD'
Last Updated: '20161207173435'  VRM: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '13'
IDMS: SUBSCHEMA 'empdemo' BASEREC 'INSURANCE_PLAN' COMPRESS IND 'N' VARIABLE IND 'N'


DBTYPE=MSS      INSTANCE=CYRI000
================================

CRNAME=char1      STATUS=A CNDSOPT=Part TAG=MSSCYRI000char11     TABLE=dbo.testChar
-----------------------------------------------------------------------------------
Last Updated: '20101104113518'  VRM: 'V9.1.0'  Edit Sequence: '3'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=ntext1     STATUS=A CNDSOPT=Part TAG=MSSCYRI000ntext11    TABLE=dbo.testNText
------------------------------------------------------------------------------------
Last Updated: '20101104134524'  VRM: 'V9.1.0'  Edit Sequence: '3'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=nvarchar   STATUS=A CNDSOPT=Part TAG=MSSCYRI000nvarchar1  TABLE=dbo.NVarchar
---------------------------------------------------------------------------------------
Last Updated: '20101104134454'  VRM: 'V9.1.0'  Edit Sequence: '3'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=nchar1     STATUS=A CNDSOPT=Part TAG=MSSCYRI000nchar11    TABLE=dbo.Nchar
------------------------------------------------------------------------------------
Last Updated: '20101104134410'  VRM: 'V9.1.0'  Edit Sequence: '3'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=text1      STATUS=A CNDSOPT=Part TAG=MSSCYRI000text11     TABLE=dbo.Text
-----------------------------------------------------------------------------------
Last Updated: '20101104160450'  VRM: 'V9.1.0'  Edit Sequence: '4'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=varchar1   STATUS=A CNDSOPT=Part TAG=MSSCYRI000varchar11  TABLE=dbo.Varchar
--------------------------------------------------------------------------------------
Last Updated: '20101104113749'  VRM: 'V9.1.0'  Edit Sequence: '3'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'


DBTYPE=MSS      INSTANCE=RB02CYR
================================

CRNAME=alltype1   STATUS=A CNDSOPT=Part TAG=MSSRB02CYRalltype11  TABLE=dbo.alltypes
-----------------------------------------------------------------------------------
User Name: 'hrda'
Last Updated: '20170505095940'  VRM: 'V10.1.1'  Edit Sequence: '2'
Registration Type: 'SYNCHRONOUS'  Data Columns: '27'


DBTYPE=ORA      INSTANCE=EL111DTL
=================================

CRNAME=emp1       STATUS=A CNDSOPT=Part TAG=ORAEL111DTLemp11     TABLE=HRDA.EMP
-------------------------------------------------------------------------------
User Name: 'hrda'
Last Updated: '20161208122155'  VRM: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '8'


DBTYPE=UDB      INSTANCE=SAMPLE
===============================

CRNAME=rfact      STATUS=A CNDSOPT=Part TAG=UDBSAMPLErfact1      TABLE=MYDB.ACT
-----------------------------------------------------------------------------------
User Name: 'MYDB'
Last Updated: '20161205121009'  VRM: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'

CRNAME=adep       STATUS=A CNDSOPT=Part TAG=UDBSAMPLEadep1       TABLE=MYDB.ADEFUSR
---------------------------------------------------------------------------------------
Last Updated: '20161207093112'  VRM: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '2'

CRNAME=mydb0024   STATUS=A CNDSOPT=Part TAG=UDBSAMPLEmydb00241   TABLE=MYDB.BIN_INT_SRC
-------------------------------------------------------------------------------------------
Last Updated: '20161205121009'  VRM: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '2'

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

Example 2. Summary Report

Example 2. Summary Report