Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.4.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLREXE - Remote Execution Utility
  8. DTLUAPPL - Restart Token Utility
  9. DTLUCBRG - Batch Registration Utility
  10. DTLUCDEP - CDEP Maintenance Utility
  11. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  12. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  13. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  14. DTLURDMO - Data Map Utility
  15. DTLUTSK - Task Control Utility
  16. EDMLUCTR - Log Scan and Print Utility
  17. EDMUOPTS - Service Aid Utility
  18. EDMXLUTL - Event Marker Utility
  19. HOSTENT - TCP/IP Address Reporter Utility
  20. PWXCATMY - MySQL Catalog Utility
  21. PWXUCCLPRT - Print Log Summary Utility
  22. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  23. PWXUCREG - Capture Registration Suspend Utility
  24. PWXUCRGP - Capture Registrations Print Utility
  25. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  26. PWXUGSK - SSL Reporting Utility for z/OS
  27. PWXUMAP - Map List Utility
  28. PWXUSSL - PowerExchange SSL Reporting Utility

Utilities Guide

Utilities Guide

Back Next

Example 3. Column-Level Report

Example 3. Column-Level Report

When you run the PWXUCGRP utility with the REPORT_LEVEL=COLUMNS parameter setting, the report displays detailed column-level information for each capture registration.
The following command can be used to produce the example column-level report: 
C:\Informatica\PowerExchangev.r.m PWXUCRGP OUTPUT_FILE=.\Files\LOCAL\Columns_CRNAME.txt LOCATION=MHZEUSER2 UID=
user_name
 PWD=
password
 REPORT_SEQUENCE=CRNAME REPORT_LEVEL=COLUMNS DBTYPE=* INSTANCE=* STATUS=* CRNAME=*
The following example report shows the COLUMNS output, sorted by CRNAME with no filters applied: 
2018-01-15 09:13:01                  PWXUCRGP REPORT                  MHZEUSER2
================================================================================

Output file          : .\Files\MHZEUSER2\Columns_CRNAME.txt
Location             : MHZEUSER2

Report content
--------------
Report Sequence      : CRNAME
Report Level         : COLUMNS

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

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

DB Type   Instance    Total | Active |  Part  None  Full
-------   --------    ----- | ------ |  ----  ----  ----
ADA       ADA8242         1 |      1 |     1     0     0
                            |        |                  
DCM       MUFR15Q0        1 |      1 |     1     0     0
                            |        |                  
IDL       RVFLGSID        5 |      2 |     2     0     1
          LOGSID          1 |      1 |     1     0   
IDL	      *all*			        6	|      3 |     3     0  
                            |        | 
IMS       IMS9            6 |      5 |     2     1     3   
                            |        |                  
VSM       FLDVSAM         1 |      1 |     1     0     0
-------   --------    ----- | ------ |  ----  ----  ----
All       *all*          15 |     11 |     8     1     4
-------   --------    ----- | ------ |  ----  ----  ----


DBTYPE=ADA      INSTANCE=ADA8242
================================

CRNAME=ada8242    STATUS=A CNDSOPT=Part TAG=ADAADA8242DBID08242FILEID00351  TABLE=ada8242.map351a_ADA_RECORD
------------------------------------------------------------------------------------------------------------
Last Updated: '20141218144631'  Version: 'V9.6.1'  Edit Sequence: '2'
Registration Type: 'LOG-BASED'  Data Columns: '9'
Adabas: DB Id: '8242' File Number: '351'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq Offset Length 
AA_field                       CHAR                   8      0         Y   N                   
AC_field                       CHAR                  20      0         Y   N                   
AE_field                       CHAR                  20      0         Y   N                   
AF_field                       CHAR                   1      0         Y   N                   
AG_field                       CHAR                   1      0         Y   N                   
AH_field                       PACKED                11      0         Y   N                   
AI_field                       CHAR                  20      0         Y   N                   
AJ_field                       CHAR                  20      0         Y   N                   
AN_field_10                    VARCHAR             1024      0         Y   N                   


