PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.6
- All Products
Property
| Description
|
---|---|
Name
| A user-defined name for the extraction 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.
|
UserID
| A user ID that allows access to the source. The type of user ID depends on the source type and PowerExchange security settings:
|
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:
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
| The instance name from the registration group.
For an Adabas, DB2 for i5/OS, Oracle, or VSAM source, the instance name is the collection identifier.
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 source database.
|
DB Name
| For an IDMS log-based source, the name of the database.
|
Recon ID
| 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.
|