0 votes
971 views
in Interview Questions by

2 Answers

0 votes
by (16.6k points)
You can use the TWSearch to search by Process Name and status completed to get a list of all such instances or directly query the LSW_BPD_INSTANCE table

select distinct LBI.BPD_INSTANCE_ID as value, LBI.BPD_NAME as name from LSW_BPD_STATUS_CODES LBSC, LSW_BPD_INSTANCE LBI, LSW_PROJECT LP where LBI.EXECUTION_STATUS = LBSC.STATUS_ID and LBI.PROJECT_ID = LP.PROJECT_ID and LBI.LAST_MODIFIED_DATETIME <= (SYSDATE - ?) and LBSC.STATUS_ID IN <#=tw.local.statusIN#> and LP.SHORT_NAME IN <#=tw.local.appIN#>

Then using the built in stored procedure provided by IBM delete such instances one by one in a loop

call LSW_BPD_INSTANCE_DELETE(?)

parameter is the instanceID
0 votes
by (1.2k points)
You can delete that by WAS server also.

Related questions

0 votes
1 answer 423 views
0 votes
1 answer 565 views
0 votes
2 answers 1.3k views
0 votes
3 answers 1.0k views
0 votes
2 answers 984 views
asked Aug 31, 2018 in BPD by anonymous
0 votes
1 answer 441 views
0 votes
1 answer 446 views
+1 vote
1 answer 777 views
0 votes
1 answer 219 views
+1 vote
0 answers 807 views
0 votes
0 answers 119 views
0 votes
0 answers 95 views

613 questions

493 answers

91 comments

2.0k users

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel
...