sysadmin sqm_zap_tran deletes a specific transaction from the stable queue and returns a message stating the number of deleted commands. The transaction is identified through the local queue ID (LQID).
sysadmin sqm_zap_tran {, q_number, | server [,database]}, q_type, lqid [, {L0 | L1 | L2 | L3}] [, {RSSD | client | “log” | file_name}]