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 |