DBTYPE=DCM      INSTANCE=MUFR15Q0
=================================

CRNAME=aa         STATUS=A CNDSOPT=Part TAG=DCMMUFR15Q0DBID00001STNPAYV1    TABLE=aa.pay_PAYROLL
------------------------------------------------------------------------------------------------
User name: 'USER2'
Last Updated: '20161207151954'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '7'
Datacom: DB Id: '00001'  Table Id: '1' Table Name: 'PAY' Elements: '6'  Record Length: '40'  Recovery Flag: 'Y'

Element Name Offset Length
PYIDT             1      7
FIGS              8     32
PAYRC             1     39

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq Offset Length Key Name.
NUMBER                         UZONED                 5      0         N   Y   1      1      5 NUMBER
ACTIVITY_CODE                  CHAR                   1      0         N   N                   
ACTIVITY_STATUS                CHAR                   1      0         N   N                   
CURRENT_RATE                   UZONED                 8      2         N   N                   
YTD_WAGES                      UZONED                 8      2         N   N                   
YTD_COMMISSION                 UZONED                 8      2         N   N                   
YTD_TAX                        UZONED                 8      2         N   N                   


DBTYPE=IDL      INSTANCE=RVFLGSID
=================================

CRNAME=empss01    STATUS=A CNDSOPT=Part TAG=IDLRVFLGSIDempss011             TABLE=empss01.map1_employee
-------------------------------------------------------------------------------------------------------
User name: 'USER2'
Last Updated: '20171211170904'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '9'
IDMS: Subschema: 'empdemo' Base Record Name: 'EMPLOYEE' Id: '415'
IDMS: Area Name: 'EMP-DEMO-REGION' Page Group: '0' Radix: '8'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq Offset Length 
EMP_ID_0415                    UZONED                 4      0         N   N                   
EMP_FIRST_NAME_0415            CHAR                  10      0         N   N                   
EMP_LAST_NAME_0415             CHAR                  15      0         N   N                   
EMP_STREET_0415                CHAR                  20      0         N   N                   
EMP_CITY_0415                  CHAR                  15      0         N   N                   
EMP_STATE_0415                 CHAR                   2      0         N   N                   
EMP_ZIP_FIRST_FIVE_0415        CHAR                   5      0         N   N                   
EMP_ZIP_LAST_FOUR_0415         CHAR                   4      0         N   N                   
EMP_PHONE_0415                 UZONED                10      0         N   N                   

CRNAME=idmsqa     STATUS=A CNDSOPT=Part TAG=IDLRVFLGSIDidmsqa1              TABLE=idmsqa.stcrss01_student
---------------------------------------------------------------------------------------------------------
Last Updated: '20171211171039'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '6'
IDMS: Subschema: 'stcrseg' Base Record Name: 'STUD' Id: '0'
IDMS: Area Name: 'STUDCRSE-REGION' Page Group: '0' Radix: '8'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq Offset Length 
STUD_NAME                      CHAR                  40      0         N   N                   
STUD_ADDRESS_1                 CHAR                  40      0         N   N                   
STUD_ADDRESS_2                 CHAR                  40      0         N   N                   
STUD_CITY                      CHAR                  30      0         N   N                   
STUD_STATE                     CHAR                   2      0         N   N                   
STUD_ZIP                       CHAR                   9      0         N   N                   


DBTYPE=IMS      INSTANCE=IMS9
=============================

CRNAME=dtld0006   STATUS=A CNDSOPT=Full TAG=IMLIMS9dtld0006100000           TABLE=ims9.dtld006.COMPLETE_HIERARCHY
-----------------------------------------------------------------------------------------------------------------
User name: 'USER2'
Last Updated: '20171211114641'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '6'
Data Map: 'dtld006'
IMS: Version: '9.10' DB Name: 'DTLD006' DB Type: 'HIDAM VSAM' System Type: 'Y
IMS: Segment Name: 'STUDENT' Level: '1' Code: '1' Parent Code: '0'
IMS: Spans Segments: 'Y'
IMS: Key Start '161' Key Length '12'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq
STUDENT:PNAME                  CHAR                  40      0         N   N    
STUDENT:ADDRESS1               CHAR                  40      0         N   N    
STUDENT:ADDRESS2               CHAR                  40      0         N   N    
STUDENT:CITY                   CHAR                  30      0         N   N    
STUDENT:STATE                  CHAR                   2      0         N   N    
STUDENT:ZIP                    CHAR                   9      0         N   N    


