Search

Navigator User Guide

Navigator User Guide

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

Back Next

Viewing or Editing Properties for a Capture Registration

Viewing or Editing Properties for a Capture Registration

After you register a source for change capture, you can edit some capture registration properties.

The following properties can be edited:

Status

. For all source types, you can change the status setting for a capture registration. The PowerExchange Navigator allows the following status transitions: Inactive to Active, Active to History, and Suspended to History. You must use the PWXUCREG utility to change a registration status from Active to Suspended and from Suspended back to Active.

Condense

. For all source types, you can change the Condense option for a capture registration from None to Part or from Part to None. For i5/OS and z/OS data sources that have keys, you can also change the Condense option from None or Part to Full or from Full or None to Part.

Comments

. For all source types, you can add or edit comments for the capture registration.

For a DB2 data source, you can also add or remove columns.

If you need to make any other changes to a capture registration, you must re-create the registration.

Editing an active capture registration can have various implications to CDC.

Open the registration group.

Open the capture registration.

The following tables describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays, depending on the data source type, for the capture registration.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for all data source types:

Property	Description
Name	Read only. The user-defined name for the capture registration.
Type	Read only. The PowerExchange capture type. Options are: Log-Based . PowerExchange captures changes from database logs. Synchronous . PowerExchange captures changes in a synchronous manner.
Status	The status of the capture registration with regard to availability for change capture use. Options are: Inactive . PowerExchange cannot yet use the registration to capture changes for the source. This option is the initial status setting when you create the registration. You must manually set the option to Active to make the registration eligible for change capture use. Active . PowerExchange can use the registration to capture changes for the source. History . PowerExchange has permanently stopped using the registration for change capture. Select this option if the registration is obsolete and you want to retain it for audit purposes or delete it. After you set the status to History, you cannot make the registration active again. Suspended . PowerExchange change capture processing is temporarily suspended for the registered source. This status is set by the PWXUCREG utility SUSPEND_REGISTRATION command and is available only for an Adabas, Datacom table-based, IDMS log-based, or IMS log-based CDC source. You can change this status to History from the PowerExchange Navigator. However, to change this status back to Active, you must use the PWXUCREG utility ACTIVATE_REGISTRATION command. For more information, see Status Options.
Suspend Time	Read only. The current system timestamp, without adjustment for local time, that indicates when the PWXUCREG utility SUSPEND_REGISTRATION command was processed to temporarily suspend the registration for change capture use. The timestamp format is YYYY/MM/DD HH:MM:SS.ssssss, where ssssss are fractional seconds. This property is blank if the registration has never been suspended. This property is displayed for Adabas, Datacom table-based, IDMS log-based, and IMS log-based CDC sources because the PWXUCREG utility supports only these sources. This property is not displayed for any other source types. For more information about the PWXUCREG suspension time, see the PowerExchange Utilities Guide .
Active Time	Read only. The current system timestamp, without adjustment for local time, that indicates when the PWXUCREG utility ACTIVATE_REGISTRATION command was processed to reactivate the registration for change capture use. The timestamp format is YYYY/MM/DD HH:MM:SS.ssssss, where ssssss are fractional seconds. This field is blank if the registration status was set to Active for the first time from the PowerExchange Navigator or if the registration has never been activated or reactivated with the PWXUCREG utility. This field remains blank until you issue a PWXUCREG utility SUSPEND_REGISTRATION command followed by an ACTIVATE_REGISTRATION command. This property is displayed for Adabas, Datacom table-based, IDMS log-based, and IMS log-based CDC sources because the PWXUCREG utility supports only these sources. This property is not displayed for any other source types. For more information about the PWXUCREG activation time, see the PowerExchange Utilities Guide .
Condense	Whether PowerExchange Condense or the PowerExchange Logger for Linux, UNIX, and Windows is used and the type of PowerExchange Condense processing on i5/OS or z/OS. Options are: None . PowerExchange does not use PowerExchange Condense or the PowerExchange Logger for Linux, UNIX, and Windows to process changes for the registered source. Part . PowerExchange uses PowerExchange Condense or the PowerExchange Logger to process changes for the registered source. PowerExchange Condense uses partial condense processing. This option maintains transactional consistency and is recommended by Informatica. Full . PowerExchange uses PowerExchange Condense full condense processing for i5/OS or z/OS sources but some limitations apply. This option does not maintain transactional consistency. For more information, see Condense Options.
Version	Read only. The registration version number.
Capture Type	Read only. The data source type.
Comments	User-defined comments about the capture registration.
Tag	Read only. A PowerExchange-generated tag name that is assigned to the registered source and that is used to identify the change records of CDC interest.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for Adabas data sources:

