Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Registration Tag Names

Registration Tag Names

A registration tag name is a unique identifier that PowerExchange generates and assigns to a data source registered for CDC.
PowerExchange uses these registration tags to identify the change records of interest for CDC processing. The PowerExchange Logger for z/OS, PowerExchange Condense, and PowerExchange Logger for Linux, UNIX, and Windows store a registration tag name with each change record in their log or condense files.
For z/OS data sources that are processed by the z/OS ECCRs and PowerExchange Logger for z/OS, the registration tag name is also referred to as the EDMNAME.
When you create a capture registration, PowerExchange assigns the same registration tag name to the capture registration and the corresponding extraction map that PowerExchange generates. If you manually add another extraction map for the capture registration, this additional extraction map has the same registration tag name.
The registration tag name format varies depending on the source type. The following list describes the format of the registration tag name for each source type:
In this list, the different types of values that compose the registration tag name are separated by underscores for legibility. The underscores do not appear in the tag names.
Adabas
ADA
instance
DBID
nnnnn
FILEID
nnnnn
This registration tag name format is composed of the following values:
  • ADA
    instance
    . The prefix "ADA" followed by the collection identifier that you specified when creating the registration group.
  • DBID
    nnnnn
    . The Adabas database ID (DBID) number.
  • FILEID
    nnnnn
    . The Adabas file number.
Datacom table-based
DCM
MUFname
DBID
databaseID
STN
shortTableName
V
regVersion
This registration tag name format is composed of the following values:
  • DCM
    MUFname
    . The prefix "DCM" followed by the Datacom MUF name that you specified when creating the registration group.
  • DBID
    databaseID
    . The Datacom database ID.
  • STN
    shortTablename
    . The three-character short form of the table name that PowerExchange displays in the
    Short Table Name
    field of the Record Properties dialog box for the Datacom table.
  • V
    regVersion
    . A registration version number that PowerExchange generates.
Example: DCMR11G4DBID00800STNTB1V1
DB2 for Linux, UNIX, and Windows
UDB
database_registrationName_n
This registration tag name format is composed of the following values:
  • UDB
    database
    . The prefix "UDB" followed by the DB2 for Linux, UNIX, and Windows database name that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
DB2 for z/OS
DB2
instance_registrationName_n
This registration tag name format is composed of the following values:
  • DB2
    instance
    . The prefix "DB2" followed by the DB2 for z/OS database instance that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
DB2 for i (i5/OS)
AS4
instance_registrationName_n
This registration tag name format is composed of the following values:
  • AS4
    instance
    . The prefix "AS4" followed by the collection identifier that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
IDMS log-based
IDL
logsid_registrationName_n
This registration tag name format is composed of the following values:
  • IDL
    logsid
    . The prefix "IDL" followed by the Logsid value that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
IMS log-based
IML
reconid_registrationName
100000
This registration tag name format is composed of the following values:
  • IML
    reconid
    . The prefix "IML" followed by the IMS RECON identifier that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • 100000. A static version number.
IMS synchronous
IMS.
databaseName
.
segmentName
This registration tag name format is composed of the following values:
  • IMS.
    databaseName
    . The prefix "IMS" followed by the IMS database name that you specified when creating the data map.
  • segmentName
    . The IMS segment name.
Microsoft SQL Server
MSS
instance_registrationName_n
This registration tag name format is composed of the following values:
  • MSS
    instance
    . The prefix "MSS" followed by the instance value that is generated from the Microsoft SQL Server database name that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
MySQL
MYS
instance_registrationName_n
This registration tag name format is composed of the following values:
  • MYS
    instance
    . The prefix "MYS" followed by the MySQL instance name that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
Oracle
ORA
instance_registrationName_n
This registration tag name format is composed of the following values:
  • ORA
    instance
    . The prefix "ORA" followed by the collection identifier that you specified when creating the registration group.
  • registrationName
    . The registration name that you assigned to the capture registration.
  • n
    . A generated version number.
PostgreSQL
PGS
instance_registrationName_n
This registration tag name format is composed of the following values:
  • PGS
    instance
    . The prefix "PGS" followed by the PostgreSQL instance name that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
SAP HANA
HANA
instance_registrationName_n
This registration tag name format is composed of the following values:
  • HANA
    instance
    . The prefix "PGS" followed by the PostgreSQL instance name that you specified when creating the registration group.
  • registrationName
    . The registration name that you specified for the capture registration.
  • n
    . A generated version number.
VSAM
The registration tag name that is assigned to a VSAM data set depends on the length of the VSAM data set name in the data map.
  • If the VSAM data set name is less than or equal to 28 characters, the registration tag name has the following format:
    VSAM
    datasetName
    For example, the data set name of USERID1.VSAM.EDMSRCV.MAKEITA is 28 characters in length. For this data set, PowerExchange generates the following registration tag name:
    VSAMUSERID1.VSAM.EDMSRCV.MAKEITA
  • If the VSAM data set name is equal to or greater than 29 characters, PowerExchange truncates the data set name to 23 characters and appends an ascending numeric value,
    nnnnn
    , to create the registration tag name. The registration tag name has the following format :
    VSAM
    dataset_namennnnn
    For example, the data set name of USERID1.VSAM.EDMSRCV.MAKEITAB is 29 characters in length. For this data set, PowerExchange generates the following registration tag name:
    VSAMUSERID1.VSAM.EDMSRCV.MA00001
  • if you have subsequent data set names that are longer than 28 characters and have the same first 23 characters as a previous data set name that is longer than 28 characters, the PowerExchange Navigator increments the appended numeric value
    nnnnn
    by 1:
    VSAMUSERID1.VSAM.EDMSRCV.MA
    nnnnn+1
    For example, if the data set name is USERID1.VSAM.EDMSRCV.MAKEITAV, PowerExchange generates the following registration tag name:
    VSAMUSERID1.VSAM.EDMSRCV.MA00002

0 COMMENTS

We’d like to hear from you!