According to the Performance Analysis for DB2 (PADB2) help file
Other Miscellaneous Wait (Seconds) - Time spent by the various sessions waiting for miscellaneous database operations.
Other Wait (Seconds) - Miscellaneous waits. This value should generally by very close to 0.
For some SQLs, the Other Wait metric are not close to 0 (refer to screenshot). What kind of wait events can lead to such big numbers in the metric?
Please open PA at the same time period and change the resource breakdown to "Other", then click on the "Wait event" link (refer to screenshot) and see which events were classified by PADB2 as "Other" for the same time of period.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center