Property	Description
Database ID	The DBID of the database.
File Number	The file number of the database.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for CA Datacom/DB data sources:

Property	Description
Database ID	The database ID.
Short Table Name	The short name of the table.
Table ID	The internal table identifier.
Record Size	The record size.
Table Recovery	An option that indicates whether recovery facilities of CA DATACOM/DB are used for this table. Valid values are YES and NO.
Element Count	The number of elements.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for DB2 for i5/OS data sources:

Property	Description
File Name	The file name.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for IDMS log-based data sources:

Property	Description
Area Name	The name of the IDMS area that contains a set of pages that store the database records.
SubSchema Type	The name of the subschema. A subschema provides a program view of the database and is used at runtime. It includes data elements, record types, set types, areas, and logical-record components. Valid characters are ASCII characters and the pound and yen sign.
DB Name	The name of the IDMS database. Valid characters are ASCII characters and the pound and yen sign.
Base Record	The IDMS base record name.
Location Mode	One of the following modes that determine how a record is assigned to a particular page in the area: C . Indicates CALC mode. V . Indicates VIA mode. D . Indicates DIRECT mode.
Base Record ID	The IDMS base record identifier.
Compressed	Indicates whether IDMS native compression is used to compress records. Valid values are YES and NO.
Presspack Comp	Indicates whether the IDMS Presspack compression tool is used to compress records. Valid values are YES and NO.
Presspack Dctable	If Presspack compression is used, the name of the data characteristic table (DCT) that contains information about the data and that is required for compression and decompression.
Variable	Indicates whether the record occurrences are of variable length. Valid values are YES and NO.
Page Group	The page group number.
Radix	The radix number. A radix is the database key format that describes the structure of the database keys that identify records in the database.
Min Root Length	The length of the minimum root portion of a variable-length record on the home page.
Data Length	The length of the Data component of a record occurrence. The Data component is a set of bytes that represents the record value.
Prefix Length	The length of the Prefix component of a record occurrence. The prefix points to the related NEXT, PRIOR and OWNER records.
Ctrl Portion Len	The length of the control portion of a record up to and including the symbolic key.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for IMS synchronous data sources:

Property	Description
Database Name	Read-only. The database name.
Primary Dataset Name	Read-only. The data set file name.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for Microsoft SQL Server data sources:

Property	Description
Server	The server where the source is located.
Database Name	The database name.
Dist DBName	The SQL Server distribution database name.
Article Id	The SQL Server article ID.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for Oracle data sources:

Property	Description
Supplemental Log	Read-only. The name of the supplemental log group.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for SAP HANA data sources:

Property	Description
Row Table	Identifies whether the table is a row table.

The following table describes the properties that the

Capture Registration

tab in the

Resource Inspector

displays for VSAM data sources:

Property	Description
Data Set Name	A VSAM ESDS, KSDS, or RRDS data set name.

Click the property in the

Resource Inspector

that you want to edit and then change the property value.

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

To undo a change, click

Reset

.

To apply the change, click

Apply

.

Registration Groups and Capture Registrations

Adding a Capture Registration

Changing the DB2 Columns in a Capture Registration

Registration Tag Names

Condense Options

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.