Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Viewing or Editing Properties for a Registration Group

You can view or edit properties for a registration group.

You can edit the registration group name, source location, or the user ID and password for accessing the source. You cannot change the database type.

Open the registration group.

The following table describes the properties that appear on the

Registration Group

tab in the

Resource Inspector

, depending the data source type:

Property	Description
Name	User-defined name for the registration group.
Access Method	Read-only. Access method associated with the data source type.
Location	Location of the source for which you want to capture changes. The location value is a node name in a NODE statement in the dbmover.cfg configuration file on the PowerExchange Navigator system.
UserID	A user ID that allows access to the source. The type of user ID depends on the source type and PowerExchange security settings: If the source is on an i5/OS or z/OS system and PowerExchange security is enabled, enter an operating system user ID. PowerExchange security is enabled when the PowerExchange SECURITY statement in the DBMOVER member is set to (1,`x`) or 2.`x`). For a DB2 LUW, Microsoft SQL Server, MySQL, Oracle, or PostgreSQL source, enter a valid database user ID, if required. For more information, see the SECURITY Statement in the PowerExchange Reference Manual .
Password	A password for the specified user ID. If the data source is on an i5/OS or z/OS system, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length. A passphrase can contain the following characters: Uppercase and lowercase letters The numbers 0 to 9 Spaces The following special characters: ’ - ; # \ , . / ! % & * ( ) _ + { } : @ \| < > ? The first character is an apostrophe. Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols. On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases. On z/OS, a valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation. To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the PowerExchange Reference Manual .
Instance	For an Adabas, DB2 for i5/OS, Oracle, or VSAM source, the instance name is the collection identifier that you entered when defining the registration group. For a DB2 for z/OS source, the instance name is the database instance name. For a Microsoft SQL Server source, the instance name is the Instance value that you entered when creating the registration group. If you did not enter an instance name, this value is a generated value that is composed of the first four characters of the database name followed by an ascending number, which starts at 000. For a MySQL or PostgreSQL source, the instance name is the Instance value that you entered when creating the registration group. If you did not enter an instance name, this value is a generated value that consists of the first four characters of the database server name followed by an ascending number, which starts at 000.
MUF Name	For a CA Datacom/DB source, the name of the Multi-User Facility (MUF).
Server	For a Microsoft SQL Server source, the name of the publication server. For a PostgreSQL source, the name of the database server.
MySQL Server	For a MySQL source, the name of the database server.
Database	For a DB2 LUW, Microsoft SQL Server, or PostgreSQL source, the name of the database.
DB Name	For an IDMS log-based source, the name of the database.
Recon Identifier	For an IMS source, the RECON identifier for the database.
Oracle SID	Read-only. For an Oracle source, the system identifier (SID) for the database.

To edit a property, click a property in the

Resource Inspector

and enter a value.

After you edit a property, a red square appears next to the changed property.

To undo a change before you apply it, click

Reset

To apply a change, click

Apply

If you edit the registration group name, you are prompted to confirm the change. If the new name matches the name of an existing registration group, you are prompted to overwrite the existing group.

If you change the location to a location that is not valid for the instance, PowerExchange displays an error message.

If you change the instance to an instance that does not exist, PowerExchange displays an error message.

Click

Yes

to confirm any changes.

The

Resource Inspector

updates any fields that you edited.

Registration Groups and Capture Registrations

Adding a Registration Group

Download Guide

Watch