Follow these steps to group SQLCODE information to locate problematic SQL activity of
On the DB2 Query Monitor main menu, type 2 in the
Option field and press Enter.
Type the appropriate command in the Group By field to refine the display
of information to suit your needs. For example, to group by Db2 authorization ID, type A in the Group By field and press Enter. The
SQL Code Summary panel groups SQLCODE information by authorization ID:
When you have refined the grouping of SQLCODE information
to locate activity of interest, you can issue line commands to drill
down into a line item. For example, you can issue the P line command
and press Enter to view plans associated with a line item.
To view the SQLCODEs associated with a line item, type S in the CMD
field and press Enter.
You can now view SQLCODE details by issuing the S line command.