Table of Contents

Search

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

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!