SQL statement sequence numbers

A sequence number is assigned by Application Performance Analyzer to each unique SQL statement observed during the measurement. In most DB2® reports, this sequence number is preceded by either “S” or “D” indicating if the SQL statement is static or dynamic. Application Performance Analyzer will stop sampling when 99,999 unique SQL statements are observed. When this maximum is reached the observation request is cancelled with the reason ‘Maximum SQL statements exceeded’.