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

Running the DTLUCBRG Utility on z/OS

The following JCL provides example statements to use when you run this utility on z/OS:

//DTLUSRRG JOB  'DTLSETFL',MSGCLASS=X,NOTIFY=&SYSUID,
//        CLASS=A,REGION=64M
//********************************************************************
//*                                                                  *
//* RUN BATCH REGISTRATION UTILITY                                   *
//*                                                                  *
//********************************************************************
//INCS1 INCLUDE MEMBER=GENBULK
//***
//RUN      EXEC PGM=DTLUCBRG
/*
/*
//STEPLIB  DD DISP=SHR,DSN=&HLQ..LOADLIB
//         DD DISP=SHR,DSN=&HLQ..LOAD
//         DD DISP=SHR,DSN=&SCERUN
//         DD DISP=SHR,DSN=&DB2LOAD
//         DD DISP=SHR,DSN=&DB2EXIT
//*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//***
//SYSIN DD *
DBTYPE DB2
TABLE DTLUSR.DTL*
CONDTYPE NONE
INSTANCE DSN1
LOCATION node1
LOCATION_CRG node1
LOCATION_DM node1
LOCATION_XDM node1
CRGPREFIX DB2
TESTRUN N
STATUS A
UID <logonid>
PWD xxxxxx
REPLACE Y
REPLACEACTIVE Y
RPTCOLS N
/*
//* - other parms
//* EPWD
//* REUSECRGNAME
//*
//* CDC Datasets - need to be open if CDC to be used
//*
//DTLMSG    DD DISP=SHR,DSN=&HLQ..DTLMSG
//DTLCFG    DD DISP=SHR,DSN=&RUNLIB(DBMOVER)
//DTLKEY    DD DISP=SHR,DSN=&RUNLIB(LICENSE)
//DTLSGN    DD DISP=SHR,DSN=&RUNLIB(SIGNON)
//DTLLOG    DD SYSOUT=*
//SYSUDUMP  DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSPRINT  DD SYSOUT=*
//CEEDUMP   DD SYSOUT=*

The following JCL provides example statements to use when you run this utility on z/OS with the CREATEBICI parameter enabled:

//DTLUSRRG JOB  'DTLSBC1',MSGCLASS=X,NOTIFY=&SYSUID,
//        CLASS=A,REGION=64M
//********************************************************************
//*                                                                  *
//* RUN BATCH REGISTRATION UTILITY                                   *
//*                                                                  *
//********************************************************************
//INCS1 INCLUDE MEMBER=GENBULK
//***
//RUN      EXEC PGM=DTLUCBRG
/*
/*
//STEPLIB  DD DISP=SHR,DSN=&HLQ..LOADLIB
//         DD DISP=SHR,DSN=&HLQ..LOAD
//         DD DISP=SHR,DSN=&SCERUN
//         DD DISP=SHR,DSN=&DB2LOAD
//         DD DISP=SHR,DSN=&DB2EXIT
//*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//***
//SYSIN DD *
DBTYPE DB2
TABLE DTLUSR.DTL*
CONDTYPE NONE
INSTANCE DSN1
LOCATION node1
LOCATION_CRG node1
LOCATION_DM node1
LOCATION_XDM node1
CRGPREFIX DB2
TESTRUN N
STATUS A
UID <logonid>
PWD xxxxxx
CREATEBICI=(COLUMNS=ALL, MAXCOLS=15000, EXTINFO=BICI, INPUT_FN=Y, OUTPUT_FN=Y, ERROR_FN=Y)
REPLACE Y
REPLACEACTIVE Y
RPTCOLS Y
/*
//* - other parms
//* EPWD
//* REUSECRGNAME
//*
//* CDC Datasets - need to be open if CDC to be used
//*
//DTLMSG    DD DISP=SHR,DSN=&HLQ..DTLMSG
//DTLCFG    DD DISP=SHR,DSN=&RUNLIB(DBMOVER)
//DTLKEY    DD DISP=SHR,DSN=&RUNLIB(LICENSE)
//DTLSGN    DD DISP=SHR,DSN=&RUNLIB(SIGNON)
//DTLLOG    DD SYSOUT=*
//SYSUDUMP  DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSPRINT  DD SYSOUT=*
//CEEDUMP   DD SYSOUT=*
//*
//*CREATEBICI input, output, and error files
//*
//*Note that these data sets must be preallocated as PDSE, 
//*DSNTYPE(LIBRARY), with a record length of 255
//*
//UCBRGFIP DD DISP=SHR,DSN=&RUNLIB(UCBRGINP)
//UCBRGFOP DD DISP=SHR,DSN=&RUNLIB(UCBRGOUT)
//UCBRGFER DD DISP=SHR,DSN=&RUNLIB(UCBRGERR)

Rename Saved Search

Table of Contents

Utilities Guide

Utilities Guide

Running the DTLUCBRG Utility on z/OS

Running the DTLUCBRG Utility on z/OS