CRNAME=dtld0008   STATUS=I CNDSOPT=Part TAG=IMLIMS9dtld0008100000           TABLE=ims9.dtld008.COMPLETE_HIERARCHY
-----------------------------------------------------------------------------------------------------------------
Last Updated: '20171211114734'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '9'
Data Map: 'dtld008'
IMS: Version: '9.10' DB Name: 'DTLD008' DB Type: 'HDAM OSAM' System Type: 'Y
IMS: Segment Name: 'NAMEMAST' Level: '1' Code: '1' Parent Code: '0'
IMS: Spans Segments: 'Y'
IMS: Key Start '0' Key Length '60'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq
NAMEMAST:EMPLOYEE              CHAR                  60      0         N   N    
NAMEMAST:MANNBR                CHAR                  15      0         N   N    
NAMEMAST:ADDR                  CHAR                  75      0         N   N    
NAMESKIL:TYPE                  CHAR                  21      0         Y   N    
NAMESKIL:STDLEVL               CHAR                  20      0         Y   N    
ADDRESS:HOMEADDR               CHAR                 100      0         Y   N    
ADDRESS:COMAILOC               CHAR                 100      0         Y   N    
PAYROLL:BASICPAY               PACKED                29      0         Y   N    
PAYROLL:HOURS                  PACKED                29      0         Y   N    

CRNAME=dtld0009   STATUS=I CNDSOPT=None TAG=IMLIMS9dtld0009100000           TABLE=ims9.dtld009.COMPLETE_HIERARCHY
-----------------------------------------------------------------------------------------------------------------
Last Updated: '20171211114831'  Version: 'V10.2.0'  Edit Sequence: '1'
Registration Type: 'LOG-BASED'  Data Columns: '8'
Data Map: 'dtld009'
IMS: Version: '9.10' DB Name: 'DTLD009' DB Type: 'HDAM OSAM' System Type: 'Y
IMS: Segment Name: 'SKILMAST' Level: '1' Code: '1' Parent Code: '0'
IMS: Spans Segments: 'Y'
IMS: Key Start '0' Key Length '21'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq
SKILMAST:TYPE                  CHAR                  21      0         N   N    
SKILMAST:STDCODE               CHAR                  10      0         N   N    
SKILNAME:EMPLOYEE              CHAR                  60      0         Y   N    
SKILNAME:STDLEVL               CHAR                  20      0         Y   N    
EXPR:PREVJOB                   CHAR                  10      0         Y   N    
EXPR:CLASSIF                   CHAR                  10      0         Y   N    
EDUC:GRADLEVL                  CHAR                  10      0         Y   N    
EDUC:SCHOOL                    CHAR                  65      0         Y   N    


DBTYPE=VSM      INSTANCE=FLDVSAM
================================

CRNAME=cdcfld1    STATUS=A CNDSOPT=Part TAG=VSAMUSER2.CDCFIELD.KSDS1         TABLE=mvs800.cdcfield1_t1
-----------------------------------------------------------------------------------------------------
Last Updated: '20121105130114'  Version: 'V9.5.1'  Edit Sequence: '1'
Registration Type: 'SYNCHRONOUS'  Data Columns: '3'
Registration Location: 'mhzDefgh'
Vsam: Dataset Name: 'USER2.CDCFIELD.KSDS1'

Column Name.                   Type.          Precision  Scale CPN Nulls Key Seq Offset Length 
F1                             CHAR                   4      0         N   N                   
F2                             CHAR                  20      0         N   N                   
F3                             CHAR                  10      0         N   N
0 COMMENTS
We’d like to hear from you!