IFCID 0124 Sections

IFCID 0124 sections.
IFCID 0124 provides an active SQL snapshot giving status information about the process, the SQL statement text, the relational data system input parameter list (RDI) block, and status flags to indicate certain bind and locking information. It is possible to obtain a varying amount of data because the request requires the process to be connected to Db2, have a cursor table allocated (RDI and status information is provided), and be active in Db2 (SQL text is provided if available). The SQL text provided does not include the SQL host variables. For dynamic SQL, IFI provides the original SQL statement. The RDISTYPE field contains the actual SQL function taking place. For example, for a SELECT statement, the DISTYPE field can indicate that an open cursor, fetch, or other function was occurring. For static SQL, you can see the DECLARE CURSOR statement, and the RDISTYPE indicates the function. The RDISTYPE field is mapped by mapping macro DSNXRDI.
Name
Section description
RDIIN
RDI parameters passed from precompiler to RDS
QW01242
SQL statement if the agent is at thread level and an SQL statement is present.
QW01243
Information about the SQL plan
QW01246
Agent information