We are always facing AWT exhausion on daily basis .Is there anyway we can identify how many AWTS are being used per session ?
Help is very much appreciated .
Not directly, you have to infer from the nature of the work being processed.
Load utilities are the first place to check, since those hold multiple AWT per AMP for the duration of the load. Long duration query steps would be next; particularly those that include a redistribution (since those need a sender AWT and a receiver AWT) or are doing insert/update/delete (need AWTs for Fallback maintenance).