PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0 HotFix 1
- All Products
Field
| Decimal Offset
| Decimal Offset
| Length
| Format
| Description
|
---|---|---|---|---|---|
PWX2CPU
| 0
| 0
| 8
| Binary
| CPU time, in microseconds.
|
PWX2NST
| 8
| 8
| 4
| Binary
| The number of DB2 statements executed.
|
PWX2NR
| 12
| C
| 4
| Binary
| The number of rows returned.
|
PWX2SSID
| 16
| 10
| 4
| Char
| The DB2 SSID.
|
PWX2PLAN
| 20
| 14
| 8
| Char
| The DB2 plan name.
|
PWX2CNTY
| 28
| 1C
| 8
| Char
| The connection type. Values are "RRSAF" and "CAF."
|
PWX2AUTH
| 36
| 24
| 8
| Char
| The authorization ID.
|
PWX2CORR
| 44
| 2C
| 32
| Char
| Correlation ID, in the following format:
PWX
nnnnn
Where
nnnnn is a unique number that the PowerExchange Listener generates.
PowerExchange generates a correlation ID for each subtask that the PowerExchange Listener generates.
|
PWX2SRC
| 76
| 4C
| 4
| Binary
| The SQL code.
|
PWX2SRS
| 80
| 50
| 4
| Binary
| The reason code.
|
PWX2RUC
| 84
| 54
| 4
| Binary
| The number of rows updated.
|
PWX2RDL
| 88
| 58
| 4
| Binary
| The number of rows deleted.
|
PWX2RIN
| 92
| 5C
| 4
| Binary
| The number of rows inserted.
|
PWX2QTY
| 96
| 60
| 1
| Binary
| DB2 connection type similar to DWHCATYP. Values are:
X'02' = CAF
X'12' = RRSAF
|