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

EDMLUCTR Utility - Example 1

The following JCL statements print summary data for all log records, starting with the RBA recorded in the ERDS at the time the latest PowerExchange Logger checkpoint was taken:

//         JOB
//READER   EXEC PGM=EDMLUCTR
//STEPLIB  DD   DISP=SHR,DSN=hlq.LOAD
//ERDS01   DD   DISP=SHR,DSN=your.ERDS01
//EDMPARMS DD   DISP=SHR,DSN=your.USERLIB
//SYSIN    DD   *
//

The resulting output is:

 18:53:31.86  L O G   S T A R T
 PWXEDM175000I Log Scan/Print Utility initializing
 Echo of input from SYSIN..............
 End of input from SYSIN..............
 PWXEDM175005I Begin data transfer at X'0000000050000000'
 PWXEDM172146I EDMLRDP: LMF now processing EDMTEST.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
                Log-rec  EDP-UOW=LOGGER00000000500000000000 LogRBA=0000000050000000
                Log-rec  EDP-UOW=LOGGER0000000050B400000001 LogRBA=0000000050B40000
                Log-rec  EDP-UOW=LOGGER00000000523400000003 LogRBA=0000000052340000
                Log-rec  EDP-UOW=AUSL  0000000052E800000001 LogRBA=0000000052E80000
                Beg-pkt  EDP-UOW=AUSL  00000000546800000000 LogRBA=0000000054680000
                         ECCR-UOW=AUSPRT01 AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001
                         Timestamp-18:35:40:11 Date-04/29/2014
                Chg-rec  EDP-UOW=AUSL  00000000546800000000 LogRBA=0000000054F00000
                         ECCR-UOW=AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001
                         Source=VSM Func=ISRT Srcname=VSAMEDMTEST.VSAM.KSDS01
                         Timestamp-18:35:40:18 Date-04/29/2014
                Chg-rec  EDP-UOW=AUSL  00000000546800000000 LogRBA=0000000056550000
                         ECCR-UOW=AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001
                         Source=VSM Func=ISRT Srcname=VSAMEDMTEST.VSAM.KSDS01
                         Timestamp-18:35:40:36 Date-04/29/2014
  . . . . .
  . . . . .
  . . . . .
                Srv-rec  EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=0000001902F90000
                Srv-rec  EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=0000001906090000
                Log-rec  EDP-UOW=AUSL  00000019093500000001 LogRBA=0000001909350000
                Srv-rec  EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=000000190AB50000
                Srv-rec  EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=000000190DC50000
                Log-rec  EDP-UOW=AUSL  00000019110500000001 LogRBA=0000001911050000
                Srv-rec  EDP-UOW=AUSDB2F0F10000000000004040 LogRBA=0000001912850000
                Srv-rec  EDP-UOW=AUSDB2F0F10000000000004040 LogRBA=0000001916890000
                Beg-pkt  EDP-UOW=AUSL  000000191A8D00000000 LogRBA=000000191A8D0000
                         ECCR-UOW=AUSDB201 01       F0F1000000000001 605FE82B00000000
                         Timestamp-18:53:19:68 Date-05/07/2014
                Chg-rec  EDP-UOW=AUSL  000000191A8D00000000 LogRBA=000000191D410000
                         ECCR-UOW=01       F0F1000000000001 605FE82B00000000
                         Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1
                         Timestamp-18:53:19:68 Date-05/07/2014
                Chg-rec  EDP-UOW=AUSL  000000191A8D00000000 LogRBA=00000019219F0000
                         ECCR-UOW=01       F0F1000000000001 605FE82B00000000
                         Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1
                         Timestamp-18:53:19:68 Date-05/07/2014
                Com-pkt  EDP-UOW=AUSL  000000191A8D00000000 LogRBA=0000001925E90000
                         ECCR-UOW=AUSDB201 01       F0F1000000000001 605FE82B00000000
                         Timestamp-18:53:19:68 Date-05/07/2014
 PWXEDM172198I EDMLPOPU: LMF table populate tasks are terminating due to an operator stop or PAC termination
 PWXEDM175039E Reader for log_dataset_name ended due to operator STOP or PAC termination
 Totals by Source..............
      VSAMEDMTEST.VSAM.KSDS01           Isrt= 5        Repl= 20       Dlet= 0        Segm= 0        Evnt= 0        Unk= 0
      VSAMEDM.DEV.EDMAB123              Isrt= 0        Repl= 0        Dlet= 0        Segm= 0        Evnt= 0        Unk= 0
      VSAMEDM.DEV.EDMAB123              Isrt= 1000     Repl= 0        Dlet= 1000     Segm= 0        Evnt= 0        Unk= 0
      DB2DSNBtenchar1                   Isrt= 2        Repl= 2        Dlet= 2        Segm= 0        Evnt= 0        Unk= 0
 Open Uows..................... 
 L O G   E N D

