Reference Manual

Back Next

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