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. EDMXLUTL - Event Marker Utility
  18. HOSTENT - TCP/IP Address Reporter Utility
  19. PWXCATMY - MySQL Catalog Utility
  20. PWXUCCLPRT - Print Log Summary Utility
  21. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  22. PWXUCREG - Capture Registration Suspend Utility
  23. PWXUCRGP - Capture Registrations Print Utility
  24. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  25. PWXUGSK - SSL Reporting Utility for z/OS
  26. PWXUMAP - Map List Utility
  27. PWXUSSL - PowerExchange SSL Reporting Utility

XM_COPY RENAME Statement

XM_COPY RENAME Statement

The RENAME statement specifies which elements of the extraction map name are renamed on the target system. For most parameters, the first operand represents the item or items being renamed, and the second operand represents the new name. For example:
MAP=(map01,map02)
The first operand can be any of the following:
  • The full name of a schema, extraction map, or table
  • A partial name with a wildcard (*)
  • A wildcard (*) only
In each case, all items matching the specified name or pattern are renamed to the value of the second operand.
IDMS_PAGEGROUP_RADIX=(
old_page_group
,
new_page_group
,
old_radix
,
new_radix
)
For IDMS data sources, changes the page group or radix value. This parameter enables you to migrate registrations and extraction maps to environments with different values for the page group and radix database settings.
For
old_page_group
and
new_page_group
, specify a value from 0 to 32767.
For
old_radix
and
new_radix
, specify a value from 2 to 12.
You can create an extraction map on the target system with renamed page group and radix values by using the XM_COPY and RENAME IDMS_PAGEGROUP_RADIX statements. Before you issue these statements, you must copy the data map to the target platform by using the DM_COPY statement. If the data map is not correct on the target platform, the results of the XM_COPY and RENAME IDMS_PAGEGROUP_RADIX statements are unpredictable.
MAP=(
old_map_name,new_map_name)
Renames the extraction maps that match the name or pattern in the first operand to the specified name.
In the following example, all extraction maps named
map01
are renamed to
map02
:
MAP=(map01,map02)
In the following example, all extraction maps are renamed to
newmap
:
MAP=(*,newmap)
In the following example, all extraction map names ending in
tmp
are renamed to
fixed
:
MAP=(*tmp,fixed)
NRDB_DM_TABLE=(
old_map_name
,
new_map_name
,
old_table_name
,
new_table_name
)
For IDMS data sources, identifies the old and new data map and table names. This parameter enables the registration to link to a data map that has a new identity in the new environment.
NRDB_DM_TABLE is required only if the data map contains information that is necessary for CDC extractions. Specifically, it is required to propagate changes to the page group or radix value to the extraction map.
The following rules apply:
  • Use the following format for
    old_map_name
    and
    new_map_name
    :
    schema_name
    .
    data_map_name
    schema_name
    ,
    data_map_name
    , or both can consist in part or full of wildcards, as in the following examples:
    *.test_map
    test_schema.*
    test*.*
  • If you omit
    old_map_name
    and
    new_map_name
    , include commas as placeholders, as follows:
    NRDB_DM_TABLE=(,,
    old_table_name
    ,
    new_table_name
    )
  • You can omit
    old_table_name
    and
    new_table_name
    . If you include them, specify the complete table name, without wildcards.
REG_NAME=(
old_registration_name
,
new_registration_name
,
new_version
)
Renames the registration and, optionally, the version. Because the registration name is used to create the registration tag, this option overrides the KEEPREGTAG option. This parameter provides a documented link to the new registration.
REGTAG=(
old_regtag,new_regtag)
Renames the registration tags that match the name or pattern in the first operand to the specified name.
SCHEMA=(
old_schema_name,new_schema_name
)
Renames the schemas that match the name or pattern in the first operand to the specified name.
In the following example, all schemas named
test
are renamed to
prod
:
SCHEMA=(test,prod)
In the following example, all schemas are renamed to
newprod
:
SCHEMA=(*,newprod)
In the following example, all schemas ending in
tmp
are renamed to
fixed
:
SCHEMA=(*tmp,fixed)
TABLE=(
old_table_name,old_table_name)
Renames the tables that match the name or pattern in the first operand to the specified name.
In the following example, all tables named
testtab01
are renamed to
prodtab01
:
TABLE=(testtab01,prodtab01)
In the following example, all tables are renamed to
newtable
:
TABLE=(*,newtable)
In the following example, all tables ending in
01
are renamed to
fixed
:
TABLE=(*01,fixed)

0 COMMENTS

We’d like to hear from you!