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 2

The following JCL statements print summary data for all log records starting from the specified RBA and detailed information in hexadecimal format about the change records:

//         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   *
-SEL   LOGRBA=000000191A8D0000 CHANGE-DETAIL
-SEL   RECORDS=10
//

The job prints the detailed information about the change records because the optional CHANGE-DETAIL parameter is included.

The resulting output is:

 19:08:00.74  L O G   S T A R T
 PWXEDM175000I Log Scan/Print Utility initializing
 Echo of input from SYSIN..............
 -SEL LOGRBA=000000191A8D0000 CHANGE-DETAIL
 -SEL RECORDS=10
 End of input from SYSIN..............
 PWXEDM175005I Begin data transfer at X'000000191A8D0000'
 PWXEDM172146I EDMLRDP: LMF now processing WBRUMB1.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
               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
                  0000  00000003 00000014 000002B4 000002B4            ©   ©
                  0010  0000044A 02A00101 C3C46008 00000002   œ¢ µ  CD-—   
                  0020  E2C40000 00000000 00000000 00040000 SD           œ  
                  0030  00000000 00000000 0000CD1E 42982685           ò âq e
                  0040  8081C4C2 F2C4E2D5 C2A38595 83888199 ØaDB2DSNBtenchar
                  0050  F1404040 40404040 40404040 40404040 1
                  0060  40404040 4040C1E4 E2D34040 00000019       AUSL     
                  0070  1A8D0000 00000000 00191D41 00000000 ’ý            
  . . . . .
  . . . . .
 Default 5000 or RECORDS= threshold reached
 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..............
           DB2DSNBtenchar1            Isrt= 2     Repl= 1     Dlet= 2     Segm= 0     Evnt= 0     Unk= 0
Open Uows.....................
             Edp-UOW=AUSL  0000001936AD00000000 LogRBA=0000001936AD0000  ECCR-UOW=01 F0F1000000000001 605FF6E000000000
 L O G   E N D

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

EDMLUCTR Utility - Example 2

EDMLUCTR Utility - Example 2