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
DTLINFOX - Enhanced Release Information Utility
- DTLINFOX Utility Overview
- Supported Operating Systems for the DTLINFOX Utility
- Control Statement Syntax for the DTLINFOX Utility
- DTLINFOX Utility Parameters
- Running the DTLINFOX Utility
- Reporting on Remote Programs by Using a PowerExchange Listener Task
- DTLINFOX Utility Examples
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
EDMUOPTS - Service Aid Utility
- EDMUOPTS Utility Overview
- Supported Operating System for the EDMUOPTS Utility
- EDMUOPTS Utility Reports
- Running the EDMUOPTS Utility
  - EDMUOPTS Utility Example JCL
  - Example EDMSDIR and EDMUPARM Reports
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 Utility
- PWXUCREG Utility Overview
- Supported Operating Systems for the PWXUCREG Utility
- Registration Statuses
- Deleting Registrations That Are No Longer Active
- Displaying Registration Summary Information
- Suspending Change Data Capture by z/OS ECCRs
  - PWXUCREG Usage Considerations
  - Suspending Change Capture for Registered Sources Temporarily
- General Syntax for PWXUCREG Commands
- PWXUCREG Commands and Parameters
- Running the PWXUCREG Utility
- Examples of PWXUCREG Utility Commands
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
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 PWXUCRGP 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
- PWXUGSK Utility Overview
- Supported Operating Systems for the PWXUGSK Utility
- PWXUGSK Control Statement Syntax
- PWXUGSK Commands and Parameters for IBM i
- PWXUGSK Commands and Parameters for z/OS
- Running the PWXUGSK Utility on IBM i
- Running the PWXUGSK Utility on z/OS
- PWXUGSK Utility Reports
PWXUMSGS - PowerExchange Listener Messages Utility
- PWXUMSGS Utility Overview
- Supported Operating Systems for the PWXMSGS Utility
- Control Statement Syntax for the PWXUMSGS Utility
- Control Statement Parameters for the PWXUMSGS Utility
- PWXUMSGS Utility Examples
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
WRKJRNLCKE- Journal Lock Table Utility for IBM i
- WRKJRNLCKE Utility Overview
- Supported Operating Systems for the WRKJRNLCKE Utility
- WRKJRNLCKE Utility Command Syntax
- Running the WRKJRNLCKE Utility on IBM i
- WRKJRNLCKE Usage Considerations
ZOSTOUCH - Set Last Referenced Date Utility for z/OS
- ZOSTOUCH Utility Overview
- Supported Operating Systems for the ZOSTOUCH Utility
- Running the ZOSTOUCH Utility
- ZOSTOUCH Utility Report
  - Example SYSPRINT Output

Utilities Guide

10.5.9
- 10.5.8
- 10.5.6
- 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
- 10.4.0

Back Next

EDMLUCTR Utility - Example 4

If you run the utility in a Post-Log Merge environment, the following JCL statements print summary data for all log records starting from a specific timestamp:

// JOB
//PLMREADR EXEC PGM=EDMLUCTR
//STEPLIB DD DISP=SHR,DSN=hlq.LOAD
//ERDS01 DD DISP=SHR,DSN=system1.ERDS01
//ERDS02 DD DISP=SHR,DSN=system2.ERDS01
//EDMPARMS DD DISP=SHR,DSN=your.USERLIB
//EDMMSG DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD   *                             
-SEL LOGRBA=DEE7023FFF000000 RECORDS=EOF 
/*

The resulting output is:

EDMMSG   log start
PWXEDM175000I Log Scan/Print Utility initializing
Echo of input from SYSIN..............
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
-SEL LOGRBA=DEE7023FFF000000 RECORDS=EOF
End of input from SYSIN..............
PWXEDM175005I Begin data transfer at DEE7023FFF000000
PWXEDM172146I Reader UTILITY ERDS01 reading at RBA 000000001000 in SYS00001-EDMTST2.DYL16A.V2.JYLL1.LG1.D2025135.T023039
PWXEDM172146I Reader UTILITY ERDS02 reading at RBA 000000001000 in SYS00002-EDMTST2.DYL16A.V2.JYLL2.LG1.D2024096.T223924
   Log-rec  EDP-UOW=LOGGER00000000000000000000 LogRBA=DEE7023FFF3F6612
   Log-rec  EDP-UOW=LOGGER0000000000B400000003 LogRBA=DEE7023FFF3FE412
   Log-rec  EDP-UOW=LOGGER00000000000000000000 LogRBA=DEE70247FC5F7011
   Log-rec  EDP-UOW=LOGGER0000000000B400000003 LogRBA=DEE70247FC5FF011
   Log-rec  EDP-UOW=JYLL  DEE704E07CA5D0120000 LogRBA=DEE704E07CA5D012
   Beg-pkt  EDP-UOW=JYLL  DEE704E08067E0120000 LogRBA=DEE704E08067E012
            ECCR-UOW=EDMTST3  EDMTST3  D1E2C3C8E6C1F340 008AF35800000001
            Timestamp-21:50:10.134977 Date-04/05/2024
   Chg-rec  EDP-UOW=JYLL  DEE704E08067E0120000 LogRBA=DEE704E080696A12
            ECCR-UOW=EDMTST3  D1E2C3C8E6C1F340 008AF35800000001
            Source=VSM Func=ISRT Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-21:50:10.135026 Date-04/05/2024
   Log-rec  EDP-UOW=LOGGER0000000016A10000000A LogRBA=DEE7050192284212
   Chg-rec  EDP-UOW=JYLL  DEE704E08067E0120000 LogRBA=DEE70513EFB78E12
            ECCR-UOW=EDMTST3  D1E2C3C8E6C1F340 008AF35800000001
            Source=VSM Func=ISRT Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-21:51:04.068312 Date-04/05/2024
   PH1-pkt  EDP-UOW=JYLL  DEE704E08067E0120000 LogRBA=DEE7051E4DE7B412
            ECCR-UOW=EDMTST3  EDMTST3  D1E2C3C8E6C1F340 008AF35800000001
            Timestamp-21:51:14.939962 Date-04/05/2024
   Com-pkt  EDP-UOW=JYLL  DEE704E08067E0120000 LogRBA=DEE7051E4E2FF012
            ECCR-UOW=EDMTST3  EDMTST3  D1E2C3C8E6C1F340 008AF35800000001
            Timestamp-21:51:14.939962 Date-04/05/2024
. . . . .
. . . . .
PWXEDM172146I Reader UTILITY ERDS02 reading at RBA 00000003D000 in SYS00003-EDMTST2.DYL16A.V2.JYLL2.LG1.D2024096.T234515
. . . . .
PWXEDM172146I Reader UTILITY ERDS02 reading at RBA 000000079000 in SYS00004-EDMTST2.DYL16A.V2.JYLL2.LG1.D2025134.T170104
   Srv-rec  EDP-UOW=JSCYL1F6C24040404040404040 LogRBA=DEE717F3C9341C12
   Log-rec  EDP-UOW=JYLL  DEE71D13189B08120000 LogRBA=DEE71D13189B0812
   Beg-pkt  EDP-UOW=JYLL  DEE71D131C2B84120000 LogRBA=DEE71D131C2B8412
            ECCR-UOW=JSCYL16A JSCYL16A D1E2C3E8D3F1F6C1 008CEA8800000001
            Timestamp-23:38:25.652816 Date-04/05/2024
. . . . .
PWXEDM172146I Reader UTILITY ERDS02 reading at RBA 0000000B5000 in SYS00005-EDMTST2.DYL16A.V1.PRILOG2.DS01
   Chg-rec  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EA1A66012
            ECCR-UOW=JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Source=VSM Func=DLET Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-23:44:13.277896 Date-04/05/2024
   Chg-rec  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EA1A6E812
            ECCR-UOW=JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Source=VSM Func=DLET Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-23:44:13.277994 Date-04/05/2024
   Chg-rec  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EA1A76A12
            ECCR-UOW=JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Source=VSM Func=DLET Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-23:44:13.278101 Date-04/05/2024
   Chg-rec  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EA1A7EC12
            ECCR-UOW=JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Source=VSM Func=DLET Srcname=VSAMEDMTST2.DYL16A.V1.DEMO.KSDS
            Timestamp-23:44:13.278191 Date-04/05/2024
   PH1-pkt  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EA2837212
            ECCR-UOW=JSCYL16B JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Timestamp-23:44:13.281802 Date-04/05/2024
   Com-pkt  EDP-UOW=JYLL  DEE71E5EA17D94120000 LogRBA=DEE71E5EB72E0412
            ECCR-UOW=JSCYL16B JSCYL16B D1E2C3E8D3F1F6C2 008CEA8800000001
            Timestamp-23:44:13.281802 Date-04/05/2024
   Srv-rec  EDP-UOW=JSCYL1F6C24040404040404040 LogRBA=DEE71E5ED011C412
   Srv-rec  EDP-UOW=JSCYL1F6C24040404040404040 LogRBA=DEE71E5ED0128A12
   Log-rec  EDP-UOW=LOGGER0000000B481E00000000 LogRBA=DEEC63592B223012
   Log-rec  EDP-UOW=LOGGER0000000B48D200000003 LogRBA=DEEC63592B22B412
   Log-rec  EDP-UOW=LOGGER0000000B500000000000 LogRBA=E0E2AF0C37BBCD02
   Log-rec  EDP-UOW=LOGGER0000000B50B400000003 LogRBA=E0E2AF0C37BC5442
PWXEDM172198I Reader UTILITY ERDS02 reader terminates due to an operator stop or reader termination
PWXEDM172198I Reader UTILITY ERDS01 reader terminates due to an operator stop or reader termination
End of Logger Data Reached...........
PWXEDM175039I Reader UTILITY for member ERDS02 ended due to operator STOP or PAC termination
Totals by Source..............
   VSAMEDMTST2.DYL16A.V1.DEMO.KSDS      Isrt= 639      Repl= 19       Dlet= 435      Segm= 0        Evnt= 0         Unk= 0
Open Uows.....................
EDMMSG   log end

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

EDMLUCTR Utility - Example 4

EDMLUCTR Utility - Example 4