If the change records are segmented, the EDMLUCTR utility shows chaining information in the Chg-rec and Seg-rec fields and counts only the first record in the totals for Isrt, Repl, and Dlet fields. For example:

PWXEDM172146I EDMLRDP: LMF now processing EDMTEST.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
...
    Chg-rec  EDP-UOW=QAJL  0000DD53D41400000000 LogRBA=0000DD53D5B20000
             ECCR-UOW=QAA826ME D8C1C1F8F2F6D4C5 00000000000010CA
             Chaining FLG=80 SEQ=01 LEN=0000F63E
             Source=VSM Func=UPDT Srcname=ABCABC8261DBID08261FILEID00352
             Timestamp-11:34:23:52 Date-08/10/2017
    Seg-rec  EDP-UOW=QAJL  0000DD53D41400000000 LogRBA=0000DD5456360000
             ECCR-UOW=QAA826ME D8C1C1F8F2F6D4C5 00000000000010CA
             Chaining FLG=20 SEQ=02 LEN=0000F63E
             Source=VSM Func=ISRT Srcname=ABCABC8261DBID08261FILEID00352
             Timestamp-11:34:23:52 Date-08/10/2017
...
Totals by Source..............
    IDLQADLGSIDstunflat1                 Isrt= 4285     Repl= 20       Dlet= 0        Segm= 0        Evnt= 0         Unk= 0
    EDM_BASEEDM_EVENT_MARKER             Isrt= 0        Repl= 0        Dlet= 0        Segm= 0        Evnt= 28        Unk= 0
    ABCABC8261DBID08261FILEID00312       Isrt= 2        Repl= 16       Dlet= 10       Segm= 0        Evnt= 0         Unk= 0
    ABCABC8261DBID08261FILEID00352       Isrt= 16       Repl= 29       Dlet= 5        Segm= 29       Evnt= 0         Unk= 0
    ABCABC8261DBID08261FILEID00313       Isrt= 2        Repl= 2        Dlet= 2        Segm= 0        Evnt= 0         Unk= 0
    ABCABC8261DBID08261FILEID00355       Isrt= 29       Repl= 7        Dlet= 22       Segm= 260      Evnt= 0         Unk= 0
    ABCABC8261DBID08261FILEID00351       Isrt= 56       Repl= 98       Dlet= 56       Segm= 1232     Evnt= 0         Unk= 0
    IDLQADLGSIDstundent1                 Isrt= 2861     Repl= 11109    Dlet= 0        Segm= 0        Evnt= 0         Unk= 0
    IDLQADLGSIDcoursen1                  Isrt= 1061     Repl= 18101    Dlet= 0        Segm= 0        Evnt= 0         Unk= 0
    IDLQADLGSIDcrsenmem1                 Isrt= 18100    Repl= 39272    Dlet= 0        Segm= 0        Evnt= 0         Unk= 0

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

EDMLUCTR Utility - Example 1

EDMLUCTR Utility - Example 1