Data Replication
- Data Replication 9.8.0 HotFix 1
- All Products
show open transactionsconfiguration_name
Parameter | Description |
---|---|
configuration_name
| The name of the configuration for which to display open transactions. |
show open transactions Oracle2Oracle
The following table describes the properties of open transactions that can appear in the output, depending on the source type and whether the transaction is marked for commit or rollback processing:Transaction #0 Transaction Name: 'qwerty' XID: '0x0009.007.0001b473' Begin Transaction SCN: '0x0003.3f65f2f0' Loopback Transaction: 'false' Records in Transaction: '9' Redo Thread ID: '1' System Table Transaction: '0' Begin Transaction Timestamp: 'Apr 1, 2014 2:13:43 PM' Undo Block Address (UBA): '0x00c00100.0001b473.0007' Session ID: '14' Session Serial Number: '11279' Internal SCN: '13948547824 0' Internal XID: '2533304855278707' Transaction size (in bytes): '1584' Database Transaction Status: 'ACTIVE' Database User Name: 'SRC' System User: 'abobkov' Host: 'KZW178313'
Property
| Description
|
---|---|
Transaction
| A transaction counter that the Server Manager CLI generates to list open transactions. The counter uses the format
# . The
number number value begins at 0 and is incremented by 1 for each subsequent open transaction for the specified configuration.
|
Transaction Name
| The name of the open transaction.
|
XID
| The transaction ID of the open transaction.
For Oracle sources, the Server Manager CLI might list multiple open transactions with the same XID value if Oracle reuses transaction IDs. When listing these transactions, the command first lists the transactions for unmapped tables that do not have a
Begin Transaction Timestamp and then lists the other transactions in chronological order, beginning with the transaction that has the earliest
Begin Transaction Timestamp .
|
Begin Transaction LSN or Begin Transaction SCN (for Oracle sources)
| The SCN or LSN value for the BEGIN TRANSACTION operation.
|
Loopback Transaction
| Indicates whether the Extractor skips the transaction based on the transaction name. The Extractor skips transactions if their names are specified in the
SKIP_TX command line parameter. If the
SKIP_DEFAULT_TX parameter is set to Y, the Extractor also skips transactions that have the default name of DbSyncTransaction. Valid values are:
|
Records in Transaction
| The number of records in the transaction that are available in intermediate files.
|
Database ID or Redo Thread ID (for Oracle sources)
| For Oracle sources, the unique identifier of a redo thread. For other sources, the unique identifier of a database.
|
DDL Transaction or System Table Transaction (for Oracle sources)
| Indicates whether the transaction affects database system tables. A transaction that affects database system tables usually includes DDL operations. The database system tables that Data Replication monitors are specified in the following parameters in the
DataReplication_installation /uiconf/default.cfg file:
Valid values are:
|
Begin Transaction Timestamp
| The date and time of the first redo record for the mapped table. This value displays only if the transaction includes changes to a mapped table in the configuration. If the transaction includes changes to an unmapped source table, the
Begin Transaction Timestamp property does not contain a value.
|
Undo Block Address (UBA)
| For Oracle sources, specifies the Undo Block Address.
|
Session ID
| For Oracle sources, specifies the identifier of the session that is associated with the open transaction.
|
Session Serial Number
| For Oracle sources, specifies the serial number of the session that is associated with the open transaction.
|
Internal LSN or (for Oracle) Internal SCN
| The LSN or SCN value for the BEGIN TRANSACTION operation in the database format.
|
Internal XID
| The transaction ID in the database format.
|
Transaction size
| The amount of data, in bytes, in the transaction records in the intermediate files.
|
Database Transaction Status
| The status of the transaction that is reported by the source database. If the source database does not contain information about the transaction, Data Replication sets the transaction status to NOT ACTIVE.
|
Database User Name
| The name of the database user who opened the transaction.
|
System User
| The name of the system user who opened the transaction.
|
Host
| The IP address or host name of the system with the database client that opened the transaction.
|
Application ID
| For DB2 sources, the ID of the database client that opened the transaction.
|