Deleting DTP LOCKED Req for OHD-3rd party tool
As a part of one of my scenario i had created a OHD with type 3rd party tool.Till yesterday it worked fine.Today PC got failed with exception DTP req locked.I understand that earlier DTP req failed and pc triggered the DTP again it causes the issue.Now i would like to know that is there any way to delete the failed req.I'm using IBM Data stage as a target the OHD.
Rambabu Thota replied
Issue resolved by myself.Moreover the the same steps as mentioned by Guys but the order of execution matters.
step1: Table RSBREQUID3RD->then make the status of the req to G.
Stpe2: Then to RSBKREQUEST-> then make the Ustate & Tstate of the req to 2
Step3: then to se38->RSBK_DEL_DTP_REQ_FROM_OHD->Mention the OHD and req then deleted.