Process stuck in posting - Posting (stuck).

Know it - 

DISTSTATUS 0 = None
DISTSTATUS 1 = Scheduled (N/A)
DISTSTATUS 2 = Processing
DISTSTATUS 3 = Generated
DISTSTATUS 4 = Unable to Post
DISTSTATUS 5 = Posted
DISTSTATUS 6 = Delete
DISTSTATUS 7 = Posting (stuck).

Find it -


select * from PSPRCSRQST where PRCSINSTANCE = '2152947' AND DISTSTATUS = 7
select * from PSPRCSQUE where PRCSINSTANCE = '2152947' AND DISTSTATUS = 7

Fix it-


UPDATE PSPRCSRQST SET DISTSTATUS = 5 WHERE PRCSINSTANCE = '2152947' AND DISTSTATUS = 7
UPDATE PSPRCSQUE SET DISTSTATUS = 5 WHERE PRCSINSTANCE = '2152947' AND DISTSTATUS = 7