Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • PowerExchange for CDC and Mainframe 10.5.4
  • All Products

Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Client for PowerCenter
  5. PowerExchange Condense
  6. PowerExchange Listener
  7. PowerExchange Logger for Linux, UNIX, and Windows
  8. PowerExchange Navigator
  9. PowerExchange Monitoring and Tuning
  10. PowerExchange Utilities
  11. PowerExchange for Adabas
  12. PowerExchange for DB2 for i
  13. PowerExchange for DB2 for Linux, UNIX, and Windows
  14. PowerExchange for DB2 for z/OS
  15. PowerExchange for IMS
  16. PowerExchange for Microsoft SQL Server
  17. PowerExchange for MySQL
  18. PowerExchange for Oracle
  19. PowerExchange for PostgreSQL
  20. PowerExchange for SAP HANA
  21. PowerExchange for VSAM and Flat Files

Release Guide

Release Guide

Back Next

PWXUMAP Utility Commands

PWXUMAP Utility Commands

The PWXUMAP utility adds the new MDDTLDESCRIBE command to report metadata, similar to DTLDESCRIBE metadata, for data maps, schemas, tables, columns, or files. If the report output is large, you can filter it by access method and by one or more schema, map, table, or file name masks. The report output is written to a text file on Windows, which is useful for diagnosing problems.
The command runs on Windows.
Syntax:
 
PWXUMAP COMMAND=MDDTLDESCRIBE
TYPE={MD}
OUTPUT_FILE=
file_name

LOCATION={
node_name
|
local
} 
MDDESCRIBETYPE=
metadata_type

[UID=
user_name
]
[PWD=
password
|EPWD=
encrypted_password
]  
[AMLIST=
access_method_code
]
[FILEMASK=
file_name_mask
**]
[MAPMASK=
map_name_mask
] 
[PACESIZE=
n
]
[RETLOGINFOMSG={
Y
|N}]
[SCHEMAMASK=
schema__name_mask
] 
[TABLEMASK=
table_name_mask
]
The syntax includes both global parameters and command-specific parameters.
New command-specific parameters:
FILEMASK=
file-name mask
**
New
. Use a file-name mask, or pattern, to filter files or partitioned data set members when the MDDESCRIBETYPE value is set to MDFILES or MDMEMBERS. In the pattern, use the asterisk (*) wildcard to represent last part of the file names. For files on z/OS, end the pattern with two asterisk (**) wildcards.
MDDESCRIBETYPE=
metadata_type
New
. The type of metadata to include in the report. Select one of the following options:
  • ALL
    . Include all types of metadata except the MDFILES and MDMEMBERS types.
  • MDFILES
    . Include metadata for files.
  • MDIMPORT
    . Include metadata for schemas, data maps, tables or records, and columns containing additional map information.
  • MDMAPS
    . Include metadata for schemas and data maps, in two-level hierarchical format.
  • MDMEMBERS
    . Include metadata for members of partitioned data sets on z/OS.
  • MDOBJECTINFO
    . Include metadata for schemas, data maps, tables, and columns, in four-level hierarchical format.
  • MDSCHEMAS
    . Include metadata for schemas in a list.
  • MDSCHEMAINFO
    . Include metadata for schemas, data maps, and tables, in three-level hierarchical format.
No default is provided.
For more information, see the "PWXUMAP - Map List Utility" chapter in the
PowerExchange Utilities Guide
.
0 COMMENTS
We’d like to hear from you!