Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Function/Access Method Section (DB2)

Function/Access Method Section (DB2)

The following table describes the fields in the function/access method section for DB2:
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